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've launched a new user interface (UI) for Collibra Data Intelligence 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 criterioncondition for the filter:
    1. In the Characteristic field, select a characteristic.
    2. SelectIn the Operator field, select an operator.
    3. AddIn the Value field, add one or more values.
    4. To add another criterioncondition, click Add filter criteriaAdd Filter Condition, and then repeat the previous substeps.
  6. In the Filter ruleFilter Formula field, specify how you want the filter criteriaconditions 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 criteriaconditions, 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 Condition A ensures that the filter considers only the assets that have the specified relation type (Business Asset has acronym Acronym).

Criterion ConditionB 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 criterioncondition, 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