Hi,
I have a simple query string like
"from Customer as cust join Cars as car where car.id = cust.carId"
I need a way of adding order by dynamicly, so I can generate queries like this:
"from Customer as cust join Cars as car where car.id = cust.carId order by cust.id" or
"from Customer as cust join Cars as car where car.id = cust.carId order by car.name" and so on...
But, I can't use filters, and I don't want to parse the text of the query,
In other words I need a way to get a mapping from the resulting fields and the source fields. example:
field1 -> cust.name
field2 -> cust.id
field3 -> car.id
field4 -> car.name
...

thanks!

using Criteria with H3 you can build queries dynamically.

I'm not sure what that last bit meant

I can not use criteria.
What I mean is:
if the resulting type lokks like:
public class Customer{
String firstName
String lastName
....
}

I need to know what is the field name/alias in the quey string that the Customer.firstName is taken from. For eample cust.fName in case of the folowing query: "from Customer as cust where cust.lastName='me' "