# Get rows node where in

**URL:** <https://forums.losant.com/t/get-rows-node-where-in/2342>\
**Category:** Help\
**Tags:** workflow\
**Created:** [November 5, 2019, 7:54pm UTC](https://forums.losant.com/t/get-rows-node-where-in/2342 "2019-11-05T19:54:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\
**Post date:** [November 5, 2019, 7:54pm UTC](https://forums.losant.com/t/get-rows-node-where-in/2342/1 "2019-11-05T19:54:31Z")

</div>

Is there a way to use the “get rows node” to return results based on an array?  
like the SQL statement “select,from …where fieldX in (‘A’,‘B’,‘C’)”

---

<div class="post-metadata">

**Author:** ![anaptfox](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/anaptfox/32/873_2.png) [@anaptfox](https://forums.losant.com/u/anaptfox)\
**Post date:** [November 5, 2019, 8:17pm UTC](https://forums.losant.com/t/get-rows-node-where-in/2342/2 "2019-11-05T20:17:25Z")

</div>

@Lars_Andersson,

So, currently the only way to do this is to chain `$eq` and `$or` operations for each element in your array.

You could do this buy building an advanced query using the Function Node:

> **[Data Tables](https://docs.losant.com/data-tables/overview/#advanced-queries)**
>
> Learn about creating and managing Data Tables in your Losant Application.

In the Function Node, you can loop through the array and build your advanced query to be used in the Table: Get Rows Node.

But, I will make a feature ticket for you for this 🙂