Find students enrolled in a class taught by a specified teacher

To create an advanced query a request to find a group of records that match specific criteria at a particular time to search for all students enrolled in a class taught by a specific teacher:

Note: This advanced query will only work within the Student List. After running the query, you will be able to create a snapshot a static picture of a particular group of records that you can file and easily retrieve of the results for use with various reports like report cards and the official school transcript.

1. Go to the School view.
2. Click the Student tab.
3. From the Options menu, click Query.
4. At the top of the Query pop-up, click Advanced Mode.
5. Under SELECT * FROM STUDENT, copy and paste the following:

WHERE STD_OID IN (

           SELECT TRN_STD_OID

   FROM STUDENT_TRANSCRIPT

  WHERE TRN_MST_OID IN (

 SELECT MST_OID

   FROM SCHEDULE_MASTER

  WHERE MST_SCH_OID = '[SCH_OID]'

    AND MST_STF_OID_PRIMARY = '[STF_OID]'

)

)

6. Replace the [SCH_OID] value in the query as follows:
• Go to the School view, click the School tab and then the Schedules side-tab.
• Hover over the desired school year, such as 2020-2021 (or right-click and select Properties or Copy Link Location).
• The following line appears in the browser’s status bar at the bottom of the window (or in the Properties pop-up or in your clipboard if you've copied it):

javascript:doParamSubmit(2100, document.form[‘contextListForm’], ‘SCH000000i0116’)

7. Replace the [STF_OID] value in the query as follows:
• Go to the School view and click the Staff tab.
• Hover over the desired staff name, such as Petullo, Anna (or right-click and select Properties or Copy Link Location). The following line appears in the browser’s status bar at the bottom of the window (or in the Properties pop-up or in your clipboard if you've copied it):

javascript:doParamSubmit(2100, document.form[‘contextListForm’], ‘STF0000000004e’)

8. Click Search. The results of your query appear.