You’re very close. First, make sure you’re using unique variable names. I have set $current_seeking_id for the meta key seeking_first and $current_team_id for the meta key team_manager. Next, you have to use these in your query to match. I’ve placed these variables at the value for your meta_query. This assumes that the seeking_first value matches … Read more
But once I try to look for other meta values, the return bring all members in the DB. Are you sure the meta other than name did not work, i.e. all members/users were returned? Because as I could see it, for your keywords, country and disciplines meta, so long as your compare value is good, … Read more
It was actually much easier than I originally thought – just doing a WP_User_Query for a meta value (meta arrays are supported as well, like for the other query classes). public function on_deactivate() { $meta_key = ‘tools_page_tsi_per_page’; $query = new WP_User_Query( array( ‘meta_key’ => $meta_key ) ); if ( empty( $query->results ) ) return; foreach … Read more
When executing the generated SQL statement in MySQL it gave me The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay To fix that I had to call $wpdb->query( ‘SET OPTION SQL_BIG_SELECTS = 1’ ); right before calling WP_User_Query.
the most basic wordpress user query […] is displaying that it has not found any users You’re passing an empty array of query arguments and there’s an explicit check for that in the WP_User_Query constructor: /** * PHP5 constructor. * * @since 3.1.0 * * @param null|string|array $query Optional. The query variables. */ public function … Read more
The problem here is that this query has pagination by default, and what you’re asking for is not scalable. For example, this query fetches 5 posts at a time, and displays the 6th page of users: $user_query = new WP_User_Query( array( ‘number’ => 5, ‘offset’ => 25 ) ); You can pass -1 to fetch … Read more
I gave it a test run. First, I added a custom capability to a specific user, using following code $user = new WP_User( $user_id ); $user->add_cap( ‘team_member’ ); Luckily, this user can be retrieved using below code, as you suggested $args = array( ‘role’ => ‘team_member’ ); get_users( $args ); Which implicitly work like below … Read more
The problem is that you can’t use the value for the LIKE comparison as you’ve mentioned. The generated SQL will look something along the lines of: AND CAST(wp_usermeta.meta_value AS CHAR) LIKE ‘%B%’ which means that the query is set to look for every occurrence of letter B in our case. Of course this is not … Read more
Combining a meta query with a search for a keyword will return posts which match both the search query and the result of the meta query (even if you’re using relation => OR in the meta query). This answer covers a way to achieve your expected outcome for posts, which – you need to modify … Read more
The ID column if the wp_users table is the Primary Key and auto-incremented. If your table isn’t set that way then something must’ve gone wrong while it was getting created. Try deleting all the tables from the database and re-installing WordPress.