Queries are where you will define the exact data fields you are interested in returning from the database.
For example, a query is where you tell TDA that you would like to see the following information:
•Start Date
•Caller County
•Substance
•Medical Outcome
•Age
Keep in mind, a query is NOT where you define search criteria that filters WHICH cases are returned from the database, only which pieces of information are returned. If you are interested in limiting the number of cases to be returned, please refer to the section of this documentation.
Note: It is possible to embed search criteria into a query using the “Query Conditions” feature of the Query Designer. This concept will be discussed and should be used with caution as it may lead to unexpected results if you are not familiar with criteria layering in this fashion.