No, it is not supported to use custom table meta with WP Query. You can query posts by getting the post IDs in the custom table.
global $wpdb;
$ids = $wpdb->get_col( "SELECT ID FROM your_table WHERE field1 = 'value1' OR field2 = 'value2'" );
if ( empty( $ids ) ) {
echo 'There is no posts';
} else {
$query = new WP_Query( [
'post_type' => 'post',
'post__in' => $ids,
] );
// Do something
}
Ok thanks, just checking before I start developing on this. Well thanks for the example but I am after using custom table meta and not the post ID. But I understand that I will have to grab the column values and then reference the post ID.
.
