What I don’t really understand is how or what the ‘orderby’ => ‘meta_value’, is actually sorting by as the key has multiple values. It doesn’t have multiple values. It has a single value: a:2:{s:3:”day”;s:1:”8″;s:5:”month”;s:5:”March”;}` This is a ‘serialised array’. This is just a way to store an array as a string. As far as WordPress … Read more
Probably should have waited a bit but after posting the question I found a solution based on my points above and repeated here: https://codex.wordpress.org/Class_Reference/WP_Meta_Query https://generatewp.com/filtering-data-with-wp_meta_query/ My Solution: $metaSearchSubQuery = [ ‘relation’ => ‘OR’ ]; foreach($eventTypeId as $id) { $metaSearchSubQuery[] = [ ‘key’ => ‘EventId’, ‘value’ => serialize($id), ‘compare’ => ‘like’ ]; } $metaSearchQuery[] = $metaSearchSubQuery;
$query->found_posts may be what you are looking for from the code reference: https://developer.wordpress.org/reference/classes/wp_query/ Note that meta_query expects nested arrays, even if you only have one query. You may need to use: $meta_query[0][] = array( ….. You should also take care with the form of the original query. If there are one or more relations defined, … Read more
Get meta_value from GDRating
When using LIKE clause, you should be using % to the start and end of the value to make it match with the existing values. So your query should look like this. add_action( ‘pre_get_posts’ , ‘my_pre_get_posts’ ); function my_pre_get_posts( $query ) { $value=”%”.$_GET[‘s’].’%’; if( $query->is_main_query() && $query->is_search() ) { $query->set( ‘meta_query’, array( array( ‘key’ => … Read more
meta_query check multiple date formats
How can I create a meta_query with an array of dates?
Needs double quotes $WhoIsUser = get_users( array( ‘meta_key’ => ‘deviceid’, ‘meta_value’ => “$deviceid” ) );
Querying terms with calculations based on term meta data, sql vs. get_terms
Search for value(s) in meta field for a multi select