topic Re: Query to list students periods on report in Community Forum

Query to list students periods on report

jsuchy — Thu, 25 Aug 2022 14:05:17 GMT

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?

Re: Query to list students periods on report

SAFFIYAT — Fri, 02 Sep 2022 20:10:13 GMT

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).

Re: Query to list students periods on report

CherylBruning — Thu, 27 Jul 2023 01:13:09 GMT

*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?

Re: Query to list students periods on report

KritiS — Fri, 04 Aug 2023 18:02:17 GMT

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.