I am trying to create a file having all groups excluding the default groups. Default groups are the groups which are added to user account whenever any user is created like APN All Users, Application Users etc. I have created a constant with default user and trying below.
a!localVariables( local!groups:rule!UAGR_getAllGroups(), local!groups1:cons!UAGR_Default_Roles, expression:union( rule!UAGR_getAllGroups, cons!UAGR_Default_Roles ) )
Discussion posts and replies are publicly visible
Hello nirupamaanuragt399
Union will return a combination of both the arrays. Use symmetricdifference().symmetricdifference() Function
I want to return all rows which are not in constant. In simple language, the roles which are in constant are the roles which should be removed from the roles returned from the expression rule.
try with difference function.
for example, if array one has {a, b, c, d, e, f, g, h} & array 2 has value {c, d, e, f}, then the result set should be {a, b, g, h}
Thats what I requested you to use difference function. it will give you the expected result.
As Anna has mentioned use difference. Sorry for the wrong info. Symmetric Difference would return all the unique items.
As suggested by Anna P , use difference() function. See below code for reference:
a!localVariables( local!allGroups: a!groupsForUser("xxxxx@gmail.com"), local!mygroup: togroup({21,52}), difference(local!allGroups, local!mygroup) )