Inserting a SQL WHERE Clause - trillium_discovery - Latest

Trillium Discovery Center
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
ft:locale
en-US
Product name
Trillium Discovery
ft:title
Trillium Discovery Center
Copyright
2024
First publish date
2008
ft:lastEdition
2024-10-18
ft:lastPublication
2024-10-18T14:55:05.094000

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 ( ).