Hi Hugi, I'm not sure if this will work for 4.0 (since earlier you said you are using it), but this is what I'd use for 3.1:
https://github.com/mrg/cbe/blob/master/FetchingObjects/Aggregates/src/main/java/cbe/fetching/utilities/AggregateUtils.java If you have A->>B, you'd construct a SelectQuery to fetch B's where toA = your A object. Basically, invert your query and count the matches. Something like: SelectQuery selectQuery = new SelectQuery(B.class); selectQuery.setQualifier(ExpressionFactory.matchExp("toA", a)); int countOfB = AggregateUtils.count(dataContext, selectQuery); Some other example uses: https://github.com/mrg/cbe/blob/master/FetchingObjects/Aggregates/src/main/java/cbe/fetching/Aggregates.java mrg On Mon, Feb 29, 2016 at 7:25 AM, Hugi Thordarson <[email protected]> wrote: > Hi all, > > Is there any simple way or me to count the number of destination objects > of a to-many relationship? (without fetching) If not, is there some way to > generate an expression from a relationship, so I can use that expression in > my own counting functions? > > Cheers, > - hugi
