I am trying to execute a meta_query using the MB Custom Tables extension. I can echo the values from the table just fine and a standard archive works too, but when I try to build a custom query using a meta_query, I get no results.
Here is the query that works when using the post_meta table but not when using the custom table.
The Custom Table extension hasn't incorporated with the meta query yet. Please use 2 queries to get posts: 1 for getting post IDs from the custom table and one for getting posts. This is the sample code:
$post_ids = $wpdb->get_col( $wpdb->prepare(
"SELECT ID FROM your_table
WHERE obh_note_associated_members LIKE %s",
$query_args = array (
'post_type' => 'obh_note',
'orderby' => 'meta_value',
'meta_key' => 'obh_note_date_time',
'order' => 'ASC',
'post__in' => $post_ids,
$member_notes = new WP_Query( $query_args );