Dyanamic query for SQL Aggregate function

[Chandan Sharma, modificado 9 Anos atrás.]

Hi All,

I want to write dynamic query for SQL aggregate function's like: max(-), min(-), sum(-), count(-) etc.

Can any body will help me out


Thanks,
~Chandan

[Hitesh Methani, modificado 9 Anos atrás.]

Hello Chandan,

You can use Projections in that case,
For e.g. dq.setProjection(Projections.max(propertyName)) where dq is DynamicQuery object.

Hope this helps.
Thanks,
Hitesh Methani.

[Chandan Sharma, modificado 9 Anos atrás.]

Hi Hitesh,

I got the solution,

using methods of Property, Projections classes

. By the way thanks for your support


Thank you
~Chandan