Query Staff based on the weekday that they teach.

Question

How can I create a query that filters staff based on schedule, for example I want to get all staff that have a schedule for Tuesday's, thanks

Answer 1

You can now query for staff based on the day of the week that they teach.

For example if you would like to query all staff that teach on Tuesday, simply go to the Query tab > Generic, by 'Choose table' select StaffSchedule and by 'Choose Field' select CSWeekday, now you would select 3 for Tuesday.