Condition "In" in Lookup_ext

dataservices
1

Hello, Im creating a lookup and I need to put in the conditions==> and Floy_Type in (1,2,3)

how can I do this?

thanks! :nopity:

Victor_BCN :es: (BOB member since 2009-09-15)

2

Floy_Type < 4?

Nemesis :australia: (BOB member since 2004-06-09)

3

jejeje thanks, but it won’t help me :slight_smile:

this was just an example, in reality I need an “In” because values can be 7,10,14 (and not 8,9,11,12,13)

Victor_BCN :es: (BOB member since 2009-09-15)

4

Yes, I thought it might be a bit more complex. Have you considered replacing the lookup_ext with an outerjoin to the lookup table? You could then put a where clause on the join that incorporated your ‘in’ syntax.

Nemesis :australia: (BOB member since 2004-06-09)

5

for achieving the above you can use custom sql in lookup ext tab…just go thru that in the tutorial how to implement it and still if you have any confusion let me know …

manibhambra (BOB member since 2013-02-20)

6

you can simple wrap the lookup_exp in a decode function

for example:

decode( Floy_Type in (1,2,3),
lookup_exp(…),
‘whatever’)

Abadir :canada: (BOB member since 2013-02-05)

7

Finally I did a “manual” lookup crossing the tables :slight_smile:

They are such small tables that it’s not worth to invest any effort in save performance

Thank you everybody! :wave:

Victor_BCN :es: (BOB member since 2009-09-15)