Reporting on Parents Tasks Contain R1, R2, R3, etc.

[malcombenites]

How can I generate a report that only shows parent tasks names that contain R1, R2, R3 thru R20 only? I don't want to show the child tasks. The idea is to capture the number of revisions in a project based on the parent tasks alone. Any help is greatly appreciated. Malcom Benites Zimmerman Advertising LLC

[Doug_Den_Hoed__AtAppStore]

Hi Malcolm, Well son of a gun! I was going to break the bad news that I didn't think this was possible, but on a hunch, lucked out and found "https://support.workfront.com/hc/en-us/articles/217196097-Filter-and-Condition-Modifiers">this article in help.workfront.com and learned something new (which you could combine in a filer that also says "Number Of Children > 0" to avoid also bringing back the child tasks): cilike This is the case insensitive version of like . For example: 'cilike %Current% %Dead%' will return any notes that contain "Current to Dead" or "current to dead". This modifier can only be used in text mode filters. For more information about understanding text mode, see "https://support.workfront.com/hc/en-us/articles/216599038" "Understanding Text Mode." There were a couple of other surprises on the list, too: that url's definitely going in My Vault! @Narayan Raum , would you agree? Regards, Doug Doug Den Hoed - AtAppStore SEE you at LEAP using the GPS App! https://tinyurl.com/LEAPGPS Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[NRYNR]

Perhaps this would do the trick (you'll need to add some more OR lines to get everything through R20): numberOfChildren=0 numberOfChildren_Mod=gt name=R1 name_Mod=cicontains OR:1:numberOfChildren=0 OR:1:numberOfChildren_Mod=gt OR:1:name=R2 OR:1:name_Mod=cicontains Narayan Raum Workfront CoE Manager & Delivery Lead SunTrust Bank

[Doug_Den_Hoed__AtAppStore]

Good suggestion, Narayan, I've typically shied away from more that 4 ORs in a single clause (for performance), but expect that this one would be fine, because it's all going after a single target field. Regards, Doug Doug Den Hoed - AtAppStore SEE you at LEAP using the GPS App! https://tinyurl.com/LEAPGPS Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads