meta-query - Read For Learn

User Meta Value not echoing despite Var_Dump Showing correct string

The $havemeta variable isn’t defined inside your shopping_location_text() function, so it isn’t available for use there. For a quick fix (or for testing/toying) you can move your code inside the function, like this: add_action( ‘woocommerce_before_main_content’, ‘shopping_location_text’, 10 ); function shopping_location_text() { global $current_user; get_currentuserinfo(); // wordpress global variable to fetch logged in user info $userID … Read more

Meta query compare for ID’s greater than specific ID

You can use prepare: global $wpdb; $post_ids = []; $last_id = 350; $query = $wpdb->prepare( ” SELECT ID FROM $wpdb->posts WHERE ID > %d “, $last_id ); $results = $wpdb->get_results( $query ); // it will convert the IDs from row objects to an array of IDs foreach ( $results as $row ) { array_push( $post_ids, … Read more

Check if searched number is within the post meta value

Assuming your “property-guests” taxonomies have names like “1”, “2”, “3”, etc.: <?php // Get the number of guests the visitor searched for $requiredGuests = $_POST[‘guests’]; // Get all terms in the “property-guests” taxonomy // (By default, this will only include terms that are assigned to something) $allGuestNumbers = get_terms(array(‘taxonomy’ => ‘property-guests’)); // Create a variable … Read more

WP_Query of custom post type sorted by meta_key has unexpected results

I think the issue is that it’s being interpreted as a STRING type and being ordered character by character. Maybe try turning this into a meta query and forcing the DATETIME type like the example shown below: ‘meta_query’ => array( ‘starttime’ => array( ‘key’ => ‘start_time’, ‘type’ => ‘DATETIME’, ) ), ‘orderby’ => array( ‘starttime’ … Read more

Get category if used in a custom post type

This would work. As posted by @bucketpress. $someposts = get_posts( array( ‘post_type’ => ‘work’, ‘posts_per_page’ => -1, ‘fields’ => ‘ids’, // return an array of ids ) ); $somepoststerms = get_terms( array( ‘taxonomy’ => ‘category’, ‘object_ids’ => $someposts, ‘hide_empty’ => true, ) );

Set both meta_query and tax_query using wp_query->set

Just use another set() method: if ($value[‘pRange’] && $value[‘tags’]) { $wp_query->set(‘tax_query’, array( ‘relation’ => ‘OR’, array( ‘taxonomy’ => ‘product_tag’, ‘field’ => ‘slug’, ‘terms’ => $value[‘tags’], ), array( ‘taxonomy’ => ‘product_cat’, ‘field’ => ‘slug’, ‘terms’ => $value[‘tags’], ), array( ‘taxonomy’ => ‘pa_branding’, ‘field’ => ‘slug’, ‘terms’ => $value[‘tags’], ), ) ); $wp_query->set(‘meta_query’, array( ‘relation’ => ‘AND’, … Read more

get_users with array as meta_value

First, can use meta_query, but, you should change your values to use the proper date format, e.g. 2020/01/02 for January 2nd, rather than a regional format. See https://en.wikipedia.org/wiki/ISO_8601 for more details. Second, your LIKE query is going to be very expensive, and achieving what you want while still using a LIKE query will be even … Read more

meta_query in WP_User_Query not working – returns every user, not just users where key & value matches

I’ve tried the meta query on another simple wordpress site, and it works there, so there must be something else going on, meddling with the query.. I’ve been doing some digging with the Query Monitor plugin… I thought it might have been because I’ve also been meddling with pre_user_query, but I can see that I … Read more

get_posts( $args ) return empty data

The whole problem was in WooCommerceCategoryExcluder (old, obsolete and unmaintained) plugin which hooks to pre_get_posts and adds taxonomy query to get_posts() args. Maybe this investigation helps someone else trying to solve similar problem.

Order by meta_key doesn’t work

Current Query $args = array( ‘post_type’ => ‘brands’, ‘meta_query’ => array( array( ‘key’ => ‘br_type’, ‘value’ => ‘Aviation’ ), array( ‘key’ => ‘br_category’ ), array( ‘key’ => ‘br_name’ ) ), ‘posts_per_page’ => -1, ‘orderby’ => [ ‘br_category’ => ‘ASC’, ‘br_name’ => ‘ASC’ ], ‘order’ => ‘ASC’, ‘fields’ => ‘ids’ ); produce this SQL query ‘SELECT … Read more

+ More