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
17 replies
Subscribers
7 subscribers
Views
5532 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I am working on report which displays list of users and associated role. I am ab
vineeta6579
over 9 years ago
I am working on report which displays list of users and associated role. I am able to get custom group id in grid. But when i am converting the customer group id to group name, for some of group its working but for other it gives blank result.
I am using below code to get convert group id to group name.
a!gridTextColumn(label:"Groups Id",field:"",data:local!totalgroupNumbersList),
a!gridTextColumn(label:"Groups List",field:"",data:getgroupnames(apply(togroup(_),local!totalgroupNumbersList)))
OriginalPostID-144869
OriginalPostID-144869
Discussion posts and replies are publicly visible
0
PhilB
A Score Level 1
over 9 years ago
At a guess, line 47 is actually producing an array of arrays; try changing the below:
fn!apply(getgroupsoftypeforuser(_,cons!CONS_FMS_CI_GroupType),local!totalusersList)
...to something like:
fn!apply(index(getgroupsoftypeforuser(_,cons!CONS_FMS_CI_GroupType),1,null),local!totalusersList)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@vahluwalia Please find the modified code. Try executing it and feel free to let me know if there are any issues.
ReportCode-
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 9 years ago
thanks sikhivahans .
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 9 years ago
so null check was missing ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
No problem, Well, I could give you an explanation, could you please let me know if the results are as desired by you?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 9 years ago
yes..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
Wonderful, please find attached the explanation and do let me know if you have any follow up questions. The explanation seems bit lengthier, but might help you tackling similar kind of issues. Hope it helps you.
Explanation.txt
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<