Good afternoon!
From the OPC server, we get a value, but in order to display it in the correct format in Ignition we need to convert it to the following algorithm:
DEC_VALUE convert HEX_VALUE
HEX/10000
HEX_VALUE convert DEC_VALUE DEC_VALUE - The converted value
Ok, I took a closer look at your original post. If I had been thinking a bit more clearly (while it is afternoon for you, it’s early morning for me, and I hadn’t had any coffee yet ), I would have noticed earlier what you were looking to do!
I would like to ask one question.
How to use this feature to build EasyChart.
The database value is stored as the number 26214400, and we need to kept in the form of the converted values to the plot of the number to 231 instead of 26214400.
I don’t think you can. You can do it in a regular chart using a query similar to
select conv(left(hex(Value1),LENGTH(hex(value1))-4),16,10) as voltage1, conv(left(hex(Value2),LENGTH(hex(value2))-4),16,10) as voltage2,...etc...
from table
where ... etc.
Another thing you may want to consider is to have your transaction group process the raw data and store it in a useable form into the database. That way you could easily implement the easy chart.