wp-query - Read For Learn

Sorting: custom query with orderby meta_value_num THEN by title

This is very crude but should sort your posts by year (meta_value) and then by title. It does depend on how the query is setup so it will only work with the query below or with similar ones. function alter_order_wpse_103181($order,$qry) { remove_filter(‘posts_orderby’,’alter_order’,1,2); $order = explode(‘,’,$order); $order = implode( ‘ ASC,’,$order); return $order; } add_filter(‘posts_orderby’,’alter_order_wpse_103181′,1,2); $q … Read more

How can I use order_by to order by two meta_keys without excluding posts that don’t have those keys initialized?

I had a similar issue but couldn’t solved with the snippets on this thread. I had to order a query by: all ‘featured’ posts first (is_it_a_featured_etf) and by a numeric field (etf_aum) in DESC order after the featured ones. My solution: ‘meta_query’ => [ ‘relation’ => ‘OR’, ‘etf_aum’ => array( ‘key’ => ‘etf_aum’, ‘type’ => … Read more

Querying posts from multiple sites in a network?

I know you said you’d rather not install a plug-in, but that’s exactly what you want to do in this situation. Placing the code in your theme’s functions.php file requires you to either use the same theme across all sites in the sub-network or maintain multiple copies of the same file. On the other hand, … Read more

get_queried_object() returns null on post date archive

so my question is, is this intended functionality (e.g. are you not supposed to use get_queried_object() on those pages), a technical limitation (is there not a meaningful object to return on those pages), or simply an implementation oversight? get_queried_object() is to get the term, author, single post, single custom post type, or page object being … Read more

How to make a WP_Query search with custom post types?

You are right, I tried it in a clean WordPress install and it works. Seems like one of the plugins I use in my environment is hooking itself in one of the pre-query events. Thanks!

Set Alias for meta_query arguments in get_posts()

Have a look at the meta_query_find_compatible_table_alias filter defined in wp-includes/class-wp-meta-query.php. This filter’s documentation: /** * Filters the table alias identified as compatible with the current clause. * * @since 4.1.0 * * @param string|bool $alias Table alias, or false if none was found. * @param array $clause First-order query clause. * @param array $parent_query Parent … Read more

Order by optional meta key?

Completely edited after first publish The problem is that to order for a meta value, WordPress need to ‘meta_key’ in query is set to something. But if you set ‘meta_key’ to something, then WordPress will add something like AND ( wp_postmeta.meta_key = ‘the_meta_key’ ) to WHERE SQL clause; and something like INNER JOIN wp_postmeta ON … Read more

Use the page slug in a WP_Query?

use pagename= to query by slug. See WP_Query for full list of valid arguments.

AJAX search on post pages by custom post type

Instead of ‘cat’ => 12 and $wp_query use ‘category_name’ => slug and get_posts(). Here is a basic example how it works: PHP add_action( ‘wp_loaded’, array ( ‘T5_Ajax_Search’, ‘init’ ) ); /** * Ajaxify the search form. */ class T5_Ajax_Search { /** * The main instance. You can create further instances for unit tests. * @type … Read more

What is “main query”? [duplicate]

Your filter has a bug in it, namely when you call is_main_query, you’re not checking if the passed query is the main query, your checking if the currently active query is the main query, which will always be true. So instead try this: add_action( ‘pre_get_posts’, ‘some_name’); function some_name($query) { if ($query->is_front_page() && $query->is_main_query()) { $query->set( … Read more

+ More