Create an advanced filter

You can create an advanced filter so that only the assets you need are shown in a view.

Important 

In Collibra 2024.05, we launched a new user interface (UI) for Collibra Platform! You can learn more about this latest UI in the UI overview.

Use the following options to see the documentation in the latest UI or in the previous, classic UI:

Steps

  1. Go to a table or set of tiles for which you want to create an advanced filter.
  2. Click to open the filter pane.
  3. In the filter pane, click Edit.
    Tip If the Switch to advanced button is shown, click it.
  4. Click Edit Filter.
  5.  Specify the filter criteria.
    Tip You can add multiple criteria using Add a FilterAdd filter criteria.
  6. In the Filter ruleFilter Formula field, specify how you want the filter criteria to be interpreted.
    Tip For more information, go to Filter rules.
  7. Click Apply.
Tip 

If you want to filter assets by a relation type and use an exclusionary logical operator, such as does not equal or does not contain, add two filter criteria, as shown in the following image.

Image of the advanced filter with the exists condition Image of the advanced filter with the exists condition

  • Criterion A ensures that the filter considers only the assets that have the specified relation type (Business Asset has acronym Acronym).
  • Criterion B ensures that the filter considers only the assets for which the acronym does not equal the specified value (CLV)—but within the subset of assets filtered by A.

Without the exists criterion, the filter results will include assets that do not have the Business Asset has acronym Acronym relation type, and this may not be helpful.

Image of the advanced filter without the exists condition Image of the advanced filter without the exists condition