Filtering Relational Database Data - trillium_discovery - trillium_quality - Latest

Inline Quality and Discovery

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

If you are creating an entity from a relational data source, you have the option to selectively retrieve data by defining a SQL where clause. For example, you might want to exclude data for a particular sales rep or region.

Note: This procedure assumes you are familiar with the syntax for defining structured query language (SQL) conditions. If you are not, refer to a SQL Reference Guide.
Note: Trillium does not validate your SQL clauses.
Note: Extended SQL syntax is not valid.

To filter relational database data

  1. When you create the entity, click the Add SQL WHERE clause checkbox in the Create Entity Wizard window, then click Next. The SQL Where Clause Entry window opens.
  2. (Optional) Click the Preview button to display a List View of the table you are using to create this entity. Note the exact names of the attributes you will be using to filter your data.
  3. In the text box, type the SQL where clause. For example, type Country < > 'CAN' to exclude data rows in which the country is Canada.
    Note: You do not need to type the word WHERE as part of the syntax.
  4. (Optional) Click Preview to review the results of the filter.
  5. Click Next.