How to sort query results by multiple meta keys?

How to sort query results by multiple meta keys?

For the meta queries, use the key you assigned to that query. You can also use any other sort method. Bill Erickson is a freelance WordPress developer and a contributing developer to the Genesis framework.

Can a WordPress query be ordered by multiple meta keys?

WordPress 4.0 allowed you to specify multiple orderby parameters and set the order of each independently ( details here ). But you could still only have one based on metadata since it requires the ‘meta_key’ parameter. For example: Luckily WordPress 4.2 takes this even further, so now we can easily order by multiple meta keys.

How to sort by Price in WordPress query?

The client wants Top Picks to always show up first. So if they select it to sort by Price (Low to High), it will first display all the Top Picks sorted by price low to high, then the other reviews sorted by price low to high. WordPress 4.0 allowed you to specify multiple orderby parameters and set the order of each independently ( details here ).

How to sort posts by multiple meta keys in WordPress?

WordPress doesn’t let you sort posts by multiple custom field values or keys if you’re using a meta_query. With a filter in your (child) theme’s functions.php you can order the posts with a new query parameter meta_query_orderby. The new parameter can be used in WP_Query and pre_get_posts.

How to sort results by price, rating and post date?

Users can sort the results by Price, Rating and Post Date. The client wants Top Picks to always show up first. So if they select it to sort by Price (Low to High), it will first display all the Top Picks sorted by price low to high, then the other reviews sorted by price low to high.

How to create custom query with orderby meta _ value?

I try to have a pretty simple query with the new syntax, query posts by a certain post_type (services) that contains a specified meta_key (order_in_archive)- this is going well as expected. But – I want to orderby the query by the meta_value, and with no success.

How to generate order by Meta key in WordPress?

Step 1 Assign whatever value you want to your meta key, let’s call it my_meta_key, for each post to generate whatever order you want. Step 2 You set meta_keyin your query to my_meta_key. This tells WordPress to query for posts that have that key.

How to query by meta value in WordPress?

This tells WordPress to query for posts that have that key. Step 3 Set orderbyin your query to meta_value_num. This tells WordPress to not only query posts with my_meta_key, but to also order numerically by that key. That query argument is the only place you will ever see or use meta_value_num. – MiloApr 25 ’17 at 18:21 2

Can a meta query be nested in WordPress?

“Starting with version 4.1, meta_query clauses can be nested in order to construct complex queries.” https://developer.wordpress.org/reference/classes/wp_query/#custom-field-post-meta-parameters So, that query should work on the current WordPress version. That seems to be impossible. Please someone correct me if I’m wrong.