Got everything working except getting an error in the report, "unable to convert row x, column x to type class java.sql.Timestamp"
from com.inductiveautomation.ignition.common.util import DatasetBuilder
from java.lang import String, Integer, Long, Boolean, Float
from java.util import Date
b = DatasetBuilder.newBuilder().colNames("path", "value", "timestamp").colTypes(String, String, Date)
All rows for column are java.util.Date. The only way I could get past the error was changing from Date to String. I guess it's no big deal, but for my benefit any idea what's going on here?
Oh. I spent some time trying to figure out exactly what data structure was expected by table groups… and ended up just nesting queries that shouldn’t be, just for the sake of getting what the table expects.
I’ll revisit that part of the report and see if it can be simplified with this.