I try to sort a query result (see the query below). I want to sort by two fields. When I let them sort separatly, they are correct. But when I combine the two fields QuiP sorts everything DESCENDING in stead of sorting the first field ASCENDING and the second DESCENDING.
Is my interpretation of the XQuery wrong or is it a problem with QuiP ?
FOR $o IN document(“offices.xml”)//dataroot//OFFICES
SORTBY(REGION ASCENDING, diff DESCENDING)