WP Query: orderby with one meta key, but multiple values

Use this code instead- $supplierArgs = array( ‘post_type’ => ‘service_providers’, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘service_provider_tier’, ‘value’ => ‘G’, ‘compare’ => ‘=’ ), array( ‘key’ => ‘service_provider_tier’, ‘value’ => ‘S’, ‘compare’ => ‘=’ ), array( ‘key’ => ‘service_provider_tier’, ‘value’ => ‘B’, ‘compare’ => ‘=’ ), ), ‘orderby’ => ‘meta_value’, ‘meta_key’ => … Read more

Sort wp_query of two post types using meta datefield for one and date for the other – possible?

Try this WP_Query arguments: $args = array( ‘post__in’ => $all_ids, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘_event_date’, ‘compare’ => ‘EXISTS’, ), array( ‘key’ => ‘_event_date’, ‘compare’ => ‘NOT EXISTS’, ‘value’ => ‘dummy_value’ // This is just to ensure this condition gets evaluated. ) ), ‘orderby’ => array( ‘meta_value_num’ => ‘DESC’, ‘date’ => … Read more

Group users by meta field, with name of meta field as group title

i need to return/echo the name of the department/location for each group of employees That is actually a generic PHP/programming question, nonetheless, if you mean an output which looks like so: Location/Department Name – Employee/user – Employee/user – Employee/user Location/Department Name – Employee/user – Employee/user Then here’s one way of accomplishing that: Add this above/before … Read more

Removing filename searches when searching attachments

Approaching this from the SQL is a mistake, and instead a quick search of the official dev docs for filename reveals a filter named wp_allow_query_attachment_by_filename that is set to true by default: https://developer.wordpress.org/reference/hooks/wp_allow_query_attachment_by_filename/ apply_filters( ‘wp_allow_query_attachment_by_filename’, bool $allow_query_attachment_by_filename ) Filters whether an attachment query should include filenames or not. This means you can disable querying filenames … Read more

How WP determines archive page vs single page?

TL;DR: WordPress uses URL query string variables to select a template based on the Template Hierarchy. General template selection steps Permalink structures are used to create rewrite rules. Rewrite rules take a pretty permalink URL and convert it into a plain URL with a query string. Parameters from the query string are used to choose … Read more