Hibernate Community • View topic - order by custom function instead of table field

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

order by custom function instead of table field

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

majohnst

Post subject: order by custom function instead of table field

Posted: Thu Sep 16, 2004 2:42 pm

Newbie

Joined: Mon Aug 30, 2004 5:15 pm
Posts: 13

Hibernate version: 2.1.6

I have a class Task that corresponds to a database table Task. I have extended the Task class to include a custom function:

Code:

   public int numDaysRemaining() {
       ....
    }

Is there a way to use this function is a query? I want to order by results by this function, ie.

Code:

from Task task order by task.numDaysRemaining()

Top

bertrand

Post subject:

Posted: Thu Sep 16, 2004 3:49 pm

Proxool Developer

Joined: Tue Aug 26, 2003 10:42 am
Posts: 373
Location: Belgium

Not as far as I know...

According to me, your only option is to sort the list returned by the query yourself.

You could build a Comparator using your function and Collections.sort() your list - or use the Jakarta Collections lib.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum