Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

How to determine Parameter/Category used in report

Avatar

12/9/22

Description - How to report on parameter /category used in reports?

Why is this feature important to you - As part of a clean-up activity in Workfront, it is pivotal to know what fields (parameters) have been used in report filters, other than on projects, tasks or issues.

How would you like the feature to work - Category ID or Parameter ID to be introduced under Report's report.

Current Behaviour - No such feature

1 Comment

Avatar

Community Advisor

12/12/22

@Ashutosh_Gupta16 

I have a report that may be what you're looking for - it's a parameter report.

In the filter, I use this text mode which shows me any fields that are not used on any forms:

EXISTS:1:$$EXISTSMOD=NOTEXISTS
EXISTS:1:$$OBJCODE=CTGYPA
EXISTS:1:parameterID=FIELD:ID

 

Then I have a column: Parameter >> Reports

This gives me any reports that parameter is used on - I believe it looks at filters, views, and grouping to determine if that field is used on each report.