Dblookup problem

HCL Domino Domino Forum
1

Hello everybody:

I need get a Organismo data from actual user in a “Remitente” view, with this data I select all documents to a diferent form in a other view.I would like something like that:

organismoBuscado:= @DbLookup( “” ; “” ; “Remitente” ; @Name([CN];@UserName);“Organismo”)

SELECT

(form=“Disp”)& (Organismo=organismoBuscado)

But this doesn´t work, any ideas?

thank you very much.

Regards,

Sonia

2

Subject: RE: Dblookup problem

As the Designer documentation mentions, @DbLookup doesn’t work in a view selection formula. You might use a categorized view set to display a single category, as described in Performance basics for developers (whitepaper).

3

Subject: Dblookup problem

@DbLookup( “” ; “” ; “Remitente” has a typo -colon not semi-colon.@DbLookup( “” : “” ; “Remitente”

also you should put an error trap aftert he lookup in case your lookup fails

organismoBuscado1:= @DbLookup( “” ; “” ; “Remitente” ; @Name([CN];@UserName);“Organismo”)

organismoBuscado:=@if(@IsError(organismoBuscado1); “error”; organismoBuscado1)

Also, additionally to dblookup not working in views, @username doesn’t work well in view formulas either