The WP_User_Query allows meta_query searches exactly like the other WP_*_Query classes. Example here: global $wpdb; $author_search = new WP_User_Query( array( ‘role’ => ‘subscriber’, ‘fields’ => ‘all_with_meta’, // if it’s a digit/int/float, use ‘meta_value_num’ ‘orderby’ => ‘meta_value’, ‘order’ => ‘ASC’, // you could try -1 as well. ‘nuber’ => 99999999, ‘meta_query’ => array( ‘key’ => ‘my_userpoints’, … Read more
You need to use the user_search_columns filter to add the columns you want to search on. The user_search_columns filter is used to determine which user fields in the database are used when performing a search on user information. https://codex.wordpress.org/Plugin_API/Filter_Reference/user_search_columns
Brian is correct. By changing the form to use get instead of post and then using $_REQUEST to fetch it should work, and is for me. // Fetch, prepare, sort, and filter our data. if( isset( $_REQUEST [“s”] ) ){ // Form that displays the table and also contains the search_box() <form id=”table-class-filter” method=”get” class=”table-class-admin-form”>
Try this for kicks… Solution 1 Note: Does not work with WP_User_Query (?) add_filter(‘posts_distinct’, ‘user_meta_query_distinct’); //your query here… remove_filter(‘posts_distinct’, ‘user_meta_query_distinct’); function user_meta_query_distinct() { return “DISTINCT”; } Solution 2 Can you try adding ‘relation’ => ‘OR’ to your meta_query: $user_query = new WP_User_Query( array( ‘role’ => ‘member’, ‘orderby’ => ‘registered’, ‘order’ => ‘DESC’, ‘meta_query’ => array( … Read more
WP_User objects have some magic methods which do allow you to access any custom field: foreach ( $agents as $agent ) { var_dump( $agent->bio ); var_dump( $agent->get( ‘bio’ ) ); } The two are equivalent. More info: http://scribu.net/wordpress/the-magic-of-wp_user.html
Updated: The WP_User_Query class, in WordPress 4.1+, supports it with : ‘orderby’ => ‘include’ Since WordPress 4.7 there’s also support for: ‘orderby’ => ‘login__in’ and ‘orderby’ => ‘nicename__in’ So we no longer need to implement it through a filter, like we did here below. Previous Answer: I wonder if this works for you: add_action( ‘pre_user_query’, … Read more
You can simply use the date_query parameter on the user registration date: $args = array ( ‘role’ => ‘subscriber’, ‘date_query’ => array( array( ‘after’ => ‘2010-01-13 00:00:00’, ‘inclusive’ => true, ), ), ); $user_query = new WP_User_Query( $args ); This part of the WP_User_Query source code, makes it possible: // Date queries are allowed for … Read more
You can try this: /** * Add support for the “display_name” search column in WP_User_Query * * @see http://wordpress.stackexchange.com/a/166369/26350 */ add_filter( ‘user_search_columns’, function( $search_columns ) { $search_columns[] = ‘display_name’; return $search_columns; } ); where we use the user_search_columns filter to modify the available search columns. So what fields can we use with this filter? Here’s … Read more
They seems to work together, but note the AND part between the search part and the meta query part, in the generated SQL query. I wonder if you expected OR instead? Here are the generated SQL queries, for the two cases you mentioned: Search + Meta Query: SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN … Read more
You can not merge two different queries when the returned type is an object, because they have different methods and properties. Instead, you can get them as an array. Then you can merge them and compare the dates. For this, I’m going to use get_posts() over WP_Query(), and get_users() over WP_User_Query() to achieve this. The … Read more