> Does JBossQL support aggregate functions for SQL?
> Example: MIN(x), AVG( [DISTINCT] x), COUNT(
> [DISTINCT] x), and so on.
No. Maybe JBoss 3.1. I think I'm going to add full group by/ having support.
> May be I can do it with Dynamic JBossQL or somehow
Nope, you can use a custom finder.
> For example I can write the the following QL
> statement for WebLogic QL Extension for EJB QL:
> SELECT COUNT (DISTINCT subOrder.ship_date) FROM
> OrderBean AS subOrder
> Can I write similar statement for JBoss? And how?
> It would be nice if anybody will say where I can find
> the documentation for JBossQL and Dynamic JBossQL.
I am still writing it, in the mean time look at the JBossOne CMP slides.
Thank you for respondes.