topic new user - how to pull a list of all students for a specific period along with their teacher in Community Forum

new user - how to pull a list of all students for a specific period along with their teacher

MichelleRoach — Tue, 01 Aug 2023 14:32:42 GMT

Hi all,

I am trying to figure out how to pull a report that contains a column of all students name, and a column with their teacher for a specific period that we designate. For instance, we have a HR course within our schedule, and not in the homeroom field, I would like to export a list of all students and their homeroom teacher. It seems easy if we had it corret in the field, but I do not know how to do this since it is set up as a course. Thank you for any help!

Re: new user - how to pull a list of all students for a specific period along with their teacher

ParatrooperJoe — Wed, 31 Jul 2024 01:02:26 GMT

Is their a way to split that teachers first and last name in the results? For example, instead of the result exporting it as "Appleseed, Johnny A" can we split it so it delivers result as "Appleseed","Johnny A"

Re: new user - how to pull a list of all students for a specific period along with their teacher

DSegal3440 — Wed, 12 Mar 2025 18:57:30 GMT

Can the teachers name be decode to view as "teachers first and last name"

Re: new user - how to pull a list of all students for a specific period along with their teacher

Scott_Hansen — Thu, 13 Mar 2025 18:57:22 GMT

If you want to go the SQL route, I think this will work for you: (expression is the period id)

SELECT s.lastfirst as student, teachers.lastfirst as teacher, cc.expression
FROM students s
inner join cc on cc.studentid = s.id
INNER JOIN sections on sections.id = cc.sectionid
INNER JOIN teachers on teachers.id = sections.teacher
WHERE cc.expression = '1(A-B)'
AND s.enroll_status = 0

Re: new user - how to pull a list of all students for a specific period along with their teacher

pevans877 — Fri, 01 Aug 2025 15:56:53 GMT

This is helpful, but what if I want the 1st block course number and name too?

Re: new user - how to pull a list of all students for a specific period along with their teacher

pevans877 — Fri, 01 Aug 2025 16:01:58 GMT

Nevermind, I realized I have to put multiple dat codes like below:

^(*period_info;1-2(A);course_number)
^(*period_info;1-2(A);course_name)
^(*period_info;1-2(A);teacher_name)