Skip to main content

Elementary Queries

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

  • Type of Query: LIST Command 
    Name: Student list by Grade
  • 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 = " "
  • 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 )
  • 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
  • Name: Rsp/SPED/Speech
    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"

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.

Contact Us