Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Problem with data point filter


  • Hi I have created a modbus instance and configured the data points. Now if I go to the instance and look at the data points and try to filter on a column, I get a big SQL error:

    I am using ubuntu 12.04 and openjdk-7. everthing else seems to work...

    Server error: PreparedStatementCallback; bad SQL grammar [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId WHERE ORDER BY dp.deviceName, dp.name]; nested exception is org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT DP.ID,DP.DATA,DP.XID,DP.DATASOURCEID,DP.NAME,DP.DEVICENAME,DP.ENABLED,DP.POINTFOLDERID,DP.LOGGINGTYPE,DP.INTERVALLOGGINGPERIODTYPE,DP.INTERVALLOGGINGPERIOD,DP.INTERVALLOGGINGTYPE,DP.TOLERANCE,DP.PURGEOVERRIDE,DP.PURGETYPE,DP.PURGEPERIOD,DP.DEFAULTCACHESIZE,DP.DISCARDEXTREMEVALUES,DP.ENGINEERINGUNITS,DS.NAME,DS.XID,DS.DATASOURCETYPE FROM DATAPOINTS AS DP JOIN DATASOURCES DS ON DS.ID = DP.DATASOURCEID WHERE ORDER[*] BY DP.DEVICENAME, DP.NAME "; expected "NOT, EXISTS, SELECT, FROM"; SQL statement: SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId WHERE ORDER BY dp.deviceName, dp.name [42001-171]

    I'd send you a screenshot of my instance but I don't seem to be able to attach anything ...


  • This is a bug in the SQL for the filter. What table are you filtering?

    1. The "All data points" table which is at the top of the Data Sources page that contains all of the data points.

    2. The "Data Source data points" table which is the table at the bottom of the page when editing a data source that lists the data points for the currently edited source?

    Thanks for brining this to our attention.

    Terry


  • both.


  • That's interesting. I'm not able to duplicate this, can you tell me what version of the Mango core are you using, what database you are using and exactly where you are typing the filter and an example of the filter?

    Thanks,
    Joel