Transaction Group: Using datetime as a key

Ignition
1

I have a transaction group that executes (every second) based on two key/value pairs. One pair is a string, and the other is a datetime object. The datetime tag value changes only once every few minutes. (Its format is yyyy-MM-dd hh:mm:ss, if that’s relevant at all.)

When I have the group use just the string pair, it updates or inserts exactly how you’d expect. However, when I have the group use the datetime pair (either alone or in conjunction with the string pair), the group inserts a new row every execution, even if the datetime value hasn’t changed at all; I’ve yet to see it match and update when using the datetime pair.

Do the transaction group key/value pair updates just not work with datetime pairs? Or is there some subtle difference between what’s in the tag and what gets stored into the (MySQL) database by default that causes it to mismatch, and how can I address that?

2

Update!

Not sure about an actual solution to the issue, but at the very least, a workaround: creating a duplicate of my datetime tag, using that tag in the transaction group, and having its data stored in a string column rather than a datetime column. Then the key/value check looks at the new datetime-string column instead of the actual datetime column and hey, it works. The string column seems to store the value in a way that allows it to match what’s in the tag when it’s read back out.

So there’s a little bit of duplication now, which is unfortunate, but at the very least the group updates and inserts as appropriate, and I still have my original datetime column to query on for reporting.