Skip to content

Example Election Report

Example Election Report

When creating a report of members who have or have not voted in particular elections, you will need to use the ‘In Database/Not in Database’ functions when adding your criteria.

Once you have added in all of you required columns (ensure one of these is for the ‘organisaton_email’ from the Members table), you will need to add the following criteria:

  1. members.leaver_date, ‘Equals’, ‘0’ – (to capture only members who are currently enrolled);
  2. members.member_type, ‘Equals’, ‘S’ – (to capture only Student Members);
  3. members.id, ‘Not in database’ (for members who have NOT voted) OR ‘In database’ (for members who HAVE voted), and then the following in the value field:
member_id,election_votes

date|GREATER_THAN|unix timestamp (for votes AFTER a certain date and time)

**OR**

date|LESS_THAN|unix timestamp (for votes BEFORE a certain date and time)

If you would like a report between two date parameters, simply add both as done above, and shown in the image below.

Election Report

Updated on March 11th 2021