Limiting Search Results

Web pages display search results within the ResultGroup. You can limit the number of records retrieved by adding a WHERE clause to the query that is sent to the database.

To limit search results by adding a WHERE clause:

1.	From the catalog, open the data page for which you want to limit the search results.

2.	In the object tree, double-click the TableDataSource object.

3.	In the Property Inspector, set the Where Clause property.

•Do not use the WHERE keyword.

•Use placeholders in the WHERE clause to refer to column values or text values.

•Use SHIFT+ENTER or CTRL+ENTER to create a new line if necessary.

Save.

Example

To retrieve tours that last more than 7 days, set WHERE Clause property to:

num_days > 7