I am working on report which displays list of users and associated role. I am ab

vineeta6579 over 10 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)))

Discussion posts and replies are publicly visible

0 PhilB
A Score Level 1
over 10 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 10 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 10 years ago

thanks sikhivahans .
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vineeta6579 over 10 years ago

so null check was missing ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 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 10 years ago

yes..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 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