Advanced filters
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:
Advanced filters are like basic filters in that they consist of one or more filter conditions. Advanced filters, however, use advanced logical operators. In a basic filter condition, the logical operator is "equals." In an advanced filter condition, the operator depends on the property, characteristic, or resource role that you select as the filter criterion.
The filter criteria are grouped as follows:
- Properties: All the asset properties in Collibra, for example, asset type, name, and tags.
- Attributes: All the asset attributes in Collibra, for example, definition, note, and quality.
- Relations: All the relations in Collibra.
- Roles: All the resource roles defined in Collibra, for example, Assignee, Business Steward, and Requester.
The following table contains some examples of operators per filter criterion type.
Filter criterion type | Operators |
---|---|
Text, for example, Name |
|
Boolean, for example, Certified |
|
Numeric, for example, Articulation Score |
|
Date, for example, Created On |
|
Resource role, for example, Business Steward |
Note If you select the logical operator "equals," you can select the value Current User to find all assets to which you have been assigned the specified resource role. This means that users might see different results in the same view depending on their responsibilities. Filtering by resource role and a specific user is extended to user groups that include the specified user, for the selected resource role. Example John Fisher is included in a user group named The Dream Team. There are a number of assets to which The Dream Team user group has been assigned as the Business Steward. If you filter a view by Business Steward and specify the user John Fisher, all such assets pass the filter. |
You can create a combination of conditions by using the AND and OR operators and parentheses in the Filter Formula box. The order of the conditions does not affect the results.
Depending on the logical operator, you can add multiple values. If you do so, the values are treated as an OR operator.
The filter shown in the following image finds assets that meet the following criteria:
- The assets have the asset type Business Term.
OR - The assets have the domain New Business Terms and one of the following statuses: Accepted, Approval Pending, Candidate.
The search feature does not recognize non-breaking spaces. Therefore, if the asset for which you are searching has a non-breaking space in its name, it will not appear in the search results if you do not include the non-breaking space in your search text.
Suppose that you have a Snowflake data source and one of the tables in the database has a non-breaking space in its name. When this table is ingested into Collibra, the name of the corresponding Table asset in Collibra will also have the non-breaking space. If you try to search for the Table asset by typing its name in the search field, it will not work because you cannot replicate the non-breaking space. Instead, you can copy the table name directly from Snowflake—thereby capturing the non-breaking space—and paste it into the search field in Collibra.