Start a new topic

Attendance Query

We are trying to build a query that will search students by how many times they are absent in a period. They want to be able to change the total amount for each period.


Has anyone built a query that they could share that will do that??/


Hello Wendy,


The Attendance Query Bank is a resource of various attendance queries.  Query banks are the first FAQ in each category in Freshdesk.  


Period ATT:  List of Absence Entries for a 1st Period Class on a Specific Date 

List of student Absence Codes for a 1st period section with Attendance Date on a Specific Date


This query was adjusted from the list of queries and is run for 1st period after a specific date - you can add/modify to reflect the periods you are searching for.  


LIST STU SEC MST ATT STU.ID STU.NM SEC.SE ATT.DT ATT.A1 IF ATT.DT > ##/##/20##


If you need further assistance, please submit a support ticket through Freshdesk.


Susan Prow

Aeries Support



I need a query that will allow me to pull the following data for the time frame of 11/2/21 - 3/4/22.  This is our T2 trimester.

  • Days Enrolled
  • Days Absent
  • Days Tardy>30 min
  • Days Tardy < 30 Min
  • Days Suspended
  • Days In-House Suspension


I used the following query but it seems to be pulling data for the whole year.


LIST STU LOC ATT AHS LOC.NM  STU.ID STU.FN STU.LN STU.GR AHS.YR AHS.SP AHS.EN AHS.PR AHS.AB AHS.AE AHS.AU AHS.TD AHS.SU AHS.ISS AHS.ISC AHS.ISI IF ATT.DT >= 11/02/2021 AND ATT.DT <= 03/04/2022


I've attached a file of the data I received.  


I need this as soon as possible because I am using it to populate our T2 report cards which go out next week.  I will need this no later than March 8, 2022. 


Thank you for your attention to this issue.

xlsx

Did Aeries ever resolve your date issue?  I am trying to run total tardies by period for each student from the start of school to the present day.  Thanks.

Login to post a comment