Type of Query: LIST Command
Name: Student list by Grade
String: LIST STU ID NM SX GR BD BY GR
Name: Class list of students by teacher and by sex
String: LIST STU TCH STU.SN STU.LN STU.FN STU.GR STU.SX TCH.TE BY TCH.TE STU.SX
Name: ELL Students
String: LIST STU TCH STU.NM STU.LF TCH.TE BY TCH.TE IF STU.LF = L
Name: Gate Students
String: LIST STU PGM STU.NM STU.ID PGM.CD IF PGM.CD = "127"
Name: Last name First name student ID and Teacher
String: LIST STU LN FN ID TCH TCH.TE
Name: Address verification
String: LIST STU FN LN AD BY AD
Name: Looking for students with names that contain….. If last name contains:
String: LIST STU FN LN GR BY GR IF LN : HERNANDEZ
Name: Language Proficiency
String: LIST STU TCH STU.NM STU.LF TCH.TE BY TCH.TE IF STU.LF
Name: List of 6th grade students by next year school
String: LIST STU LN FN ID GR NS BY NS IF GR = 6
String: LIST STU TCH STU.LN STU.FN STU.U1 STU.U2 STU.U3 TCH.TE IF STU.U1 = X OR STU.U2 = X OR STU.U3 = X
Name: Students sorted by Grade
String: LIST STU FN LN ID GR BD BY GR
Name: Alpha/student teacher/grade
String: LIST STU LN FN TCH TCH.TE STU.GR
Name: EL Mailing Labels
String: LIST STU PG \ STU.NM \ AD \ CY ST ZC IF LF = "L"
Name: El Student info for labels
String: LIST STU STU.NM AD CY ST ZC IF LF = "L"
Name: Mailing Labels English
String: LIST STU "To the Parents of." \ FN LN \ AD \ CY ST ZC
Note: The backslash adds a new line
Name: Mailing Labels Spanish
String: LIST STU "Para los Padres de:" \ NM \ AD \ CY ", " ST " " ZC IF HL = 01
Name: Subgroup RSP SDC
String: LIST STU TCH STU.ID STU.LN STU.FN STU.GR STU.U1 STU.SP TCH.TE BY TCH.TE IF STU.GR 2 AND STU.U1 = X OR STU.SP = S
Name: Next Year Teacher Labels
String: LIST STU LN FN NT \ AD \ CY ST ZC BY NT
Name: Class List for (Elementary Schools)
String: LIST STU TCH STU.NM STU.GR STU.SX STU.PG STU.TL STU.FW STU.MW TCH.TE BY TCH.TE
Name: List of students with red flags under Contacts
String: LIST FLG STU STU.NM STU.GR STU.ID STU.RC1 FLG.CO IF FLG.TC = "CON"
Name: List of students with red flags under Supplemental
String: LIST FLG STU STU.NM STU.GR STU.ID STU.RC1 FLG.CO IF FLG.TC = "SUP"
Name: List of all teachers who teacher 6th grade students. This query pulls all 6th grade (U1 = 019) and 5th/6th grade (U1 = 018) teachers.
String: LIST TCH TLN TF SC BY SC U1 IF U1 = "018" OR U1 = "019"
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = Y
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = N
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = " "
Type of Query: TOTAL Command
Name: Total students by grade
String: TOTAL STU GR BY GR
Type of Query: SKIP Command
Name: Skip inactive students for class rosters
String: SKIP STU IF TG # '' "
Note: This will skip all student records with a status that’s not blank (e.g. “I” or “N”). Then run the Class Rosters.
Name: Skip Students in Grades 4-6
String: SKIP STU IF GR (use greater than symbol) 3
Type of Query: KEEP Command
Name: Display only female students
String: KEEP STU IF SX = F
Name: Using parenthesis with a KEEP statement
String: KEEP STU IF SX = F AND ( GR = 3 OR GR = 4 )
IMPORTANT NOTE: When complete with running queries and/or reports, you must RESET query by clicking the RESET button in the lower right corner of the Query form. “Records Are Being Skipped” will no longer display and further queries or accessing data will include all students. If reset is not performed, the only data accessible will be the query entered for the SKIP or KEEP command.