Identify a group by its group id stored in the database

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

Parents
  • 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

Reply
  • 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

Children
No Data