Hide Forgot
Description of problem: Error received when trying to search users from specific usergroup from API Example: https://satellite.fqdn/api/v2/users?search=usergroup="Group Name" Version-Release number of selected component (if applicable): 6.2.X Steps to Reproduce: 1. Create a usergroup 2. Add user to the usergroup 3. Call the API https://satellite.fqdn/api/v2/users?search=usergroup="Group Name" Actual results: { "error": {"message":"PG::Error: ERROR: column \"member_type\" does not exist\nLINE 3: ....\"id\" = \"cached_usergroup_members\".\"user_id\" AND member_typ...\n ^\n: SELECT DISTINCT \"users\".\"id\", firstname AS alias_0, firstname AS alias_1 FROM \"users\" LEFT OUTER JOIN \"cached_usergroup_members\" ON \"cached_usergroup_members\".\"user_id\" = \"users\".\"id\" LEFT OUTER JOIN \"usergroups\" ON \"usergroups\".\"id\" = \"cached_usergroup_members\".\"usergroup_id\" WHERE (\"users\".\"auth_source_id\" NOT IN (2)) AND ((\"users\".\"id\" IN (SELECT \"users\".\"id\" FROM \"users\"\n INNER JOIN \"cached_usergroup_members\"\n ON \"users\".\"id\" = \"cached_usergroup_members\".\"user_id\" AND member_type = 'User'\n INNER JOIN \"usergroups\"\n ON \"cached_usergroup_members\".\"usergroup_id\" = \"usergroups\".\"id\" \n WHERE \"usergroups\".\"name\" = 'Group Name' ))) ORDER BY firstname LIMIT 20 OFFSET 0"} } Expected results: No error
*** This bug has been marked as a duplicate of bug 1395667 ***