I'm creating a custom scrip in which I need to execute a query with the order by clause. I specified it in the where caluse but there is a default "order by cn" in the final query. Here you can see the two queries.
I need to get the reasonHead from Decisiontype Unsubscribe on a Request but if on that request are started more Unsubscribe I need to get the last one made.
Basically I need the orderby on Connection.getSingleValue or Connection.getSingleRow.