Multiple orderBy fields

[SvSigb]

Hi.

I am trying to write a dynamic query where the orderBy clause may contain 1 or more fields:
       
        SQLQuery<MyClass> qry = queryFactory.select(blablabla)
                .from(myTable)
                .where(whereClause)
                .orderBy(field1.asc(), field2.desc(), ......)
                .fetch();

Any suggestions on how to do this?

Thanks,
Sveinung

[SvSigb]

OK. I found it out myself. I create an OrderSpecifier array that I put into the orderBy clause:

        List<OrderSpecifier> l = new ArrayList<>();
        .....
        l.add(field1.desc());
        l.add(field2.asc());
        l.add(field3.desc());
        .....
        OrderSpecifier[] orderCols = l.toArray(new OrderSpecifier[l.size()]);

        SQLQuery<MyClass> qry = queryFactory.select(blablabla)
                .from(myTable)
                .where(whereClause)

                .orderBy(orderCols)
                .fetch();