Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

infer attendance from roll call votes at an event #375

Closed
fgregg opened this issue Oct 17, 2023 · 1 comment
Closed

infer attendance from roll call votes at an event #375

fgregg opened this issue Oct 17, 2023 · 1 comment

Comments

@fgregg
Copy link
Member

fgregg commented Oct 17, 2023

if an event is missing attendance, but there are roll call votes, we could infer attendance from the roll call votes.

relates to #374

@derekeder
Copy link
Member

we tried searching for events that match this, but only one event came up from 2015:

select
  *
from
  event
  inner join eventagendaitem on event.id = event_id
  inner join eventrelatedentity on eventagendaitem.id = agenda_item_id
where
  entity_type = 'vote_event'
  and event.id not in (
    select
      event_id
    from
      eventparticipant
    where
      entity_type = 'person'
  )
limit
  10;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants