Hi all, I am currently new to Ignition and using it to read data from a database (MySQL PHP MariaDB) for a School Project
Currently, I have managed to come up with a simple Query to get the data as shown
From the Table Perspective:
I was wondering how do I convert the datatime of Log Value into a Date-Time Format using the Expression Transformation or are there easier ways to do this
I have tried using this fromMillis but there is always an error
I am not too sure how to go about this.
I do also have questions regarding the Table, I noticed that I can actually use the Query option to read data from the database automatically using the polling, so that means the table will run the query after every X second, is this how Ignition refreshed data that it read from the database ? Is there a way to automatically run the query when a new data is being added to the database ?