WP_Query – display posts by custom field and order by another

$q = new WP_Query( array( ‘meta_query’ => array( ‘relation’ => ‘AND’, ‘state_clause’ => array( ‘key’ => ‘state’, ‘value’ => ‘Wisconsin’, ), ‘city_clause’ => array( ‘key’ => ‘city’, ‘compare’ => ‘EXISTS’, ), ), ‘orderby’ => array( ‘city_clause’ => ‘ASC’, ‘state_clause’ => ‘DESC’, ), ) ); You can use this query for ordering, even with more than … Read more

ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)

This isn’t possible using WP_Query, you can’t query the insides of structured data stored in a single post meta value. At best you can use regular expressions, or do math/boolean comparisons, you can even do LIKE comparisons, but these are all string operations. If you need to query structured data such as objects or arrays, … Read more

WP_Query order by multiple meta keys & fields

You are using meta query without setting a value. The way you are doing it is using to query posts, not to order them. Using Named Meta Queries To order your posts by different meta datas, you can give your meta queries a name and then use that to set the ordering. Here is a … Read more