Skip to main content
A
alir854
September 30, 2024
Question

Identify a group by its group id stored in the database

  • September 30, 2024
  • 4 replies
  • 0 views

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.

4 replies

Y
yogip3177
September 30, 2024

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 

    A
    alir854Author
    September 30, 2024

    Just to confirm, the group number that shows under approver column in the database. That is the number I need to enter?

    kumara0180
    kumara0180
    October 1, 2024

    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

      somasundaram.d
      somasundaram.d
      October 1, 2024

      [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")

        Terms & ConditionsAccessibility statement