...
Name | Description | Value |
|---|---|---|
| searchcaption | A title which is displayed on 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 the database |
| joins | A list of elements to join the tables. | Join |
| fields | The fields that are used in the select and where clauses. | FieldsField Item |
| wheregroups | A wheregroup groups together where conditions in the search file. | Wheregroup |
| groupby | Collects data across multiple records and groups the results by one or more fields. | Any field name |
| orderby | Sorts the query result set based on one or more fields. | Order By |
...