Query to get list of the reports having hardcoded filter value

Pratiksha Rane shared this question 12 months ago
Answered

Can we get list of the report which has filters using Support Company or Support Organization or Support Group with hardcoded values ?

Please help us with query


Replies (3)

photo
1

Hi Pratiksha,

I'm not completely sure what you mean here without an example, but I assume you mean that you'd like some SQL to generate a list of Yellowfin reports that have filters in them, where those filters have the defined values of either 'Support Company', 'Support Organization' or 'Support Group'. Is that correct?

This is normally outside the scope of standard support, but this should give you the list of reports:

SELECT reportheader.reportname 
FROM reportheader 
JOIN reportfilter ON reportheader.reportid = reportfilter.reportid 
WHERE reportfilter.valuedataone IN ('Support Company', 'Support Organization', 'Support Group');

Kind regards,

Chris

photo
1

Hi Pratiksha,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?

Kind regards,

Chris

photo
1

Hi Pratiksha,


I hope things are going well with you.


Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.


Kind regards,

Chris

Leave a Comment
 
Attach a file