Possible to add "order by" to the named query?

rolandz · **Posted:** Sat Apr 19, 2008 1:41 pm

Hi,

I need to add an "order by" clause to the named query so the question is whether it is possible at all and how to if yes. What I would like to achieve is to add optionally ordering of the result of the original query:

Code:

IQuery q = sess.GetNamedQuery(...);

// here we set parameters to the query...

if(paging)
{
  q.SetFirstResult(...);
  q.SetMaxResults(...);
}

if(applyOrder)
{
  // here to add order by stuff to the query?
}

q.List();

This seems to be quite typical scenario for DAO implementations and in case of criteria it is quite easy to do... but I need (for now) it for case of HQL queries.

TIA

FlukeFan · **Posted:** Sun Apr 20, 2008 7:21 am

Hi TIA,

I think that's only possible if you're using the ICriteria API, but not for IQuery.

Regards,
Richard

rolandz · **Posted:** Mon Apr 21, 2008 1:50 am

I am also starting thinking so - the only way I've found (except of manually assembled query) is to manipulate the query text by adding an "order by" clause. But this method I would like to avoid because it is error prone - what if the clause is there already? what if adding the clause brakes the syntax?