Script to retrieve all the active reports with filters details

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

Hi Rabin,

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

Regards,

Paul

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

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