I’m not sure if this is possible but I’ll ask. We are looking at adding a UD field to replace a system field for dashboards and reports. Is it possible to do a search of all dashboards and reports that contains that field?
For example, we use JobHead.JobCode in lots of BAQs, Dashboards and Reports. If I want to add a UD field to JobHead and use it in place of the JobCode field in all those reports could I write a BAQ to search for all those items that need to be replaced.
Kind of weird but that describes my company.
Bravo sir! Thank you!!
Hello,
Sorry to open an old thread here but how can you tell what type of query it is? Like if I wanted to pull all SSRS reports and BAQs that use a specific field, I can set up this BAQ but how do you determine what each query type is?
This is only going to get you BAQs. Some of which might be used in SSRS reports, but not all SSRS reports use BAQs.
And knowing where a BAQ is used is harder. (I’m assuming that’s what you mean by type?)
Gotcha, I was thought this may look through RDD’s as well. I am trying to find a full list of BAQs and SSRS reports that use specific fields currently. I can use some other means to find the SSRS reports. Thanks!
You could potentially join tables like:
the BAQReport table - which provides BAQ Report IDs and their linked BAQ IDs
the RptTable table - Provides RptDefID and linked Query IDs
I haven’t pulled all these pieces together, myself, but I would look at joining one or both of those tables and see if your target query field matches against a specific BAQID in one of those tables.