Support

May 18, 2013 at 10:32 am

Dan – I’m not an EE staff, but thought I’d share the way I use Eli’s Custom SQL reports plug-in for attendance reports.  A short code for a report is placed on a password protected page.  Until the move to the iPad app, they can print this out from the web page.  It works well for the “low-tech” staff and you could easily customize it to show any fields as needed.

Here’s one example attendance query:

SELECT

Concat((DAYNAME(ed.start_date)),’ ‘,(MONTH(ed.start_date)),’/’,(DAYOFMONTH(ed.start_date))) as Date, st.start_time as Start_Time,

CASE ed.category_id when “1” then “Canvas”

when “2” then “Clay”

when “3” then “Glass”

END as PartyType,

substring(ed.event_name,1,24) as Event_Name,

ea.coupon_code as Reference_Code,

ea.lname as Last_Name,

ea.fname as First_Name,

ea.Quantity,

ea.Phone

FROM wp_events_detail ed, wp_events_attendee ea,wp_events_start_end st

WHERE

ea.event_id=ed.id

and ed.id=st.event_id

and ea.payment_status=’Completed’

and ed.start_date >= CURRENT_DATE()

order by ed.start_date,st.start_time,event_name,last_name