Displying Users and the groups they belong to

HCL Domino Domino Forum
1

Hi All,

I have a notes application, in which I need to display (in a View) all the users (Field - VendorName) and the Groups (G1, G2, G3, G4)they belong to.

I tried with following code in view

1st column name - VendorName

Formula - @Name([CN];VendorName)

2nd Column name - Member of

Formula -

MemberName:=@Name([CN];VendorName);

Grp:=@DbLookup(“”:“No Cache”;@Subset(@DbName;1):“names.nsf”;“($VIMGroups)”;“G1”;“Members”);

Group1:= @If(@Contains(MemberName;Grp)=1;“Group1”;“”);

Grp:=@DbLookup(“”:“No Cache”;@Subset(@DbName;1):“names.nsf”;“($VIMGroups)”;“G2”;“Members”);

Group2:= @If(@Contains(MemberName;Grp)=1;“Group2”;“”);

Grp:=@DbLookup(“”:“No Cache”;@Subset(@DbName;1):“names.nsf”;“($VIMGroups)”;“G3”;“Members”);

Group3:= @If(@Contains(MemberName;Grp)=1;“Group3”;“”);

Group1 + “,” + Group2 + “,” + Group3

But the above code didnt work. I used @ismemberOf also. It also didnt work.

Please help me in this.

2

Subject: Displying Users and the groups they belong to

Create a view in the NAB that selects only group documents. Set the first column to Members and the second column to the group name. Sort on the first column and categorize it. Done! This is a very useful view because you can quickly search for ex-users and see if they are left in any groups. We have a product that does this plus analyzes the ACL plus allows for batch updates to the ACL if you are interested http://wfs.com

3

Subject: Displying Users and the groups they belong to

Hi,

You can’t use dblookup-us in views.

There is a function named @UserNamesList , which returns the groups the current user in, but it probably won’t work in the view either.

In other words, I don’t think you can do that in the view, unless you save the group info in every document you display in the view. Views are quite restrictive on what you can use, but the general rule is that docs should contain all info you need to display.