The Search Builder page allows you to generate very complex reports on the database, or to help in the construction of ITL templates.
Select a Base Table to be the foundation for the report. Specify the maximum number of rows to be returned at once, and if you want the table to show only unique entries.
The Search Filter then allows you to narrow down the list of rows returned by matching columns of the table based on various criteria. Up to three separate conditions can be specified. The returned rows must match all criteria.
Finally, select any sorting options you wish the results to be displayed by and decide the list of columns you want returned.
Click Run to run the search immediately and display the results. Generate Definition will display an ITL tag which can be placed in a template and which will return the results when executed.