Dataset OQL using sub_oql_query

3
Hi, Doing a very basic test to see whether I can use a sub_oql_query in a dataset. When using the following very basic query (it's a sample): select employees.name as employeename from (select xx.EmpName as name from MyFirstModule.Employee as xx) as employees Throws the following error: Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): select employees.name as employeename from (select xx.EmpName as name from MyFirstModule.Employee as xx) as employees at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:57) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Select columns with a sub query may only contains a * identifier., exception occurred on mapping the following query: SELECT employees.name AS employeename FROM (SELECT xx.empname AS name FROM myfirstmodule$employee AS xx) AS employees at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:269) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Select columns with a sub query may only contains a * identifier. at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.mapSubQuerySelectColumns(SelectColumnsMapper.java:86) Documentation indicates it should be possible to use this type of subqueries (sub_oql_query). What am I doing wrong? Thanks. 20150917 EDIT: Mendix indicates this is a bug (which will not be resolved shortly), the same query will work properly when used in a java action based dataset.
asked
2 answers
0

Did you try this?

select employees.name as employeename from (select * from MyFirstModule.Employee) as employees

answered
0

Hi,

Is there a solution for this already or this is still a problem in the new versions as well. I got similar query using Mendix 8.18.5 and getting the same error.

 

Thx

answered