$field['event_start_date'] is created using min(wp_postmeta.meta_value)

[Natasha]

For some reason, which I am trying to discover, the posts_fields function defines event_start_date by getting the lowest meta_value from all returned with a post.

I’m using pre_get_posts to filter out a few categories, but I’d like to also use a meta_query, which breaks the main query because in the fields returned the ‘start date’ is not always the meta field with the smallest value. I’m occasionally getting values from ‘_EventDuration’, ‘_EventVenueID’, or ‘_EventOrganizerID’.

What is the logic behind using the min meta_value as opposed to the actual custom field ‘_EventStartDate’?

[Natasha]

Looks like my meta query was overriding the meta query where the key to use was being set. I’ve added

'relation' => 'AND',
			array(
					'key' => '_EventStartDateUTC'
			),

to the top of my meta query and it looks like we’re back in action.

[Geoff]

Excellent work! I’m so glad to hear everything is working smoothly and I appreciate you following up to let us know. Definitely keep us posted if any other questions come up and we’d be happy to help. 🙂

Cheers and have a great day!

Geoff

[Author]

Posts