# Postgres Namedquery In Clause

**URL:** <https://forum.inductiveautomation.com/t/postgres-namedquery-in-clause/100046>\
**Category:** Ignition\
**Tags:** namedqueries, perspective\
**Created:** [December 19, 2024, 3:29pm UTC](https://forum.inductiveautomation.com/t/postgres-namedquery-in-clause/100046 "2024-12-19T15:29:28Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [December 19, 2024, 3:46pm UTC](https://forum.inductiveautomation.com/t/postgres-namedquery-in-clause/100046/3 "2024-12-19T15:46:38Z")

</div>

Example

```python
select *
from table
where id in {values}

```

values = "(1,2,3)"

more info  
[Using a querystring parameter in a named query IN clause - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/using-a-querystring-parameter-in-a-named-query-in-clause/47534)

[Ignition Perspective Named Query with WHERE IN Clause - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/ignition-perspective-named-query-with-where-in-clause/34062/8)

---

_[View the full topic](https://forum.inductiveautomation.com/t/postgres-namedquery-in-clause/100046)._