Support

Home › Forums › Custom Files Add-on (EE3) › espresso_table

espresso_table

Posted: November 25, 2013 at 8:33 am


James Simon

November 25, 2013 at 8:33 am

I have modified espresso table so that it returns the data and takes users to an alternative registration page. However, I need to be able to modify the SQL so it only returns DISTINCT class names. Anotherwards if I have a class where it is running for 20 different dates I only want it to be returned once. The reason is the alternative registration page will show all the dates that they can pick from.

Does anyone know how to modify the SQL so it returns DISTINCT events based on name of class?


James Simon

November 25, 2013 at 9:46 am

Figured it out. For anyone interested I guess you don’t use DISTINCT in mysql it is GROUP BY.

SELECT e . *
FROM wp_events_detail e
WHERE e.is_active = ‘Y’
AND e.start_date >= ‘2013-11-25’
AND e.event_status != ‘S’
AND e.event_status != ‘D’
GROUP BY (
e.event_name
)

The support post ‘espresso_table’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for the Custom Files add-on for EE3.
Documentation for Custom Files Add-on https://eventespresso.com/wiki/custom-files-add-on/

Status: closed

Updated by  James Simon 10 years, 5 months ago ago

Topic Tags

Notifications

This topic is: resolved
Event Espresso