After you add a table block to a report, you can set up filters to limit the information that displays in the table.
There are 3 components in a filter rule:
The field that contains the information by which you would like to filter your table .
The way that the filter determines which field values are included in or excluded from your table.
The values within your selected field that are evaluated according to the operator.
Example: If you wanted to limit results in your report to only display projects that are owned by Jane Doe, you could create a filter rule with the field “Project Owner,” the operator “Equal To,” and the value “Jane Doe.”
Or you could display only projects that have an assigned project owner, which would have the field “Project Owner” and the operator “Is Not Blank.”
Before you begin, you must enroll in the Reporting Canvas beta. For more information, see Reporting Canvas beta: overview.
Click the Main Menu icon in the upper-right corner of Adobe Workfront, then clickReporting.
Click New report.
Go to an existing report, click the More Menu icon in the report header, then select Edit.
To group rows on a new table, drag or double-click a table block onto the canvas.
To group rows on an existing table, click the Edit icon in the table header.
In the right panel, locate the field by which you want to filter your table, then drag it to the Filter section.
A filter rule set displays with the name of the field you selected.
Select the operator that you want from the drop-down menu:
This only returns an exact match of the searched value.
|Not Equal To||
This only returns results that are not exact matches of the searched value.
The field exists for the object but the field has not yet been given a value.
|Is Not Blank||
The field you are filtering for exists and has been given a value.
|Is Less Than||
This searches for all results with a value less than what is entered, without including the entered value.
|Is Less Than Or Equal To||
This searches for all results with a value less than or equal to the entered value.
|Is Greater Than||
This searches for all results with a value greater than the value entered, without including the entered value.
|Is Greater Than Or Equal To||
This searches for all results with values greater than or equal to the entered value.
Provides 2 required field values and searches for all results within range of both fields including the entered values.
This searches for the specified text throughout an entire text string.
For example, using "Contains Inf" captures anything with "Inf" or "inf" in it, such as the word "Infinity".
Note: Adobe Workfront searches for the entire word or phrase that you enter for each filter rule. For example, if you are searching for fields with the phrase "new project" in their name, Workfront does not display projects that have only "new" or "project" in their names, or phrases that contain extra words in between such as "new main project". The filter finds only projects with the exact phrase "new project" in the name.
|Does Not Contain||
This filters out items that are missing specified text.
For example, "does not contain inf" returns any fields without "Inf" or "inf" in their names.
Enter the last value to complete the filter rule, based on the operator you selected.
Values entered here are not case sensitive.
(Optional) To add another filter rule to your rule set, do the following:
Drag another field to the Drop to add another rule area in the Filters section below your other rule.
Repeat Steps 4-6.
In the operator drop-down left of the new rule, select AND or OR.
When you join filter rules or rule sets with the AND operator, you indicate that you want all rules at the same level to be met.
By default, the statements in a filter are joined by the AND operator.
When you join filter rules or rule set with the OR operator you indicate that you want at least one rule—or rule set—at that level to be met.
AND and OR operators at the same level—connecting either multiple rules within a rule set or entire rule sets together—will always match. For example, If you change the operator between two rules within a rule set, all other operators in that rule set will automatically change to match it.
(Conditional) To add an additional filter rule set, do the following: