Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
You're not going to get the exact report you want, because Workfront's backend code doesn't store display logic rules on the custom field. Instead, it stores display logic rules on the form. The closest you can get to what you are describing is, "show me forms that use display logic, and how many display logic rules exist on each form." So you may have one field on the form that has three different rules applied to it, and this report will show "three rules" instead of "one field" because Workfront is counting the rules, not the fields. This can work better to inform how light or heavy a form is on display logic.
This is a Custom Form report in your report builder. You need to know how to add a text mode filter and text mode column in your view. I won't explain that because there are hundreds of other posts here that talk about it.
The filter for your report is:
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=CTCSRL
EXISTS:a:categoryID=FIELD:ID
EXISTS:a:ruleType=DISPLAY
And you'll need to add this column:
displayname=Rule IDs
listdelimiter=<div>
listmethod=nested(categoryCascadeRules).lists
textmode=true
type=iterate
valueexpression={ID}
valueformat=HTML
This will display a list of only custom forms that use any display logic. The number of long guids in the "Rule IDs" column equal the number of display logic rules used on the corresponding form.
Views
Replies
Total Likes
You're not going to get the exact report you want, because Workfront's backend code doesn't store display logic rules on the custom field. Instead, it stores display logic rules on the form. The closest you can get to what you are describing is, "show me forms that use display logic, and how many display logic rules exist on each form." So you may have one field on the form that has three different rules applied to it, and this report will show "three rules" instead of "one field" because Workfront is counting the rules, not the fields. This can work better to inform how light or heavy a form is on display logic.
This is a Custom Form report in your report builder. You need to know how to add a text mode filter and text mode column in your view. I won't explain that because there are hundreds of other posts here that talk about it.
The filter for your report is:
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=CTCSRL
EXISTS:a:categoryID=FIELD:ID
EXISTS:a:ruleType=DISPLAY
And you'll need to add this column:
displayname=Rule IDs
listdelimiter=<div>
listmethod=nested(categoryCascadeRules).lists
textmode=true
type=iterate
valueexpression={ID}
valueformat=HTML
This will display a list of only custom forms that use any display logic. The number of long guids in the "Rule IDs" column equal the number of display logic rules used on the corresponding form.
Views
Replies
Total Likes
Hey William, life has been a blur the last few days. We're in the middle of our instance split and we've had several long days. We're working with Doug Den Hoed and when he saw your reply he only had great things to say about you! Thanks so much for taking the time to share your solution. It is a great help verifying what we need to know. Take care and have an awesome weekend.
Views
Replies
Total Likes
Views
Likes
Replies