Query to get list of the reports having hardcoded filter value

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

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

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