Advanced search
You can use the advanced faceted search feature based on the Talend Query Language (TQL) to search more efficiently among your list of datasets.
Information noteNote: This feature becomes available for Talend Cloud Pipeline Designer users when Talend Cloud Data Inventory is enabled for the
account.
From the dataset list, click to enable the TQL search field. TQL allows you to accurately search for relevant datasets using a combination of facets and operators. After entering a facet and operator, simply type the value you are looking for between simple quotes.
| Facet | Description |
|---|---|
| connection.type | Type of the connection on which the dataset is based |
| connection.name | Name of the connection on which the dataset is based |
| entity.attributes.Enum.<attribute id> | List of all the enumeration type custom attributes defined beforehand |
| entity.attributes.Text.<attribute id> | List of all the text type custom attributes defined beforehand |
| description | Description of the dataset |
| name | Name of the dataset |
| tags | List of all the tags that have been applied on the datasets of an account. |
| globalQuality.valid | Number of entries that are considered valid against the column types in the dataset sample |
| globalQuality.invalid | Number of entries that are considered invalid against the column types in the dataset sample |
| globalQuality.empty | Number of entries that are empty in the dataset sample |
| trustScore | Talend Trust Score™ value of the dataset |
| apiStatus | For a given dataset, an API can be Enabled, Disabled, Unconfigured, or Unsupported. |
| crawler | List of all the datasets created using a specific crawler |
| Operator | Description | Example |
|---|---|---|
| = | Returns values that exactly match the specified value | name = 'Season 2018/2019 results' |
| > | Returns values that are greater than or equal to the specified value | trustScore > 3.50 |
| < | Returns values that are less or equal to the specified value | trustScore < 4.20' |
| != | Only returns values that do not match the specified value | connection.type != 'Salesforce' |
| ~ | Returns values that match the specified regular expression | description ~ '201[0-9]' |
| contains | Returns values that contain the specified value | description contains 'Talend' |
| containsIgnoreCase | Returns values that contain the specified value regardless of the case | connection.name containsIgnoreCase 'tAleND' |
| and | Returns values that match all the specified values | name contains '2019' and connection.type = 'MySQL' |
| or | Returns values that match any of the specified values | connection.type = 'Kafka' or connection.name contains 'Kafka' |
| in | Returns any of the values from a specified list | connection.type in ['Amazon S3', 'HDFS'] |