Passing SQL IN parameters

Ignition
, , , ,
1

How do I use numbers of values from multi-select dropdown components and use it in parameter for report viewer (perspective view) I want to use that selected multi values in basic query .Note : can select any number of values
query:
select * from tablename where columnname IN ({Parameter}).

2

What SQL database engine are you using?

Tips:
The heading is supposed to describe what your question is about. You don't write the whole question there. In your case this is "Passing SQL IN parameters to query". Then give the details in the post.

Use the </> button to format code such as Python and SQL.

1 Like
3

MS SQL i have used

4

Microsoft SQL has the STRING_SPLIT() function.

STRING_SPLIT (@Expression, ',').

I don't have MS SQL so I can't test it for you.

1 Like
5

Thanks, it worked for me