This query can be used to list the CELDT test results with their part names (sorted by student name, test taken date, part): 

 

LIST STU IDN TST STU.ID STU.LN STU.FN STU.GR TST.ID TST.PT TST.SS TST.OT TST.TD TST.TA BY STU.LN STU.FN TST.TD TST.PT IF TST.ID  = "CELDT"  


This query can be used to pull CELDT test results with their teacher name and only the overall CELDT Score.


LIST STU IDN TST TCH STU.ID STU.LN STU.FN STU.GR TCH.TE TST.ID TST.PT  TST.OT TST.TD TST.TA BY STU.LN STU.FN TST.TD TST.PT IF TST.ID  = "CELDT"  AND TST.TD > "08/10/2016" AND TST.PT = 0 AND STU.LF = "L"