Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
DAT Query - Step 1 - Adding Conditions
DAT Query - Step 1 - Adding Conditions
DAT Query - Step 1 - Adding Conditions
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.
See also
DAT Query - Step 1 - Choosing Initial Table
DAT Query - Step 1 - Connecting Tables
DAT Parameterized Condition
DAT Field Condition
DAT Query - Step 1
Grade Level
DAT Filter
DAT Query
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.