No. Unlike EOF, "@size" is not a keyword with any meaning in Cayenne.
Andrus > On Jul 27, 2024, at 2:38 PM, Riccardo De Menna <deme...@tuorlo.net> wrote: > > 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] ……. > >
