How to list all groups of specific user in collaborator 9.4v?

Hello Rahulpinninti,

Collaborator doesn’t have such feature. But, you can try to use as a workaround the following steps:

1. Create a review.
2. In the Participants panel set the “Filter by” field to “No filter”.
3. Choose desired user in the “Participant” field.
4. After this, if you click again on the “filter by” field, you can see all of the user’s groups.

In addition, you can create a query to get all of the requested information. Here is the example:

SELECT "USER_NAME","GROUPDESCRIPTION_TITLE" FROM "PUBLIC"."GROUPDESCRIPTION","GROUPUSERS","USER" WHERE "USER_ID" = "GROUPUSERS_USERID" AND "USER_ID" = 2

As the result, you will get all of the groups for the user that have the second ID. You can find the list of users IDs using the “All Users” report.