How to Personalize CA Clarity PPM › How to Work with Lists › Filter the Lists › Build a Power Filter

Build a Power Filter

A power filter is a custom filter that searches a list page by criteria you define. Use a power filter alone or with other filter fields on the list page. Only one power filter can be created for a list page.

You design and build a power filter using an expression. The expression is divided into two parts, left and right, and separated by an operator, such as, =. For example, the expression to search for all active projects on the projects list page appears in the Expression text box as follows:

project.is_active == 1.

Follow these steps:

1. With a list page open, expand the filter.
2. Click the Build Power Filter link in the filter section.
3. Complete the following fields to build the left part of the expression:

   Note: The available fields are dependent on the page displayed.

   Object

   Specifies the type of object to filter. The page refreshes.

   Field

   Specifies the field to display in the Filter section. The page refreshes.

4. Select one of the following operators:

   Note: The operators that are available are dependent on the object and field values that are used for the left part of the expression.

   • =
   • !=
   • >
   • >=
   • <
   • <=
5. Complete the following fields to build the right part of the expression:

   Note: The fields that are available are dependent on the page displayed.

   Constant

   Specifies the constant for the field.

   Values: Yes or No

   Example: Select the Active field of the project object and use the equals operator, then select Yes as the constant. This combination finds all active projects.

   Object

   Specifies the type of object to filter. The page refreshes.

   Field

   Specifies the field to display in the Filter section. The page refreshes.

6. Click Add.

   The expression appears in the Expression field.

7. Select a value from the following field to create an equation with multiple clauses. For example, you can create a power filter with multiple clauses to display all active projects that are also assigned to a specific department. If you select a value from this field, create the additional clause for the expression and click Add. This action appends the clause to the value in the Expression field.

   And/Or

   Specifies the equation type for the second half of the expression.

   And

   Defines an equation with multiple clauses.

   Or

   Defines an either/or equation.

8. Complete one of the following steps:
   • Click Evaluate to evaluate the syntax of the expression. If the syntax is not valid, INVALID appears above the Expression text box.
   • Click Add Parenthesis to surround the expression with parentheses.
   • Click Negate Expression to negate the expression by surrounding the expression with parentheses and preceding it with an exclamation point.
   • Click Clear to clear the Expression text box.
9. Save your changes.

   The power filter is saved. The name appears in the Power Filter field of the page filter.

More Information:

Filter the Lists