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.
Discussion posts and replies are publicly visible
Check the group() function document. By using the group() function, you can find other details using group id.
https://docs.appian.com/suite/help/24.3/fnc_people_group.html
Just to confirm, the group number that shows under approver column in the database. That is the number I need to enter?
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
[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")