# Simulation Aids: IN operator with view() expression

**URL:** <https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865>\
**Category:** 3rd Party Modules\
**Created:** [December 21, 2022, 4:19am UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865 "2022-12-21T04:19:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![R\_S](https://avatars.discourse-cdn.com/v4/letter/r/a88e57/32.png) [@R\_S](https://forum.inductiveautomation.com/u/R_S)\
**Post date:** [December 21, 2022, 4:19am UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865/1 "2022-12-21T04:19:23Z")

</div>

Is it possible to use the SQL IN operator with view()?

```auto
SELECT * WHERE column_val IN ('str1','str2','str3')

```

Ideally I'd like to pass this as an argument:

```auto
SELECT * WHERE column_val IN args[0]
args[0] = "('str1',str2','str3')"

```

---

<div class="post-metadata">

**Author:** ![R\_S](https://avatars.discourse-cdn.com/v4/letter/r/a88e57/32.png) [@R\_S](https://forum.inductiveautomation.com/u/R_S)\
**Post date:** [December 21, 2022, 4:26am UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865/2 "2022-12-21T04:26:43Z")

</div>

Figured it out, 'in' cannot be capitalized:

```auto
view(
SELECT * WHERE column_val in args[0],
{dataset_tag},
("'str1','str2'")
)

```

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 21, 2022, 2:12pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865/3 "2022-12-21T14:12:02Z")

</div>

The reason it cannot be capitalized is that it is not the **SQL**"IN" operator, but the **python**"in" operator. Expressions in my PseudoSQL are python. Particularly important for "equals" comparisons.

---

<div class="post-metadata">

**Author:** ![R\_S](https://avatars.discourse-cdn.com/v4/letter/r/a88e57/32.png) [@R\_S](https://forum.inductiveautomation.com/u/R_S)\
**Post date:** [December 22, 2022, 3:33am UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865/4 "2022-12-22T03:33:27Z")

</div>

Thanks for clarifying, I've found the module is incredibly useful for reducing the number of large polling queries made against a database that just requires small filter differences.

---

<div class="post-metadata">

**Author:** ![Jfrantz](https://avatars.discourse-cdn.com/v4/letter/j/258eb7/32.png) [@Jfrantz](https://forum.inductiveautomation.com/u/Jfrantz)\
**Post date:** [July 17, 2024, 3:53pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865/5 "2024-07-17T15:53:49Z")

</div>

I'd like to make my 'in' list a variable that I build.  
I can get this to work:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/6/d6cef73150777a0d18d81db8f49fc51e6bc4342b.png)  
But the following will not work:

`view('SELECT ORDER_NO WHERE SHORTAGE == "False" and HAS_OPEN_NCR == 0 and ACTIVE in (1,3,7,8) and DEST_STATION in args[0]', {[~]ZeelandData/Kanban/KanbanWOData} ,"(181, 441)" )`'

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 17, 2024, 5:29pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865/6 "2024-07-17T17:29:17Z")

</div>

> [@Jfrantz](#):
>
> "(181, 441)"

This is a string, not a list. Cannot work, for the same reason you cannot do it with real JDBC and `?` substitution.

Consider using the nestable iterators in V2, now called my Integration Toolkit.

---

<div class="post-metadata">

**Author:** ![Jfrantz](https://avatars.discourse-cdn.com/v4/letter/j/258eb7/32.png) [@Jfrantz](https://forum.inductiveautomation.com/u/Jfrantz)\
**Post date:** [July 17, 2024, 6:40pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865/7 "2024-07-17T18:40:00Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/a/8aaac64f4e800ddf37cf006a5ff4907def1b3ae3.png)  
I've tried asList({dataset}) also. However, it does not return the expected rows.  
Seems like my list data isn't matching what is returned in my view. I've tried making everything strings also.

---

<div class="post-metadata">

**Author:** ![Jfrantz](https://avatars.discourse-cdn.com/v4/letter/j/258eb7/32.png) [@Jfrantz](https://forum.inductiveautomation.com/u/Jfrantz)\
**Post date:** [July 17, 2024, 7:00pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-in-operator-with-view-expression/67865/8 "2024-07-17T19:00:47Z")

</div>

Looks like I was not defining my dataset enough

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/2/e21ed65c1f3bc303a38b878d332c710d646e4211.png)  
forEach({dataset}, it()['ColName'] )