How to reference datatable, retrieve row value, and update separate table.
For a current customer I am trying to implement a service that will record the Fault messages of the machine.
I've set up an infotable property on the asset that would house the recorded faults.
I've also set up a data table holding the fault code reference document that has a numerical code and string for each fault.
What I need to do, is when an Alert on the faulted PLC tag is triggered, to get the numerical code from a seperate PLC tag, reference that code in the data table, get the string equivalent, then add a row with all that information to my asset fault history infotable property.
To clarify, I am using a configured Alert on the Faulted property (boolean) to trigger a subscription with the following code: