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
-
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.
-
(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.
-
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.
-
(Optional) Click Preview to review the results of the filter.
-
Click Next.