hi jose,

imo the modification must be done on CollectionDescriptor and
PersistenceBrokerImpl.
i'd like to have something like this:
<orderby field='bla1' sort='desc' />
<orderby field='bla2' sort='asc' />

i'll put it on the todo-list.
jakob

----- Original Message -----
From: "Jose Maria Lopez Lagunas" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, December 05, 2002 11:02 AM
Subject: More than one field in orderby


> I think that should imply further modifications to the PersistenceBroker,
since the current implementation uses a boolean
> property to know if it is ascending or not.
>
> fkQuery.getCriteria().addOrderBy(cds.getOrderBy(), cds.isAscending());
>
> One possible solution would be to separate the different order by commas:
> order="ASC,DESC,ASC"
> and modify the appropiate classes to get the correct behaviour.
>
> However I don't know if SQL allows different orders in the query.
>
> Jose Maria
>
>
> > hi jose,
> >
> > i'd like to have a clean solution providing multiple order by and their
> > _individual ASC/DESC_ in the repository.xml. being not an xml-expert i
do
> > not know how to define this properly. also i do not know how to avoid
> > breaking everyone's repository by adding multi order by ????
>
> > jakob
>
>
>
>
> --
> To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to