I am trying to configure my PI tag to be able to read data from an sql database.
the query works well and I just want to fecth the latest Cd_mean value. how can I configure my PI tag to store that value in a PI tag
I am trying to configure my PI tag to be able to read data from an sql database.
the query works well and I just want to fecth the latest Cd_mean value. how can I configure my PI tag to store that value in a PI tag
another option may be to change your SQL query to return a single row with the largest timestamp?
If you are only going to process that one anyway, it could be better for the network and other resources not to return a bunch of unuseful rows
Well this is only a suggestion and not meant to be a direct solution to rbitcoin's desire (although a slight change should do). I do agree with you that the query result should be as optimized and light-weighted as possible, but from personal experience getting SQL data from external applications, human errors and sometimes negligence can require data to be adjusted and thus, require overriding PI data.
Well this is only a suggestion and not meant to be a direct solution to rbitcoin's desire (although a slight change should do). I do agree with you that the query result should be as optimized and light-weighted as possible, but from personal experience getting SQL data from external applications, human errors and sometimes negligence can require data to be adjusted and thus, require overriding PI data.