•  Address:
    44001 Garfield Road
    Clinton Township, MI
    48038
  •  Building Maps

Search Command Examples

Search Command Legend
Comparator Description
= Equals
< Is less than
> Is greater than
<= Is less than or equal to
>= Is greater than or equal to
# Does not equal (anything other than the search)
In One of the values is present in the field
contains Value is contained in the field
!contains Value is not contained in the field
@ Wildcard

The following student search command examples can be used from the start page in PowerSchool.

Search Command Examples

*birthday=today – Finds all students whose birthday is today, matching only month and day.

*birthday=5/1 – Find all students whose birthday is May 1

*birthday>=5/1/99;*birthday<=5/31/99 – Find all birthdays in May of 1999

*as_of=2/1/2006 – All students in the school that were active as of 2/1/2006

*not_enrolled_in_period=1 – All students not enrolled in period 1

*enrolled_in=9500 – Students in course number 9500

*enrolled_in=9500.5 – Students in course 9500 section 5

*as_of=2/1/2006 – All students in the school that were active as of 2/1/2006

*not_enrolled_in_period=1 – All students not enrolled in period 1

*enrolled_in=9500 – Students in course number 9500

*enrolled_in=9500.5 – Students in course 9500 section 5

*not_enrolled_in=9500 – Students not enrolled in course number 9500

*has_completed_course=9500 – Students who have at least one entry of course 9500 on the historical grades screen

*has_not_completed=9500 – Students who do not have any entries of course 9500 on the historical grades screen

*cumulative_credit_hours<15 – Students with less than 15 credit hours on their historical grades screen

*attendance_points>10 – Students with more than 10 attendance points

*attendance_points(Q2)>5 – Students with more than 5 attendance points in Q2

*attendance_points(1/1/2006,1/31/2006)>5 – Students with more than 5 attendance points for January 2006

*special_program=resource – Students in the Resource special program

*hours_requested<10 – Students who have requested more than 10 credit hours

*secondarystudents=all – A list of students in all grades who are taking classes in the current school, but not enrolled in the current school.

*secondarystudents= – A list of students in all grades who are taking classes in the current school, but not enrolled in the current school.

*secondarystudents=5 – A list of students in grade 5 who are taking classes in the current school, but not enrolled in the current school.

*allstudents=all – A list of students in all grades who are taking classes in the current school, including those students enrolled in the current school.

*allstudents= – A list of students in all grades who are taking classes in the current school, including those students enrolled in the current school.

*allstudents=5 – A list of students in grade 5 who are taking classes in the current school, including those students enrolled in the current school.