Filtering Relational Database Data
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. |