Another EXISTS story from The Twilight Zone: Mind. Blown. üí•
For the four of you interested nerds (and you know who you are)...
This li'l Task Filter beauty:
- finds all completed Tasks ("not null") that
- have at least one among several custom forms ("in")
- within a set of particular custom forms (":name", tab delimited)
- where, within those forms ("a:taskID") on those Tasks (":ID")
- a particular value ("2", which means checklist failed, in this case)
- is present ("EXISTS")
- in at least one dropdown among all of the parameters across all those custom forms (PVAL)
By following these simple conventions (which, by the way, return in seconds across thousands of such tasks, given the relatively low number of failed checklists), the SysAdmin can add new checklists and questions over time as the business evolves, and easily create insightful interactive charts for analysis and corrective action.
Workfront, after all these years together, you still find ways to surprise and amaze me...
Regards,
Doug
DE:Date Completed_Mod=not null
category:name_Mod=in
category:name=WP 9.35 Press Operations F OP 859 Checklist WP 9.35 Program Management F OP 860 Checklist WP 9.35 Safety F OP 862 Checklist WP 9.35S - Retool & Service Order F OP 861 Checklist
EXISTS:a:taskID=FIELD:ID
EXISTS:a:textVal=2
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=PVAL 💥
