Criteria use an aggregate function in order

Question

I have one criterion, and I stuck to the following:

I use a sql server, so on my SQL server I have the following condition (Note: I do not put the whole query here. I just put my order by by).

order by (IIF(LEN(Code) = 1, '0'+Code ,Code))

"Code" is my column name. Now I want to implement it in sleep mode in the following

criteria.addOrder(Order.asc("CTC.code"));

Please help me achieve this. Any help would be appreciated.

+2

commit Jun 28 '13 at 7:02

1 answer

commit · Answer 1 · 2013-06-28T09:12:02+0000

After spending too much time and searching on Google, I found a working solution from here:

, , , .