Search query designer
The Search query designer is the way in which you specify which data is extracted from the database for a Search and the columns into which the data is formatted. The Search specification is written in SQL format using either a section-based approach or a raw query.
Features
- Option to enter queries as either free text or in sections for ease of use
- Complete list of available tables and field names can be displayed
- Zoom in and out to increase or decrease the size of the font in the query designer window
- Press and hold Ctrl and use the mouse wheel to select the size you want to use when viewing the code
- Certain keywords and comments will default to highlight in colour:
- Green = Comments
- Blue = Reserved words (e.g. SELECT, Function, If)
- Violet/Pink = Functions (e.g. BeginQuery, Anchor, CBool)
- Grey = Quoted sections (e.g. "grey")
- Red = Selection Criteria (e.g. {pCurrent} )
Last edit 29/01/20