Is there any way to find users who are only direct members of that group, not ad

@jakeg Hi, have you had a look at fn!getDirectGroupMemberUsersPaging() present in the 'Group Functions' Shared Component at https://forum.appian.com/suite/tempo/records/item/lIBCLGOdlMUpdGVqW3dQaIKmclBmvvNEj8vu_cjb7T-5YiPr4Fu8ly5Yj1s09uenE4RYzA8zKyx7eiUjO5E6eO2UZ1tJnDqkswaubvz8gUllGhG/view/summary ?

May be you can use plugin - forum.appian.com/.../summary

Thank you for the replies. I am working with Jake on this one. We have tried to use this function, but it is not returning any results. I read that it did not include admins, so we have checked that as well. Are there any other "gotchas" for this function?

We've just discovered that the "Gotcha" is that the start index is 0 based :)

And to also add a note for anyone searching this, it DOES return direct users even if they are group administrators. I had previously read on forum that it will not return those users, but it seems to work okay.

Thanks Jake for finding the index issue!

Just to add, the index issue in this function was discussed sometime ago at forum.appian.com/.../e-169542.

As suggested , I am using fn!getDirectGroupMemberUsersPaging() to get the direct members . But in my case I have around 80K users available in a group . If I try to use this function to check a users direct membership It takes more time to retrieve the result as the number of users is huge in numbers. Also I have more group for which i have to run this function to check whether the user is a direct member. Did anyone have faced similar issue and came up with any alternates.

contains(
touniformstring(
fn!getdirectgroupmemberuserspaging(
getgroupbyname(ri!groupName),
0,
- 1
)
),
ri!userName
))