Script to retrieve all the active reports with filters details

Rabin Tangbe shared this question 6 months ago
Answered

Hi Yellowfin Team


We are using Yellowfin 7.1.


I want to retrieve all yellowfin reports under certain category and filters associated with those reports.

Just wondering if there is any script I can run to retrieve this data.

Thank you.


kind regards

Comments (4)

photo
1

Hi Rabin,

Thanks for getting in touch. I believe something like this should provide you with what you need.

elect

a.reportname as "Report Name",

c.shortdescription as "Filtering on",

b.filteralertcode as "Type of Filter",

b.columnoperator as "Operator",

b.whereclauseoperator as "Clause",

b.valuedataone as "First Value",

b.valueunitcode as "Unit",

b.valuedatatwo as "Second Value",

b.sortorder as "Sort Order"

From Reportheader a

inner join reportfilter b on(b.reportid = a.reportid)

inner join reportfieldtemplate c on(b.fieldtemplateid = c.fieldtemplateid)

ORDER by a.reportname;

You can also add a Where clause to refine the result but change as required.

where b.filteralertcode = 'FILTER' AND a.reportname = 'PAULSREPORT' AND a.categorycode = 'TUTORIAL' AND a.subcategorycode = 'CAMP'


Let me know if this is what you are looking for and if this helps.

Regards,

Paul

photo
1

Hi Rabin,

Just touching base to see if you need any further help with this or is everything now okay?

Regards,

Paul

photo
1

Hi Rabin,

Just touching base as I have not heard back from you in regards to the question. Is everything now okay or do you need further help?

Regards,

Paul

photo
1

Hi Rabin,

I have not heard back from you in regards to this ticket, so I am going to assume everything is okay and will close this off for now. Please feel to get back in touch or re-open this as required.

Regards,

Paul