Hi, Try do it like:
SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(inParameter.toArray(), anotherINParameter.toArray()) If you have more the one args, the method will be work. On Tue, Oct 11, 2016 at 3:08 PM, Anil <anilk...@gmail.com> wrote: > ignite supports multiple IN queries ? i tried the following and no luck. > > String sql = "select p.id, p.name from Person p join table(name > VARCHAR(15) = ?) i on p.name = i.name join table(id varchar(15) = ?) k on > p.id = k.id"; > > SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(new Object[] { > inParameter.toArray()}, new Object[] { anotherINParameter.toArray()}); > > Thanks > -- Vladislav Pyatkov