You can translate the question and the replies:

View parameters

Hi, I am trying to use where IN viewparameter like below. like FROM table WHERE column in (param) USING PARAMETERS ( param : text '''A'', ''B'''); Above is not working as FROM table WHERE column in ('A','B') Can you please let me know how to use view parameter in where IN Thank you
user
14-01-2021 02:43:01 -0500

1 Answer

Hi, I was able to use IN in WHERE clause as shown in the example below. SELECT * FROM table WHERE column IN('A','B') 'A' and 'B' are text values in column. I found this info in the following user manual. This should be helpful to you. * [Queries - SELECT statement](https://community.denodo.com/docs/html/browse/8.0/vdp/vql/queries_select_statement/queries_select_statement) Hope this helps!
Denodo Team
15-01-2021 05:18:36 -0500
You must sign in to add an answer. If you do not have an account, you can register here