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

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

Parents
  • @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))
Reply
  • @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))
Children
No Data