A way to include whether game is masked or not in the per room report

[vogon999]

It would make sign making easier if the per room report could also show what the game's mask policy was. Thanks!

[dkapell]

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

[nbudin]

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.