Profile Dropdown Showing Userlist From Specific Group

I need to create a user relationship between users using a dropdown list on user profiles.

In my company I have client users, and staff users. I need to assign a dedicated customer service rep to each client user. My solution was to create a dropdown list on the users profile that lists all staff members (from the staff member ACL group) and be able to select their customer service rep from there. Is this possible? This also needs to be searchable so that the rep can list any client that is assigned to them on the user list page.

If it's not possible, is there a different way to do this? Suggestions/solutions?

You can use CB Query Field and its Query Select fieldtype. This will allow you to generate a single-select fieldtype with its options pulled from a database query. You could create a query that queries for all the users with your staff usergroup. Example as follows pulls all Registered users, alter as needed.

Query: Value Column: user_id
Label Column: username

Should the example work as is mentioned above?

I get the following error on "Edit My Profile" once the field is published:
_____________
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`joom3_user_usergroup_map` AS grnLEFT JOIN `joom3_users` AS urnON u.`id` = g.`us' at line 1 SQL=SELECT DISTINCT g.`user_id`, u.`username`rnFROM `joom3_user_usergroup_map` AS grnLEFT JOIN `joom3_users` AS urnON u.`id` = g.`user_id`rnWHERE g.`group_id` = 2
______________

Sorry, my bad. It was just bad formatting.

I see a dropdown now, but nothing in it.

I changed the group ID and certain groups work (and show users within), but other groups don't. Strange.

Oh, I guess the users need to be directly within that group? Can't select a parent group?

It's only grabbing the users with the specific group id. So they have to have that usergroup. You can use an IN statement for multiple usergroups or whatever you like. Please note it's using usergroups and not view access levels. The provided example should give a list of every user with the Registered usergroup (ID of 2).