A report or API call to find if a field is used on a filter

Question

Hi,

I know you can create a parameter report to list all reports a field is being used on.

1. Does this mean the field is in the filter or the view (or column)?

2. Has anyone been able to create a report to list filters a field is being used on? I have tried combinations between an API call or even the Data Lake to see if I can pull data.

Curious if anyone got close to this?

skyehansen · Accepted Answer

If you feel like experimenting, the community has offered up this as a potential solution (similar solutions could be built for views and groupings, once you figure out the syntax for filters.

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/filter-report/m-p/653581#M59112

KatherineLa · Answer

Here's how I do it in our instance. Sadly none of this is particularly pretty or human-readable, but is does expose the information you're trying to assess. What I show below is for an actual report, but you can add the same columns to a view to use in Setup as well, I've got the same set-up in the View/Group/Filter area under the Interface area too.

Report-Report - Screenshot below. Those three columns display the entirety of the text-mode behind that function on each report. Once you run the report, you can use the simple filter right on the report to put in the name of the field you're trying to locate.

displayname=View
valuefield=view:definition
valueformat=HTML

displayname=Filter
valuefield=filter:definition
valueformat=HTML

displayname=Grouping
valuefield=groupBy:definition
valueformat=HTML

Pretty it isn't, but it's saved me from breaking things quite a few times too.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded