Skip to content

Building a Query

Each query has four tabs.

Parameters — the prompts a user is asked for before running the query. See Parameters for the types available and how to configure them.

Description — a short name and description, plus a longer "what this is for" write-up. This is shown to help other people find and understand the right query to use, so it is worth filling in properly.

Details — housekeeping fields: tags, author, and sharing.

SQL — the actual SQL statement, for queries that are not Process queries. A Check Syntax button validates the statement against the database before you save.

Paritor - Winslade Park, Manor Drive, Clyst St Mary, EX5 1FY