|
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. |
EXAMPLE::
To retrieve tours that last more than 7 days, set WHERE Clause
property to:
num_days > 7
|
