Identify a group by its group id stored in the database

Question

Hello, I am an APPIAN newbie and during my day to day activities get to query the backend data. Sometimes the app's request table in the SQL database shows a task assigned to a group and is displayed as follows: [Group:442658]. Question is: how can I track the actual Group by this number, and lookup its name and members? What is this number, is it a UID? 
 What permissions I need to have to query this information in the APPIAN designer? 
 Thanks in advance.

Kumar Agniwesh · Answer

First of all, if I understand correctly request table which are you talking about is specific to your instance. So we cant say with 100% accuracy that, this is the groupiD. But based on details shared by you, looks like that column is storing the group Id of the group. UUID is different then ID, ID changes from env to env. UUID remain consistent across env. Administrators can fetch the group details like users in group and all. Basic users shall be able to do that only if " Visibility" is set to public and "Privacy Policy" is set to low in properties

Soma · Answer

[Group:442658] is the Group Identifier. Yo can query this and use for any group related functions in appian. To know details on group based on its id, you can use group() 
 ex: group(442658,"groupName")

Identify a group by its group id stored in the database

Top Replies