Filtering Information in a List View - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

If the number of entries in the List View is long, you may want to filter it so it displays only the entries that are currently of interest.

Note: If you regularly apply a particular filter, create a business rule instead. The advantage is that business rules are saved, and filters are not saved.

To filter information in a List View pane

  1. Make sure you have the desired information in the List View.
    Note: You may want to click the Back icon (Previous icon) on the List View tab to clear the previous filter results. If the information you are looking for is not contained somewhere in the current List View, you will not get the results you expect.
  2. On the List View tab, click Filter icon, or right-click in the List View and select Filter. The Filter List View window opens.
  3. Construct the expression you want to use for the search.
  4. Click Filter.
    Note: If you are building a complex filter expression, it is a good idea to make a copy of it periodically. In the event that you need to modify it, you'll have the copied expression to work with. Filter expressions are not automatically saved. Highlight the Filter expression, right-click and select Copy. The next time you open a filter window you can right-click on the Filter expression and select Paste.

Example

This example shows how to find all rows in a List View where the substring of an attribute matches a specific value.

It uses an attribute named Code. The Code value is Jnnnnnn, and the 3rd position in the value indicates the product type. For example, in the value J555555, the product type is "5."

The following procedure uses the SUBSTR function to find all rows with a product type of 9.

To find all rows for the attribute "Code" that have a product type of "9"
  1. Open the Navigation View.
  2. Right-click the entity with which you want to work and select Drill down to Metadata.
  3. Double-click Rows. The Data Rows List View opens.
  4. In the List View, right-click and select Filter. The Filter List View window opens.
  5. In the expression elements list, click Functions.
  6. Click String in the middle elements list.
  7. Double-click SUBSTR in the right elements list. The expression SUBSTR(,,) displays in the upper pane.
  8. Place the insertion point before the first comma (,) in the expression.
  9. Click Attributes in the first elements list.
  10. Double-click Code. The attribute "Code" is inserted in the expression.
  11. Place the insertion point after the first comma.
  12. Type 3 to indicate the first position of the string. The expression looks like SUBSTR(Code,3,).
  13. Place the insertion point after the last comma.
  14. Type 1 to indicate the length of the string. The expression should now be SUBSTR(Code,3,1).
  15. Place the insertion point after the last parenthesis and type =. The expression looks like SUBSTR(Code,3,1)=.
  16. Place the insertion point after the = (Equals) character and type 9, where 9 indicates the product type for which you want to search. The expression looks like SUBSTR(Code,3,1)=9.
  17. Click Filter. The List View pane shows all values where the 3rd position of Code is equal to 9.