Custom dblookup

HCL Domino Domino Forum
1

This is probably a silly question but I want to pick only certain values from a dblookup. I’ve been trying different ways but cannot get it. I need to pull out only certain words.

Like here for example, I just want all values with “Non-…”

I know this is not right but I can’t find an example for this…

a:=

@DbLookup(“”;“ReplicaId”;“ViewName”;2);

@Left(a;“Non-”)

@DbLookup( class : cache ; server : database ; view ; key ; fieldName ; keywords ) or

@DbLookup( class : cache ; server : database ; view ; key ; columnNumber ; keywords)

Maybe @word…not sure? Can someone help? Thanks!

2

Subject: custom dblookup

How about …

a:=

@DbLookup(“”;“ReplicaId”;“ViewName”;2);

@Like(@Left(a;“Non-”))

seems like it would work.

3

Subject: RE: custom dblookup

I’m still having problems this. Does anyone know how to only return certain values from a @dblookup? I just want values that start with “Non-”. Thanks…