Query Staff based on the weekday that they teach.

+2 votes
79 views
asked Mar 20, 2023 in New Feature by sruly
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

1 Answer

answered Mar 20, 2023 by sruly
selected Mar 20, 2023 by sruly
 
Best answer

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.

 

 

Let's Welcome our New Members

  • astauber of JLS - Mar 27, 2024

  • yaakova of Bnos Menachem - Mar 26, 2024

  • GElefant of YGZM - Mar 21, 2024

  • bmiskin of Yeshiva Gedolah Zichron Moshe - Mar 20, 2024

  • cungar of Kollel Chatzos - Mar 18, 2024

  • sstein of Masores - Mar 18, 2024

  • RochelPultman of Prospect Park Yeshiva - Mar 11, 2024

  • rlefkowits of talmud torah ohel yochanan - Mar 11, 2024

  • Barber739 of Bnos Menachem - Mar 10, 2024

  • Chani Schwarz of Yeshiva K'tana of Waterbury - Mar 07, 2024

...