I think you could simplify this a lot by using the pre_get_users hook, instead of working directly with the complicated SQL within the pre_user_query hook. Try something like: add_action( ‘pre_get_users’, function( \WP_User_Query $q ) { $qv = &$q->query_vars; if( isset( $qv[‘orderby’] ) && ‘test_date’ === $qv[‘orderby’] ) { // Custom meta query $qv[‘meta_query’] = [ … Read more
Here is a basic example of a user query I’m using that is working. Please note that I am using the role__in argument instead of the role argument. I’m not sure why the role argument wouldn’t work for you but I know this code works so hopefully it will work for you as well. $args … Read more
You’re setting two different meta_key fields to check on: ‘course’, and ‘clinic’. Try doing it with just one like so: $args = array( ‘orderby’ => ‘display_name’, ‘fields’ => ‘all’, ‘search’ => $search, ‘meta_query’ => array( array( ‘key’ => ‘clinic’, ‘value’ => $search, ‘compare’ => ‘LIKE’ ) ) ); What your current query is doing is … Read more
Diana you must change line of code in this array $args = array( ‘exclude’=> $admin_users_list, ‘number’ => $limit, ‘orderby’ => ‘registered’, ‘order’ => ‘desc’, ‘meta_query’ => array( ‘relation’ => ‘AND’, 0 => array( ‘key’ => ‘upme_user_profile_status’, ‘value’ => ‘ACTIVE’, ‘compare’ => ‘=’ ), 1 => array( ‘key’ => ‘upme_approval_status’, ‘value’ => ‘ACTIVE’, ‘compare’ => ‘=’ … Read more
I found a realy great solition here. !! It is a function that kindof ‘adds’ ‘orderby’ => ‘rand’ as a parameter. What it does it that when someone uses that parameter, the function will query the database using regular MySQL, where random is always possible 🙂 The function: // put this in your functions.php add_filter(‘pre_user_query’, … Read more
If you read the code (in version 4.5.2 on line 164-173) you will see that orderby can be an array of values, coupled with order. So you could modify $args like this: $args = array( ‘orderby’ => array( array (‘sticky’ => ‘DESC’), array (‘registered’ => ‘DESC’)), ‘fields’ => ‘all_with_meta’, ); Note that I know nothing … Read more
I was able to reproduce the error. Here’s what I think is happening. ‘number’ defines the number of users per page, and ‘paged’ tell the query which page to return. For example: $args = array(‘number’ => 2, ‘paged’ => 2) will return the second page at 2 per page. If you don’t have a query … Read more
Actually, I think your code says Where min_price >= $price and max_price <= $price. Try to switch the operands, like here: array( ‘key’ => ‘min_price’, ‘value’ => $price, ‘compare’ => ‘<=’, ‘type’ => ‘NUMERIC’ ), array( ‘key’ => ‘max_price’, ‘value’ => $price, ‘compare’ => ‘>=’, ‘type’ => ‘NUMERIC’ ), It works for 10.000 and 20.000 … Read more
Here is what I did and it worked for me: $current_day = date(“d”); $current_month = date(“m”); $args = array( ‘orderby’ => ‘login’, ‘order’ => ‘ASC’, ); // The Query $user_query = new WP_User_Query( $args ); // User Loop if ( ! empty( $user_query->results ) ) { foreach ( $user_query->results as $user ) { if ( … Read more
You can try: $number = $counter + ( $current_page – 1 ) * $users_per_page; with your increasing $counter variable in the loop. Here we assume $counter >= 0, $current_page >= 1 and $users_per_page >= 1. We might combine it into: $number = ++$counter + ( $current_page – 1 ) * $users_per_page; with $counter = 0 … Read more