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
Please log in to participate..