Bug 1400713

Summary: API search users per usergroup
Product: Red Hat Satellite Reporter: Christian Marineau <cmarinea>
Component: APIAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.2.2CC: andrew.schofield, bbuckingham, cmarinea, jcallaha, mhulan
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-12-12 13:50:04 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Christian Marineau 2016-12-01 22:23:22 UTC
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

Comment 3 Christian Marineau 2016-12-12 13:50:04 UTC

*** This bug has been marked as a duplicate of bug 1395667 ***