You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This will require building a system for exposing/selecting convention custom fields to be displayed on reports. For now, I've run the below query to solve the immediate need:
select
m.name, e.title,
(r.starts_at at time zone 'utc') at time zone 'EST' as start,
((r.starts_at + (INTERVAL '1 second' * e.length_seconds) )at time zone 'utc') at time zone 'EST' as end,
e.additional_info #>> '{"mask_policy"}'as mask_policy
from runs r
left join events e on r.event_id = e.id
left join conventions c on c.id = e.convention_id
left join rooms_runs rr on rr.run_id = r.id
left join rooms m on rr.room_id = m.id
where c.name = 'Intercon V'
order by m.name, r.starts_at
One other potential solution might be to implement that report via the CMS. I'll see if I can come up with a half-baked version of that over the weekend.
It would make sign making easier if the per room report could also show what the game's mask policy was. Thanks!
The text was updated successfully, but these errors were encountered: