Named Query Datetime Conversion

Ignition
1

I'm using some named queries in an expression binding to pull in data. These queries are using the formatted parameter of some date pickers for a date range.

I was expecting to have Ignition convert the datetimes to the gateway's timezone, similar to how a system.db.runPrepQuery reacts, but it does not. Probably because the Jython scripting is being used.

Should I just rewrite my bindings with a transformation script and run the named query that way?
Or, is there a way to convert the user input datetime into UTC in the background?

2

This is likely the problem. Use the .value prop so you get a TZ-compliant object to pass to datetime value parameters of your named query.

1 Like
3

Oh duh... That was it. Thank you.