meta-query

Merge meta_value’s into a single row and then loop

It would appear simply un-serialising works: $results = $wpdb->get_results( $sql_str ); foreach($results as &$result) { $result-> my_custom_meta_values = unserialize($result-> my_custom_meta_values); } If anyone can suggest a more efficient way to do this, I’d be interested.

Get_term with meta_query

This is because you’re using a function to get the terms, but writing the meta_query for the posts — the meta_query will actually target terms instead. A couple of ways to solve this are: A custom SQL query Get all the posts from today, then loop through them and count up the use of each term … Read more

order by meta_key [duplicate]

Format of this meta is OK – it should work. I’m not sure what you’re doing in this query args, though. You use meta query incorrectly. If you do it like this, it should work fine: $my_query = new WP_Query( array( ‘author’ => $current_user->ID, ‘post_type’ => ‘tribe_events’, ‘orderby’ => ‘meta_value’, ‘order’ => ‘ASC’, ‘meta_key’ => … Read more

Sorting not working with get_posts

Hello bro try this will work ! $newsItems2 = get_posts( [ “post_type” => “post”, “post_status” => “publish”, “posts_per_page” => 3, “orderby” => “date”, “order” => “DESC”, “meta_key” => “news__type”, “meta_value” => “general”, ] );

meta_query and strange orderby behaviour

You could try $args = array( ‘post_type’=> ‘events’, ‘meta_query’ => array( array( ‘key’ => ‘_startdate’, ‘value’ => $today, ‘compare’ => ‘>=’, ‘type’ => ‘DATE’, ), array( ‘key’ => ‘_enddate’, ‘value’ => $today, ‘compare’ => ‘>=’, ‘type’ => ‘DATE’, ), ‘relation’ => ‘OR’, ), ); function jumpin_thru_hoops( $a ) { global $wpdb; $a = $wpdb->postmeta.’.meta_value+0 ASC’; … Read more

+ More