Example
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
Ignition Perspective Named Query with WHERE IN Clause - Ignition - Inductive Automation Forum