(301) 947-7380
99.987%
uptime
·
0
security breaches
·
35+
years in education
·
Built and supported
in the U.S.
Knowledge Base
Support
Client login
Main2026
Platform
Student Information (SIS)
Finance & Operations (ERP)
Admissions & Advancement (CRM)
Intelligence
AI - Human in the Loop
Portals
Solutions
K-12
Higher Education
Performing Arts
Health Sciences
International Schools
Religious and Parochial
Camps and Auxiliary
Customers
Resources
vs Veracross
vs Blackbaud
vs Ellucian
SIS vs ERP vs CRM
State of School Operations 2026
Insights
Company
About
Careers
Press
Contact
/
Book a demo
Posted November 09, 2018
Managing DAT Filter Conditions
Once you are finished
Adding DAT Filter Condition
s, you have an option to indicate whether each
DAT Filter
condition will use “Must Have” or “Must Not Have” logic.
The most common use for “Must Have” or “Must Not Have” are to find students that have or do not have certain actions, attributes, or courses.
Example
: You want to find all the students who have submitted a contract for 2014/2015. When building your filter, search for students that have a “
Student Action
” with an “
Action
Description” of Contract Submitted, and an “Academic Year” of 2014/2015. Add your filter conditions, add your filter, then apply your filter.
Example
: You want to find all the students who have NOT submitted a contract for 2014/2015. When building your filter, search for students that have a “
Student Action
” with an “
Action
Description” of Contract Submitted, and an “Academic Year” of 2014/2015. Add your filter conditions, add your filter, change it to “Must Not Have”, then apply your filter.
When you add more than one filter, you have an option to change how these conditions interact using parentheses as well as AND or OR logical modifiers. If you make any OR conditions, be sure to include parentheses to ensure the order of operation are as desired.
Note
: The default behavior is to AND all conditions together.
See also
Adding DAT Filter Condition
Student Action
DAT Filter
Attribute
Action
Course
DAT
Platform
Student Information (SIS)
Finance & Operations (ERP)
Admissions & Advancement (CRM)
Intelligence
AI - Human in the Loop
Portals
Solutions
K-12
Higher Education
Performing Arts
Health Sciences
International Schools
Religious and Parochial
Camps and Auxiliary
Customers
Resources
vs Veracross
vs Blackbaud
vs Ellucian
SIS vs ERP vs CRM
State of School Operations 2026
Insights
Company
About
Careers
Press
Contact