How to reference datatable, retrieve row value, and update separate table. Hi,
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.
I cannot get my javascript code to work, I'll paste below what I have currently, I am wondering now if it is easier to use data tables for both tables listed above or if this set up should work?
To clarify, I am using a configured Alert on the Faulted property (boolean) to trigger a subscription with the following code:
var PLCFaultCode = me.Current_Fault_Code;
var que
