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

Parents

0 sikhivahans over 10 years ago

@vahluwalia Hi, try using this code snippet. Hope it helps!!

Name:
rule!someRuleName

Inputs:
1. group (Group)

Definition:
if(
\trule!APN_isBlank(ri!group),
\tnull,
\tif(
\ tdoesgroupexist(
\ t tointeger(
\ tri!group
\ t )
\ t),
\ tgetgroupnames(
\ t tointeger(
\ tri!group
\ t )
\ t),
\ tnull
\t)
)

a!gridTextColumn(label:"Groups List",field:"",data:apply(rule!someRuleName(group:_),local!totalgroupNumbersList))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 10 years ago

@vahluwalia Hi, try using this code snippet. Hope it helps!!

Name:
rule!someRuleName

Inputs:
1. group (Group)

Definition:
if(
\trule!APN_isBlank(ri!group),
\tnull,
\tif(
\ tdoesgroupexist(
\ t tointeger(
\ tri!group
\ t )
\ t),
\ tgetgroupnames(
\ t tointeger(
\ tri!group
\ t )
\ t),
\ tnull
\t)
)

a!gridTextColumn(label:"Groups List",field:"",data:apply(rule!someRuleName(group:_),local!totalgroupNumbersList))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data