I have a Defaults Doc that specifies two Notes groups. On a main form, I have a field that successfully does @DBColumn to find the those two Notes groups. However, I want it to break it down to the individual names of the members of those two groups.
Trying variations of @Name([CN];@DBColumn … but nothing is working so far.
Ideas?
Subject: Getting names out of groups - via @DBColumn
Ummm… those dots after the DbColumn? The details may be important.
Some questions based on what I think you might be doing.
In the doc where you define the group, are you defining the group and the members of the group?
Are these group definition docs in a view? Is this the view you’re doing the DbColumn against?
Why are you using DbColumn instead of DbLookup? If you have more than one group, you need to pick the group, the use that group name as the key to lookup the member names.
HTH
Doug
Subject: Getting names out of groups - via @DBColumn
Stanley,
It’s easy to get the members of a group, but the problem may not be so trivial because what happens if you have nested groups? Don’t you want to drill down all the way?
And what about names that are invalid (no longer in your N&A Book)? Do you need to test for that? Or what about internet addresses that might be in these groups?
I’ve found that all these and more are quite likely.
regards,
raphael
Subject: Getting names out of groups - via @DBColumn or @DBLookup
Thanks for the inquiry. The goal is to extract the names out of two groups; there are no further groups nested within. GroupA has 4 names, GroupB has 20.
I have created a Defaults Document form. One field on this form is d_assigned (names type, editable). This is populated with GroupA and GroupB.
I have a hidden view – (DD) – that displays all the values in the Defaults Document, one per column (first is sorted).
On the main form of the database, I have a field called action_assigned . I want to be able to select a name(s) from the combined persons in GroupA and GroupB. The code on this field is:
@Names([CN]; @DBLookup(“” " “NoCache”; “” ; “(DD)”; “Defaults Document”; “d_assigned” ))
It works - but it returns the choices as GroupA and GroupB, not the expected 24 members of those groups.
FWIW, I have d_assigned in column 6 on my hidden view.
I’m updating a database that has a lot of choices hardcoded; presently the action_assigned field on the main form makes a similar call that works (lists the 24 individual names of persons in the two groups), but the info is hardcoded and recently ‘broke’ when the view was renamed -
@Names([CN]; @DBLookup(“” " “NoCache”; “ServerA” : “Names.nsf” ; “Groups”; “GroupA” : “GroupB”; “members” ))
“ServerA” : “Names.nsf” = <server/db>
“Groups” =
“GroupA” : “GroupB” =
“members” =
With this info, can I get this to work as expected?
Subject: Getting names out of groups - via @DBColumn
I have a Defaults Doc that specifies two Notes groups. On a main form, I have a field that successfully does @DBColumn to find the those two Notes groups. However, I want it to break it down to the individual names of the members of those two groups.
Trying variations of @Name([CN];@DBColumn … but nothing is working so far.
Ideas?
Unless there’s a good reason not too, please use @namelookup on the group name and ask for the Members items to be returned. If you’re not sure if the name is a group, also ask for its Type item and check that it is Group.
References to NameLookup in “Domino Directory FAQ” (google it)