Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
5 subscribers
Views
1344 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
114727 - no subject - Hi, I would like to Create a Report with
deepanc
over 10 years ago
Hi, I would like to Create a Report with list of users and groups they are associated to. Can someone suggest me solutions...
OriginalPostID-114727
Discussion posts and replies are publicly visible
0
Navajith K
over 10 years ago
try this - getgroupmembership(), pass the group id and it will retrun all the users and groups associated to the group
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Navajith K
over 10 years ago
the above function will return user array, for groups use getmembergroups()
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
deepanc
over 9 years ago
Thanks Navajith. But I need to display the list of users in one column and Groups they are associated on the another column. Also this should get refreshed whenever a new user added to the group.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Navajith K
over 9 years ago
Deepan, Please try this.
Create a CDT with varriables groupName(Text) and userName(Text)
declare the multiple variable of type cdt.
"getallgroups()" will return all the group ID's in Appian, save it to array groupID
now in a multiple instance script task node pass groupID[tp!instanceindex]as a parameter to function getgroupmembership() and get all the users of each group and save it to varriable CDT.UserName.
Paralelly, get the groupname by passing cdt.groupid[tp!instanceindex]as a parameter to function getgroupattribute() and save it to CDT.groupName.
Now you have the username and the groupname corresponding to the user in the CDT Array, you can display it in a grid or use HTML Display functions to display it to the user. Give a refresh button on the page which will execute these nodes again and will get the new users added to the system. Hope this helps
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel