Query only events that span multiple days

[Ilaria Roglieri]

Hi,
is it possible to query only events that last more than one day?
Thanks,
Ilaria

[Stephen Harris]

Hi Ilaria,

Unfortunately there is no API to specify this, but it should be possible by modifying the MySQL. Here is an example statement that pulls out all the event occurrences (and the underlying event’s post ID – that corresponds to the event post type in wp_posts table) for events where the start date of the occurrence is not the same as the end date:

SELECT event_id as occurrence_id, post_id FROM wp_eo_events WHERE DATEDIFF(EndDate, StartDate) > 0

You can either use that directly using $wpdb or there are WordPress filters that allow you to alter the SQL (i.e. posts_where) – note, that posts_where will apply to all SQL queries, so you would need to make sure you only apply the additional WHERE clause where you intend to.

[Author]

Posts