Request:
Currently, when creating a filter for a Report, if you want to include an OR condition, you have to structure your criteria as a sum of products. This can lead to unwieldy, error-prone sets of criteria because of all of the duplication.
For example, consider that I want to filter based on the following criteria:
Portfolio = X AND Program = Y AND Company = Z AND (TPM = 'Mary' OR Sponsor = 'Joe') AND (Assignee = 'Cindy' OR Group = Foo)
To create a Workfront filter for this expression, the criteria would have to be structured as follows, where every variable is repeated 2 or 4 times:
Portfolio = X AND Program = Y AND Company = Z AND TPM = 'MARY' AND Assignee = 'Cindy'
OR
Portfolio = X AND Program = Y AND Company = Z AND TPM = 'Mary' AND Group = Foo
OR
Portfolio = X AND Program = Y AND Company = Z AND Sponsor = 'Joe' AND Assignee = 'Cindy'
OR
Portfolio = X AND Program = Y AND Company = Z AND Sponsor = 'Joe' AND Group = Foo
If I want to change it to be Program = Y', I would have to change that in 4 places. (Keep in mind that in the UI, things aren't as nicely structured as above--it ends up being 39 rows in the UI and being sure that you changed all occurrences of Program is not as easy to see.)
Benefit:
Decrease in the duration to create a report and improved data quality
