# Passing SQL IN parameters

**URL:** <https://forum.inductiveautomation.com/t/passing-sql-in-parameters/66452>\
**Category:** Ignition\
**Tags:** ignition81, database, python, scripting, perspective\
**Created:** [November 14, 2022, 7:56am UTC](https://forum.inductiveautomation.com/t/passing-sql-in-parameters/66452 "2022-11-14T07:56:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amitkumar\_Ravat](https://avatars.discourse-cdn.com/v4/letter/a/3ab097/32.png) [@Amitkumar\_Ravat](https://forum.inductiveautomation.com/u/Amitkumar_Ravat)\
**Post date:** [November 14, 2022, 7:56am UTC](https://forum.inductiveautomation.com/t/passing-sql-in-parameters/66452/1 "2022-11-14T07:56:00Z")

</div>

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}).

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 14, 2022, 8:53am UTC](https://forum.inductiveautomation.com/t/passing-sql-in-parameters/66452/2 "2022-11-14T08:53:43Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Amitkumar\_Ravat](https://avatars.discourse-cdn.com/v4/letter/a/3ab097/32.png) [@Amitkumar\_Ravat](https://forum.inductiveautomation.com/u/Amitkumar_Ravat)\
**Post date:** [November 14, 2022, 9:14am UTC](https://forum.inductiveautomation.com/t/passing-sql-in-parameters/66452/3 "2022-11-14T09:14:15Z")

</div>

MS SQL i have used

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 14, 2022, 9:22am UTC](https://forum.inductiveautomation.com/t/passing-sql-in-parameters/66452/4 "2022-11-14T09:22:55Z")

</div>

Microsoft SQL has the STRING\_SPLIT() function.

`STRING_SPLIT (@Expression, ',')`.

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

---

<div class="post-metadata">

**Author:** ![Amitkumar\_Ravat](https://avatars.discourse-cdn.com/v4/letter/a/3ab097/32.png) [@Amitkumar\_Ravat](https://forum.inductiveautomation.com/u/Amitkumar_Ravat)\
**Post date:** [November 14, 2022, 10:21am UTC](https://forum.inductiveautomation.com/t/passing-sql-in-parameters/66452/5 "2022-11-14T10:21:04Z")

</div>

> [@Transistor](#):
>
> STRING\_SPLIT()

Thanks, it worked for me