How to runtime order the result from finders ?

[mberkan]

Hello!

I tried to create custom finder:
findAllOrderBy(String orderBy)

My jaws file contains:

findAllOrderBy
1 = 1
{0}


And this not work - '{0}' is not parse and SQL query fail. It is possible to put variable as argument to order by statement?

[danch1]

This isn't possible right now. The only way to do this would be to code a BMP style finder in your bean (ejbFindAllOrderBy) and do it yourself. See the online manual for details

[davidjencks]

Have you ever seen a database that allows parameterized field names in an order by clause????