Filtering - trillium_discovery - trillium_quality - 17.1

If the number of entries in the List View is long, you may want to filter the view to display only the entries that are of interest.

To filter the entries in the List View

1. From the Navigation View, double-click the object you want to review.

2. On the List View tab, click Filter, or right-click in the List View and select Filter. The Filter List View window opens.

    

3. Construct the filter expression. The Repository Manager filters use standard expression language.

   1. In the first element list, select Attribute. The second element list refreshes to display the list of all the attributes that are part of the current list. (In this context, the attribute is used as the column name in the List View.)

   2. Double-click the attribute on which you want to base the filter. For example, double-click User Name. The attribute name appears in the display area of the window.

   3. In the first element list, click Functions or Operators. The Filter List View window refreshes to display a third element list that contains categories of functions or operations.

   4. Double-click the operator or function that is appropriate for the expression you are defining. For example, select the equals sign (Operators > Comparison > =).

      Note: You can also select an operator by clicking its icon in the middle of the window.

   5. Complete the expression by entering a literal value in the display area, or using the expression builder to create the value. Continuing with the same example, type “Joey” in the display area.

      You now have an expression that looks like this:

      [User Name] = “Joey”

   6. (Optional) Use a logical operator to connect the expression you just created to another one.

   Note: When building a complex filter expression, it is a good idea to make a copy of it periodically. Select the expression and press Ctrl+C. If you need to backtrack to the saved version or use it as a basis for another filter, you can paste it into the display area of the Filter List View window.

4. Click Filter. The List View is updated to display only the entries that meet the conditions of the filter expression.