Can I use the @size keyword to sort a ToMany relationship in the backend with
ObjectSelect.orderBy() ?
I’m getting:
java.lang.IllegalStateException: Unable to resolve path: compositions (unknown
'@size' component)
at
org.apache.cayenne.access.translator.select.ObjPathProcessor.processNormalAttribute(ObjPathProcessor.java:65)
~[cayenne-server-4.2.jar:4.2]
at
org.apache.cayenne.access.translator.select.PathProcessor.process(PathProcessor.java:80)
~[cayenne-server-4.2.jar:4.2]
at
org.apache.cayenne.access.translator.select.PathTranslator.lambda$translatePath$0(PathTranslator.java:48)
~[cayenne-server-4.2.jar:4.2]
at
java.base/java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1708)
~[na:na]
at
org.apache.cayenne.access.translator.select.PathTranslator.translatePath(PathTranslator.java:47)
~[cayenne-server-4.2.jar:4.2]
at
org.apache.cayenne.access.translator.select.PathTranslator.translatePath(PathTranslator.java:52)
~[cayenne-server-4.2.jar:4.2]
at
org.apache.cayenne.access.translator.select.QualifierTranslator.expressionNodeToSqlNode(QualifierTranslator.java:155)
~[cayenne-server-4.2.jar:4.2]
at
org.apache.cayenne.access.translator.select.QualifierTranslator.startNode(QualifierTranslator.java:118)
~[cayenne-server-4.2.jar:4.2] …….
