troubleshooting Question

public address book group used in @DBlookup

Avatar of pratigan
pratiganFlag for United States of America asked on
Lotus IBM
4 Comments1 Solution456 ViewsLast Modified:
I have an application tht contains an approval and rejected button.  In the hide logic I used to reference a forms field called CMapp_email which contained peoples email addresses.  These address names were used to determine who had access to approve or reject requests.
The admin that supports that form containing the referenced CMapp_email field wanted to put group names in there instead of peoples email addresses so that they only had to change the names in the address book groups.  the problem is there is a DBlookup to that CMapp_email field where the addresses used to be, now the DBlookup is still accessing that field but now that field has public address book group lists in it.  The problem is now no one is seeing the approve or reject buttons.  (CMapp_email contains muti use group names from the public address book)
Here is the logic in the hide for those buttons:
key := CMsub_sys + "PkgApprovals" + @Middle(CMpkgID;2;2) + CMpkg_status;
temp := @DbLookup(""; ""; "CMapprovals";key; "CMapp_email");
@IsNotMember(@Name([Abbreviate];@UserName);@Name([Abbreviate];temp))  | CMpkg_status = "Closed"

I'm wondering if DBlookup is taking the groupnames in that field as literal actual values instead of cross referencing the address book group names.  This is my belief on what is happening.
Is there a straight forward enough way to get around this where the dblookup knows that those are group names and goes the extra mile to check the names in those groups ???

Thank You !
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros