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

Lori Ivey shared this question 2 years 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.

Comments (2)

photo
1

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:


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

Please let me know if this works for you.

Regards,

Nathan

photo
2

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

photo
1

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!

photo