I could use a report of any existing reports that show fields that are filtered and the filter criteria.

Thanks,
nadecats
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2
yes you can!
And it is easy enough...
select TITLE,CATEGORY,DESCRIPTION,QUERY from SMARTY_REPORT
It shows you all reports and also the query, see pic ;)

Answered 06/07/2016 by: Nico_K
Red Belt

  • Just what I needed, thank you.
Please log in to comment

Answers

1
Initially I thought that this wouldn't be too difficult but the report tables are pretty complicated. If you have MySQL experience then check the following tables:
SMARTY_REPORT - stores the report definitions
REPORT_FIELD - stores report fields

Answered 06/03/2016 by: chucksteel
Red Belt

  • Unfortunately I don't know enough MySQL to get through this.
Please log in to comment
Answer this question or Comment on this question for clarity

Share