Just to put here the suggestion that came up after discussing the requirement on chat.
Due to the complexity of user filtering/search required, the wordpress user data tables is not a very good place to store the user’s attributes. Instead it will make more sense to have a CPT and related taxonomies to store the user attributes required for the GUI, while maintaining basic information in the wordpress user table for login/authentication purposes.
Related Posts:
- Does WordPress Need BuddyPress to Handle Large Amounts of Users?
- user_login vs. user_nicename
- Difference between update_user_meta and update_user_option
- WordPress usermeta scaling for thousands of users
- get_user_meta() doesn’t include user email?
- Automatically delete inactive users after 2 months
- Is there an upper limit for users in WP?
- How to display custom user meta from registration in backend?
- Allowing an email as the username?
- Grouping users under parent user
- How to create a template for a custom URI associated with the user
- How to order users alphabetically by their last name?
- Performance tips for a large user base [closed]
- Extending WP_User class and using this sub-class during the whole lifecycle
- Wp_User_Query not sorting by meta key
- How we can get the user id by its display_name
- WP_User_Query with combined meta query – not working?
- How to use hyperdb to separate and share a user dataset between wordpress installs?
- LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
- \WP_User Object | What’s the Difference Between {caps} and {allcaps}?
- Show Biographical Info while creating new user
- include user profiles in search results?
- How to add follow functionality to multi-author wordpress site?
- Search multiple meta keys at once
- Where to Store Custom User Fields
- Plugin that would allow WordPress Authors to “follow” other Authors and query “Activity Info” from that
- Querying Email Addresses for a List of Users with Same Last Name?
- User profile custom field
- Front end user meta options for users
- ACF Upload Image in front-end with custom form
- Hide a user from WordPress
- Drop down list in user profile page
- Check for user meta data at Login
- Searchable meta value in user.php
- How to add country drop down menu to the user profile?
- Delete user from frontend
- Add custom fields to the user profile
- stop login if user_status equal zero
- Does wp_delete_user() remove all user content?
- WP User Query fails when searching meta queries and search columns
- Log all users out of all locations after 24 hours
- How can i create an array user meta?
- How to set show admin bar front to true for all users?
- Add user data to table when user is created?
- User Last Login Sort Column
- Updating user meta
- WordPress User Meta & ChromePHP or other way to debug/view php variables
- Use wp_update_user to update custom column in wp_users table
- Are User Levels Still Currently Used?
- WPML Default Language User Meta [closed]
- Display users in order by an “order” custom meta field
- Search Users base on meta_value & meta_key
- mysql query two database tables, users and usermeta and sort by custom meta int value
- Rest API code to get ID of current user not working: get_current_user_id() gives 0
- Updating wp_user_level on user update
- Should I encrypt the response that triggers an Ajax action? Is nonce sufficient?
- User Meta Data in a Sortable Table
- get_user_meta an ID for multiple functions
- How can I attach a user to another user with user meta
- Column Sorting Code on users.php
- Creating user without username and password
- List users by meta_key and meta_value
- Is this code true or not
- users and usermeta table
- WordPress SQL Issue not returning correct reselts
- User description only displayed for logged user
- The Simple and Correct Way to Add User Meta
- How to pull all the contributer users records and order by Designation (which is users meta data)?
- cannot get user_registered date from get_user_meta
- “the_author_meta(‘url’)” not working inside “href”
- Assign random (and unique) user meta upon registration
- Display the line breaks in user bio without using html
- how to set default update_user_meta values wordpress
- Get user by meta key – WP multi site
- Add custom user meta data
- Cannot Update user meta in custom field
- Can I Create a Second Admin Level User Role?
- How to add an attribute to a user?
- Adding fields to the “Add New User” but the form data not saved into DB
- New User Save Filter
- SELECT from wp_users, get Displayname too
- Assigning multiple or additional capabilities to specific users or how to create additional roles like bbpress roles?
- how do I add role and capability after I create a new user
- User Meta stuff
- What does “link” refer to when you delete a user?
- Is it possible to build social networking website using WordPress?
- delete_user_meta from a foreach results page
- How do I update user email from frontend input field?
- Reading additional fields in PMPro
- Can I add a unique code for each user based on the location?
- My custom user metadata is only active for only admin but i want it to be active on all users especially customers
- How to get image path from id using SQL
- Update user role for expired membership
- Getting user data via ajax
- Get UserInfo from WordPress
- How can i add user display name drop down menu in frontend?
- Hook into add_user_role and update based on new and removed roles
- How to prevent multiple user accounts with the same meta field?
- How to Moderate Edits to User Profiles?
- Safely changing UserID’s, re-using deleted UserID’s and automatically using deleted userID’s instead of an increment