About queries

Last Updated : Apr 29, 2015 |

To complete the definition of a report's tables, charts, or fields, you must define the queries that select the rows of the appropriate tables in the CMS database.

What are queries?

Queries are values for either database items or calculations. In most cases, the queries specify the input variables, rather than specific values, as criteria to retrieve information from the database. The input variables allow CMS to use the values entered in the Report Input window as the query criteria for the report.

If you change the prompt in the Edit Inputs window, it is automatically updated in the query.

Queries provide the CMS server with the following information:

  • Where to get the data

  • How to use the data