I changed the SQL from tag historian in the power table i got to this SQL statement that works in mysql workbench:
SELECT sqlt_data_1_2021_11.t_stamp, sqlt_data_1_2021_11.stringvalue, sensor.tagText AS SensorText FROM sqlt_data_1_2021_11
inner join sensorid Sensor ON sensor.tagID = sqlt_data_1_2021_11.tagid
WHERE stringvalue != "0000"
But in ignition it throws and error
And now i can no longer open the Data window due to the error keeps coming:
You are giving the MySQL JDBC driver two statements: “USE” and “SELECT”. With few exceptions, JDBC drivers only allow one statement, not a script.
That was what i figured, because i use the workbench as root, i had to use it, but forgot remove it in ignition.
After spamming alt+c to close the error dialog i managed to get the data dialog open to correct it.
Try this set of buttons to control whether the error dialogs pop up front or are allowed behind: