Query Snippets

You often need to reuse parts of queries. For example a join between couple of tables or a constant that you use frequently.

To maximize query reuse you can now add a query snippet. With query snippets you define in one place all frequently used snippets which you then reference in your queries.
To use query snippets you simply open Query Snippets in the Tests folder and add a new snippet.

Here you define a snippet called ActiveSalesPerson.

To use your snippet, you just add {ActiveSalesPerson} to your query or click the Query Snippet toolbar button above your query.

You can limit snippets to specific systems and have separate snippets for development, test and production.

exMon Contact Us