CQL Reference

This section gives an overview of CQL including syntax from basic single field queries to advanced multi-field and multi-register queries.

CQL (Crisisworks Query Language) provides a way to build structured queries including multi-field and multi-register queries which can also be used in many ways including to export data and prepare reports.

The are two main ways to perform a CQL query are:

1. Using the search box within Register Filters (for field based filtering)

2. From the Search bar (for more advanced queries across one or more registers)

Both methods must be performed within a specific register.

For more general information on these methods refer to Searching & Filtering.

Queries are built by performing operations on fields. A full list of available fields can be found in the Data Dictionary.