Hi, I would like use standard "Query Database node" with this sel

lorenzor over 11 years ago

Hi,
I would like use standard "Query Database node" with this select:

select user
from V_UserHome
where COUNTRY IN ('IT','US','DE')

The value 'IT','US','DE' is a list of an previous selection and it is the query parameter.
how I can use WHERE IN clause?

thanks
Lorenzo...

Discussion posts and replies are publicly visible

0 moritzw over 11 years ago

you should be able to do something like this using INSTR command. similar to this:
where INSTR(ac!countries,','||TO_CHAR(a.country)||',') > 0
This works with oracle db. For other RDBMS the syntax will probably differ a bit.
ac!countries needs to be a single string with a comma as a separator.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 lorenzor over 11 years ago

great! it works. I have oracle db.

thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel