# 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