How to sort posts by multiple meta keys in WordPress?

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 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

Is there a way to order posts in PHP?

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. But as always there are some restrictions. Put this code in your (child) theme’s functions.php or create a plugin with this code in it.

How to define the Meta key for orderby parameter in WordPress?

You can define the meta key for orderby parameter using the old method (I tested on WP 3.1.1)… This issue in general is cleared up in WordPress 4.2 by using named queries. e.g. For me, I wanted to order by a numeric field and I had to use ‘type’ => ‘NUMERIC’ inside the meta query.

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 create custom query with Meta key?

The main detail is: include meta_key, my code didn´t order unless meta_key is included, and that’s all: Here is the full code of a list of directors pictures order by director_weight:

How to order data by numeric value in WP?

I have read countless posts on ordering data by numeric value ( as opposed to string – it i have a numeric meta value and it gets ordered like this 1 11 12 2 233 etc as opposed to the way i want it I am using WP_Query have tried using meta_query => ‘NUMERIC’ but i’m not sure if that’s what it’s actually supposed to do

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.

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 data based on multiple columns?

Sort data based on multiple columns When you sort based upon multiple columns, the order or hierarchy of the sorting is based on the order that the columns were selected. To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit .

How to sort a table in descending order in Excel?

Descending order (text is Z-A, number is highest to lowest, and date is newest to oldest). To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit . For more information see Create, load, or edit a query in Excel.

How to query multiple meta key values in WordPress?

The queries in the OP will only return posts which have both key1 = ‘value1’ AND key2 = ‘value2’. Most WP plugins (that I know of, anyway) do not store multiple values in postmeta, for the same post, using the same key.

Can a query be ordered by multiple meta keys?

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. Here’s the details ( thanks Brian Krogsgard for reminding me of this ).

How do I sort by multiple meta keys?

Each of my meta queries has a key associated with it. For the numerical metadata I’m specifying ‘type’ => ‘NUMERIC’ so that when I sort using it, it uses ‘meta_value_num’ instead of ‘meta_value’ ( more info ). In the theme file, the dropdown menu adds a GET variable for specifying the sort order.

How to query posts with Meta key of post ID?

The topic ‘Query posts with a meta key of post ID whose post no longer exists’ is closed to new replies.

How to use WP _ query to display custom post type?

Or perhaps you want to present a wide range of dynamic content with custom fields, images, etc. The powerful WP_Query class makes fetching and outputting your posts on your website a breeze, and we’re about to show you how it’s done!

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.

Can you store multiple rows of post meta in WordPress?

WordPress permits you to store multiple rows of the same post meta for a single post, so you can get an array of data without needing to serialize it and store it in one key. To do this, you need to slightly change how you’re interacting with the post meta api here.

What do you need to know about post meta?

WordPress permits you to store multiple rows of the same post meta for a single post, so you can get an array of data without needing to serialize it and store it in one key. To do this, you need to slightly change how you’re interacting with the post meta api here. Something like this is what you’d want:

How to query posts and users by meta data?

You’ve learned how to get the values from the fields that store post and user meta data and how to construct queries for posts and users based on meta values. With this knowledge you can are prepared to work with a few custom fields and on your way to using WordPress as a complex content management system.

What’s the equivalent of WP _ query in WordPress?

Just like in the last part when we used WP_Query to find posts with certain values for various custom fields, we can use WP_Query ‘s user table equivalent WP_User_Query.

When to use pre get posts in WordPress?

Unless you are intimately familiar with these settings and are willing to coordinate them yourself, it’s suggested that you replace the main query by using WP_Query in the page.php or single.php (child) theme template files. pre_get_posts runs before WP_Query has been set up.

How to get posts by meta value in WordPress?

A more throughout example can be found in this answer. For more detailed guide regarding meta query follow this blog : http://www.codecanal.com/get-posts-meta-values/

Which is better get posts or query posts?

Each have parameters that reflect this difference in implementation. query_posts also uses WP_Query, but is not recommended because it directly alters the main loop by changing the variables of the global variable $wp_query. get_posts, on the other hand, simply references a new WP_Query object, and therefore does not affect or alter the main loop.

Where can I find the get posts function in WordPress?

You can easily grab the posts using WordPress’s built-in function called get_posts You can find more details about get_posts here https://developer.wordpress.org/reference/functions/get_posts/ Thanks for contributing an answer to WordPress Development Stack Exchange!

Is there a way to query posts in WP?

There are many ways to query posts in WP, however, this article will make use of the common get_posts function, WP_Query Object and pre_get_posts filter. If you are already familiar with the above function, object and filter you may skip this section.

How to query posts in ACF for custom fields?

The WP_Query object is used to query posts and will return an object containing an array of $post objects and many useful methods. The get_posts function makes use of the above WP_Query object, however, it only returns an array of $post objects making it a simpler way to find and loop over posts.

What is the WP _ query object in ACF?

If you are already familiar with the above function, object and filter you may skip this section. The WP_Query object is used to query posts and will return an object containing an array of $post objects and many useful methods.

Are there custom fields for the new meta _ query parameter?

As of this, some query parameters of custom fields like meta_key, meta_value were deprecated for the new meta_query parameter ( see here) 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.

Which is an example of a custom post type?

WooCommerce is an example of a plugin that registers a custom post type in order to work. In this case, it’s the “product” post type. Products listed in WooCommerce WooCommerce also registers some custom taxonomies and custom fields for you to organize your store, including product categories and product tags.

How to display custom post types in WordPress?

How to Display WordPress Custom Post Types in Your Site 1 Displaying the Post Type Archive. The first option you have is to create an archive page of all the posts in your custom post type archive. 2 Customizing the Post Type Archive. 3 Displaying Single Posts. 4 Adding Custom Post Types to the Main Blog Page.

How to query a list of posts using wpdb?

If you want really retrieve a list of posts rely on WP_Query using meta_query param. If you want to use $wpdb (I don’t know why) right query is something like:

How to query posts with meta value containing?

Change meta_value = %s to meta_value LIKE %s, and your query should work the same as though you used the full serialised string. it is also returning all the revisions, not just the most recent post. Make sure you specify the correct post type and status when querying your results.

How to sort array of posts in WP?

This article will demonstrate how to retrieve and sort an array of post objects from the database using native WP functions. There are many ways to query posts in WP, however, this article will make use of the common get_posts function, WP_Query Object and pre_get_posts filter.