[bug-15145]ACTION_VALUE of audit table contain Qualified value instead of the Value

Ignition Early Access
1

Hi @PGriffith,

With the standart Database audit profile, the ACTION_VALUE column in the audit table is filled with Qualified Value instead of value:

[false, Good, Mon Oct 07 10:09:58 CEST 2019 (1570435798678)]

instead of:

false

image
image1586×474 47.4 KB

I don’t think it’s intentional. Tested with Ignition 8.0.5-nightly 12/09.

2

I don’t necessarily think this is a regression - I think it’s related to an unplanned change made to the way QualifiedValues are passed through the tag write system. I’ll file a ticket, but I don’t know if it’s actually worth changing.

3

Yes in v8 every value are Qualified value…
But the action_value column in the audit table is a varchar in the database, and we are only interested by the value here, there is ever a status code and event_timestamp columns.

As a side note, is there a built in function in the SDK to parse string [ V, Q, T] to Qualified Value ?

4

This issue was fixed in the 8.0.6 nightly build that was uploaded yesterday (10/10).