Ignition / Vision: I have a Stored Function (PostgreSQL) that accepts an array of integers- The function executes as expected when called from pgAdmin as follows: SELECT * FROM public.downtime_record(1, 1000, ‘05/10/2022’, ‘0800 : 0900’, ‘{10, 11}’, ‘{1, 2}’, 1000) However, when trying to execute…

You cannot pass arrays through parameters in vanilla JDBC. Some DB’s offer extensions for that, including PostgreSQL, but such are not accessible through Ignition’s abstractions. Use separate parameters for each endpoint.

system.db.runPrepQuery - Argument Syntax

Ignition

pturmel August 3, 2023, 3:19pm 6

Follow up: