Skip to main content

Aeries- Secondary Queries

Remember that you don’t have to create a query for everything. A lot of things are already reports.

Below are some queries that others in NMUSD have found useful. There are more examples here.

Type of Query: LIST Command

Name: Student list by Grade
String: LIST STU ID NM SX GR BD BY GR

Name: Student list by Grade

String: LIST STU ID NM SX GR BD BY GR

Name: Master List of all Students with section number and teacher name of their 1st period class sorted by teacher
String: LIST STU SEC MST TCH STU.LN STU.FN STU.GR MST.SE TCH.TE BY TCH.TE IF MST.PD = 1

Name: List of student passwords by teacher and period (Replace teacher number (ie. 408) with your teacher number
String: LIST STU SEC MST TCH STU.LN STU.FN STU.GR STU.NID STU.ID MST.SE TCH.TE BY TCH.TE IF TCH.TN = 408 AND MST.PD = 1

Name:  "F" Query by TchName CrsTitle BegPeriod Sort TchName Course
String: LIST STU SEC MST GRD TCH CRS STU.ID STU.LN STU.FN TCH.TE MST.SE MST.PD CRS.CO GRD.M2 BY TCH.TE MST.CR MST.PD MST.SE  IF MST.SE = GRD.SE AND GRD.M2 : "F"

Name: List all students by alphabet, include SID#, gr, 1st period class, and 1st period teacher, for current quarter:  YR/S2/Q3
String: LIST STU SEC MST CRS TCH STU.GR STU.ID STU.LN STU.FN MST.SM MST.PD CRS.TM CRS.CN CRS.CO TCH.TE MST.RM BY STU.LN STU.FN IF MST.PD = 1 AND ( MST.SM = Y OR MST.SM = S OR MST.SM = 3)

Name: ELL Students
String: LIST STU TCH STU.NM STU.LF TCH.TE BY TCH.TE IF STU.LF = L

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: USE AT DISTRICT LEVEL: Reclassification By School and Grade IF Student Language Proficiency = R
String: LIST STU IDN LAC TCH STU.LN STU.FN STU.ID STU.GR STU.LF STU.SC LAC.RD1 TCH.TE BY STU.SC STU.GR STU.LN IF STU.LF = R

Name: USE AT SCHOOL SITE: Reclassification By Grade IF Student Language Proficiency = R
String: LIST STU LAC TCH STU.LN STU.FN STU.ID STU.GR STU.LF LAC.RD1 TCH.TE BY STU.GR STU.LN IF STU.LF = R

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: Students sorted by Grade
String: LIST STU FN LN ID GR BD BY GR

Name: Alpha/student teacher(Counselor)/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.U1 = X OR STU.SP = S

Name: 504 Students
String: LIST STU PGM STU.LN STU.FN STU.GR IF PGM.CD = 101

Name: Next Year Teacher Labels 
String: LIST STU LN FN NT \ AD \ CY ST ZC BY NT

Name: List Students Sort by Grade Last Name IF Grade = 9, Sex = F, and Birthdate contains 12/*/*
String: List STU TCH STU.LN STU.FN STU.ID STU.GR STU.SX STU.BD TCH.TE BY STU.GR TCH.TE  IF STU.GR = 9 AND STU.SX = F AND STU.BD : 12/*/*

Name: Mailing Labels by Course ID and period
String: LIST STU SEC MST "To the Parents of:" \ STU.FN STU.LN \ STU.AD \ STU.CY STU.ST STU.ZC  IF MST.CN = F0026 AND MST.PD = 6

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 Students with Total GPA (non-weighted) includes PE with Room number, teacher and grades 7 8 only. Period 6 (Change the numbers to fit your needs)
String: LIST STU SEC MST TCH STU.LN STU.FN STU.GR STU.ID STU.GTN TCH.TE MST.PD MST.RM BY STU.GR STU.GTN REV LN  IF ( GTN   3 OR GTN = 3 ) AND  GR 9 AND  MST.PD = 6

Name: Class rank by GPA for seniors only
String: LIST STU NM ID GR GP BY GP REV  LN FN IF GR = 12

Name: Students who did not receive a satisfactory mark in Citizenship.
String: LIST STU GRD GRH CRS STU.SN STU.NM STU.GR GRH.WM GRH.PD GRH.CN CRS.CO GRH.MK GRH.CI IF GRH.WM = 4 AND GRH.CI ; S

Name: Show inactive students between a certain date range
String: LIST STU SN LN GR LD TG IF LD 9/8/2009 AND LD 12/31/2009 AND TG = I

Name: Show inactive students between a certain date range and include locker number
String: LIST STU LKR STU. SN STU. LN STU.GR STU.LD STU.TG LKR.LK IF STU.LD 9/8/2009 AND STU.LD 12/31/2009 AND STU.TG = I

 

Name: List students with Release to Press (photos) marked "Yes"
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = Y
 
Name: List students with Release to Press (photos) marked "No"
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = N

Name: List students with Release to Press (photos) field left blank
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = " "

Name: List of students who do not have period 8th.
String: LIST STU SUP STU.LN STU.FN STU.ID STU.GR IF SUP.Q1 # "Pd8"

Name: GPA for 12th Grade students
String: LIST STU ID LN FN GR GP BY GP REV IF GR = 12


Type of Query: TOTAL Command

Name: Total students by grade
String: TOTAL STU GR BY GR

Type of Query: KEEP/SKIP Command

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 = 9 OR GR = 10 )

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 11-12
String: SKIP STU IF GR (use greater than symbol) 10

IMPORTANT NOTE: When complete with running keep/skip queries and/or reports, you must RESET the 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.

Contact Us