How to list users and their prospective groups?
| ♥ 0 |
Trying to create an report in QCv10 Excel Reports in the Dashboard Module. I am trying to findout how to run a query joining the users and groups tables. The description for the US_GROUP field in the USERS table looks like a bit mask that specifies the groups to which the user belongs. If bit 1 is set, the user belongs to the group identified with GROUPS.GR_GROUP_ID = 1. etc, etc. Is there a way to decifer in SQL to get the user and their groups in the report? Any help you all can provide will be greatly appricated.
Marked as spam
|
Posted by |
Private answer
You are interpreting the process corectly. If bit X is set, the user belongs to the group identified with GROUPS.GR_GROUP_ID = X. So use this query for the Excel report. For SQL Server: For Oracle use: This will produce a report like this: User_Name / Group_Name Marked as spam
 Posted by sammyh (Questions: 0, Answers: 613) Answered on August 26, 2010 8:24 pm
|