For example I have query on SQL:
SELECT length FROM ( SELECT length, MIN(title) title FROM film GROUP BY length ) t ORDER BY title
I want to create the same for Jira’s Active object:
Query query = Query.select()............... ao.find(ENTITY_CLASS, query)
Using a subquery, I want to fix this example:
ao.find(USER_ENTITY_CLASS, Query.select() .distinct() .alias(USER_ENTITY_CLASS, "user") .alias(SALARY_ENTITY_CLASS, "salary") .join(SALARY_ENTITY_CLASS, "user.ID = salary.USER_ENTITY_ID") .order("salary.AVERAGE_SALARY ASC")
This example throws an error:
’Order by expression “salary.AVERAGE_SALARY” must be in the result list in this case’
In this query, I attach the Salary table to the Users table and sort the table by a field that will not be included in the final selection - AVERAGE_SALARY.
Without distinct() it work good, but I need to discard duplicate entries.
As I understand it, the “group buy” function does not work in an active object.
Perhaps there are other ways to solve this problem?