Inserting a SQL WHERE Clause - trillium_discovery - Latest

Inline Discovery

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

If you are creating a data source from a relational database management system (RDBMS), you have the option to selectively retrieve data by defining a structured query language (SQL) WHERE clause. For example, you might want to exclude data for a particular sales rep or region. The SQL WHERE clause you insert will be displayed in the Creation Rule metadata column in the Source Metadata view. The Creation Rule column will also be available in the list when choosing columns for view.

Note the following:

  • This procedure assumes you are familiar with the syntax for defining SQL conditions.
  • The Discovery Center does not validate your SQL syntax.
  • Extended SQL syntax is not supported.

To filter relational database data

  1. On the Configure tab of the Add Data Source window, click Insert SQL WHERE Clause. A text field replaces the Data Preview.
  2. In the text field, type the SQL WHERE clause. For example, type Country < > 'CANADA' 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.

  3. Do one of the following:
    • Click Insert to save the clause and reopen the Data Preview, updated to show the data rows that match the filter criteria. The clause displays above the preview.
    • Click Cancel to return to the Data Preview without saving a WHERE clause.
  4. To change the clause, click the edit icon ( ).