Hi.

I have 2 tables:

groupInfo table
================================================
group_name, sort_direction(ASC, DESC), description


groupData table
================================================
short_name, long_name, group_name, sort_order

I want to make 1 database call.
The user will provide the sort direction. however if the sort_direction is not provided I want to use the value that is set up for that group in the database.
I am able to achieve this using the following sql statement (notice the order by subselect)



Is there a way to create this order by subselect statement using a Criteria object?
groupValues.addOrder(....)?

Thanks

M