How to Limit Search Results

Previous Next

See Also

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.
4. Save.


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

num_days > 7