runtime error on order by clause in drop down search field

0
I have a template grid for entity A. A has an associaton with entity B, B has an association with C. The dropdown search field is B.attribute. It's sort order defined as C.attribute, B.attribute I get this error during runtime: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":1000,"pageName":"Curricula.MetaDataOV","sort":[{"direction":{},"memberName":"Curricula.TopicTypes_Sources/Curricula.Source/Abbreviation"},{"direction":{},"memberName":"Order"}],"returnsCount":true,"offset":0,"type":"RetrieveXPathSchemaRawAction","xpath":"//Curricula.TopicType"}', ... Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): XPathTextGetRequest (depth = -1, amount = 1000): //Curricula.TopicType at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:51) Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 42576, Error Code: -5576) Detail Message: org.hsqldb.HsqlException: invalid ORDER BY expression at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.getCorrectException(JDBCDataStore.java:1432) The webpage opens, but the dropdownfield is empty. what am I doing wrong?
asked
2 answers
0

Yvonne,

This does not seem to be possible using the build in database. I would give it a try on a postgres db.

answered
0

This indeed to occurs only in the default database, running local. Just tested it and it gives no problem running in the sandbox.

answered