99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.

Main2026

Posted November 09, 2018

When following DAT Query - Step 1 procedures, you have an option to add conditions to any table in your DAT Query. The option to add conditions is presented:

- after DAT Query - Step 1 - Choosing Initial Table

- after DAT Query - Step 1 - Connecting Tables

- after you navigate to DAT > Queries > Query and click on any chosen table in your DAT Query

Note: The options for each condition are shown based on your school's data. For example, if you are looking to add a student grade level condition, the possible grade level options available will be based on the grade levels that are assigned to your students. Therefore, prior to adding a new condition, it is recommended that you have data in the system for that specific condition. If you are still in the beginning stages of implementation and may not yet have data for the condition you are trying to include, you can temporarily add data to a test record.

To add conditions to your DAT Query:

1. Specify condition criteria by:
- Selecting Field to add DAT Field Condition
- Selecting New Filter to create a brand new DAT Filter to add as a condition.
- Selecting Saved Filter to use a saved DAT Filter as a condition
- Selecting Calculated/Aggregate Field to add DAT Calculated/Aggregate Field Condition
2. Click Add to add the condition

3. Check “Parameterize” checkbox to turn any simple condition into DAT Parameterized Condition if desired

Repeat steps 1, 2, and 3 for each condition.

4. When you add more than one condition for the chosen table, you have an option to change how these conditions interact using parentheses as well as specifying AND or OR logical modifiers using the provided logical conditions box. If you make any OR conditions, be sure to include parentheses to ensure the order of operations are as desired. Note: The default behavior is to AND all conditions together.

Note: Click the Save button to save conditions and exit the table properties wizard.