Is there a report or way to see everywhere a field is used?

Lori Ivey shared this question ago

Answered

Is there a report or way to see everywhere a field is used? I made a change to a field and I'm now struggling to find every report that uses that field to edit the query.

The same question

Replies (2)

Nathan Schroeder ●

Hi Lori,

Thank you for getting in touch. You will either need to adjust the pre-existing audit content to include field names, or you will need to query the underlying configuration database. I was able to achieve this with this query:

SELECT a.ReportName, c.ColumnName, a.reportstatuscode FROM 73yellowfin20170208.reportheader as a
INNER JOIN 73yellowfin20170208.reportfield as b
ON a.ReportId = b.ReportId
INNER JOIN 73yellowfin20170208.reportfieldtemplate as c
ON b.FieldTemplateId = c.FieldTemplateId

Please let me know if this works for you.

Regards,

Nathan

Reply URL

Bernard Anderson ●

I also added and a.reportstatuscode = 'OPEN' which the excludes any deleted reports

Reply URL

Nathan Schroeder ●

Bernard,

I have included this into the select statement. As you note, depending on your use case, this could also be very useful in a WHERE clause as well. Thanks for the input!

URL