Hi, I would like to execute query below but it return no rows : usages = [301,311] pyds = system.db.runPrepQuery("SELECT * FROM distribution_config WHERE usage_id IN (?)",[usages],"base_administrateur") Do you have a solution without make a loop in my list ?

usages = [301,311] queryString = """SELECT * FROM distribution_config WHERE usage_id IN ({})""".format(','.join(['?']*len(usages))) pyds = system.db.runPrepQuery(queryString,usages,"base_administrateur")

prepQuery with WHERE IN() statement

Ignition

pturmel August 3, 2023, 3:19pm 9

Note that at least one JDBC driver tolerates a form of this through Ignition's "Prep" queries: