...
Name | Description | Value |
|---|---|---|
| searchcaption | A title which is display at the screen | Any |
| sqltype | The type of SQL script | SELECT or SELECT DISTINCT |
| tables | A list of tables to be used in the Joins and fields sections | Any table name that exists in database |
| joins | A list of elements to join the tables | Join |
| fields | The fields that are used in select and where clauses | Field |
| wheregroups | A wheregroup groups together where conditions in the search file. | Wheregroup |
| groupby | Collect data across multiple records and group the results by one or more fields. | Any field name |
| orderby | Sort the query result set based on one or more fields. | Order By |
...