Hi, I'm not sure but is there support in Cayenne EJBQL impl. for ordering by aggregate functions? (I think JPQL spec. has it)
I'm getting syntax error on these: SELECT p.account, count(p) FROM PortJump p GROUP BY p.account, ORDER by count(p) DESC SELECT p.account, count(p) AS cnt FROM PortJump p GROUP BY p.account ORDER BY cnt DESC Thanks for information, regards -- Marek Šabo
