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
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):
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
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