-
Notifications
You must be signed in to change notification settings - Fork 2
Description
Currently the app database is created by inner-joining Matrix to Occupeye based on the location_id, thereby only counting rooms available on both. However, there are some rooms that aren't on Matrix, but are on Occupeye, so it would be useful to be able to report on those. This would require a dramatic change in the queries: rather than inner-joining, instead left join and filter WHERE roomtype = 'Meeting Room'. This is tricky as it affects multiple queries, but also because it means I'd have to rethink how to load the surveys table in. I initially designed it so that it gave only the Occupeye surveys with Matrix ids, so the shortlisting was automatic, but I'll either need to implement a manual shortlist interface like in Occupeye, or adapt the logic to give all meeting rooms for surveys with at least one room on matrix, depending on what Estates want.