Once you are finished Adding DAT Filter Conditions, 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.
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.