Technical Blog and Resources
PowerSchool Student Search Queries Operators
I am always trying to find these. Easy reference.
Search Operators
| Operator | Meaning | Example Usage | Example Explained |
| = | Equals | First_name = John | Finds all students named John |
| < | Is less than | Grade_level < 10 | Finds all students grade 9 and below |
| > | Is greater than | Graduation_year > 2012 | Finds all students graduating in 2013 and later |
| <= | Is less than or equal to | Grade_level <= 10 | Finds all students grade 10 and below |
| >= | Is greater than or equal to | Graduation_year >= 2012 | Finds all students graduating in 2012 and later |
| # | Does not equal | First_name # John | Finds all students named anything other than John |
| In | Is present in a list of values | First_name in John, Jane, Jim | Finds all students named John, Jane, Jim |
| Contains | A field contains a given value | Mailing_street contains First | Finds all students living on First Ave, First St, First Blvd, etc. |
| !contain | A field does not contain a given value | Mailing_street !contain ave | Finds students that do not have “ave” anywhere in their street address. This would exclude anyone living on an avenue as well as anyone on Dave Street. |