Source: Pixabay.com
Advanced Custom Fields (ACF) is a very popular WordPress plugin. I've used it in almost every theme I developed. Recently in a project a requirement was to show one post from a collection of posts based on day and month the post author specified in the Post Editor. A post can be shown on multiple day and month combinations. So, to create the day and month field in the Post Editor I thought multiselect dropdown ACF field would be a good choice.
On the front-end I have to show the post based on current day and month, and also make two dropdown available for users to select DAY and MONTH to view prespecified post for that day and month combination. So, to get the specific post for the day and month combination I have to iterate through posts and search for post that has the month and day combination. But the problem is ACF saves multiselect dropdown or multiselect checkbox inputs as serialized array into wp_postmeta table in the database. MySQL recognize serialized data as string so, I haven't found any way out to check for them.
Also I needed to get the post using Ajax requests, so I needed to use API and WP API doesn't include ACF data or any meta data available through public API endpoints. I could use a plugin to solve the issue, but just for one post type I was not comfortable using a plugin for added overhead.
This is how it looks on the WordPress Editor.
After trying many things including exposing custom field data to regular API using register_rest_field but I could not settle on as it affected all the posts. I also wanted more control, so I was on my way to create a custom API route and serve data with custom callback function.
I created custom REST API route using the rest_api_init action and queried database using meta_query using WP_Query. As mentioned earlier MySQL treats serialized data as string, so I converted query strings as string and use LIKE to find if there any similarity between query string and serialized data on the database. I worked as expect.
You can find the source code on GitHub. I also provided the jQuery to load the post in the front-end from API. I hope it helps.
