Forum Discussion
NingLi
6 years agoQrew Trainee
Hi Brandon,
Thank you very much for your reply!
Yes, I was able to see the list of all reports in App Management. It contains name, type, group, last used, used count, owner, report ID. However, I am looking for queries, the queries that create the reports. such as "billing category = supplier follow up AND date after 1/1/2019" ...........
I think the queries can provide more information to allow me make decision to keep it or delete it. Any suggestions to list queries? Thank you.
------------------------------
Ning W
------------------------------
Thank you very much for your reply!
Yes, I was able to see the list of all reports in App Management. It contains name, type, group, last used, used count, owner, report ID. However, I am looking for queries, the queries that create the reports. such as "billing category = supplier follow up AND date after 1/1/2019" ...........
I think the queries can provide more information to allow me make decision to keep it or delete it. Any suggestions to list queries? Thank you.
------------------------------
Ning W
------------------------------
BrandonDrake
6 years agoQrew Cadet
Ok, gotcha. That is the only way I know of showing all reports and then clicking to view the report to see specifics, which I understand is cumbersome and time consuming if you have a bunch to go through. May be a good candidate for an improvement recommendation, if it is not already, to add a field that displays the filter criteria... Sorry I couldn't help more.
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
- NingLi6 years agoQrew TraineeHi Brandon,
Thank you so much. Yes, I have hundreds of reports to go through. For now, I just review them one by one. It takes time, but still work. Thank you.
There might be some API_GetSchema can do this. It'e beyond my current knowledge.
------------------------------
Ning W
------------------------------