Filter by 2 ACF field & Order by a custom date field
-
Hey Bill – great plugin, I use it lots – thanks ??
I am trying to display some Sugar Calendar Events posts, which have a start date field, which I’d like to use for orderby and also my ACF true false field, which I’d like to use to show featured events.
The ACF field is fine using meta_key=”featured_event” & meta_value=”1″.
How do I use the “date_column” as a “meta_value” to use in the “orderby” parameter?
Using 2 x “meta_key” seems to break the shortcode.
This is what I have so far…. I’ve removed all my double parameter usage to try keep it readable ??
[display-posts post_type=”event” meta_key=”featured_event” meta_value=”1″ date_column=”sc_event_date_time” orderby=”DESC”]
-
You actually need to use meta_query, not date_query, for querying those event dates. And unfortunately you can’t implement a query as complex as you need using the built-in shortcodes.
But this would be a great use case for adding shortcut arguments. If post_type=”event”, add all the necessary meta_query bits. Then if featured_event=”true”, add the additional meta_query for featured.
This is untested, but should work (or at least point you in the right direction): https://gist.github.com/billerickson/8cca1c914b769e0b5791dfd442b9d8be
- The topic ‘Filter by 2 ACF field & Order by a custom date field’ is closed to new replies.
