Help

Query to list students periods on report

jsuchy
Journeyman

Query to list students periods on report

I have a query that had worked at one time to list where a student was in their classes/periods *periods period_info;1(a);teacher_name but now it is not working. Anyone know how to fix this? 

3 Replies
SAFFIYAT
Community Knowledge Manager
Community Knowledge Manager

Hi @jsuchy

One of the possible reasons would be if the Active term is set incorrectly, so we recommend checking if the Active Term is set correctly by navigating to Start Page > School > Current Grade Display (under Grading).



Saffiya Tasneem
Community Moderator

Remember to give Kudos to suggestions that help you!
If a suggestion helps solve your issue, please select Accept As Solution on the post so others can see the solution, too!
CherylBruning
PowerSchool Champion
PowerSchool Champion

*period_info;1(A-E);teacher_name double check your expression matches the schedules. 

Can you tell me if there is a way to query the teachers last name only or first last? 

KritiS
Community Support Expert
Community Support Expert

Hi @CherylBruning 

 

You can query the teachers last name and first last by directly searching for the teacher fields. You can refer to this document teachers-ver7-8-0.

 

Please let us know if this helps or in case of any further queries.



KritiS
Community Moderator

Remember to give Kudos to suggestions that help you!
If a suggestion helps solve your issue, please select Accept As Solution on the post so others can see the solution, too!