Forum Discussion

tornado's avatar
tornado
New Contributor
12 years ago

how to use a property as a list in sql query?

Can someone help me with the below question?

for example, I set a property List=[1,2,3] at test case level, but the following sql query will not work:

select * from (a table) where id in '${#TestCase#List}', because it will say the data is invalid.

how can I make this work?

Thanks

Wen

1 Reply

  • nmrao's avatar
    nmrao
    Community Hero
    12 years ago
    Assuming that you are using oracle as database.
    Please try something like (note the braces)
    select * from (a table) where id in (<your list goes here>);