Hello,
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 ?
The query:
FOR $o IN document(“offices.xml”)//dataroot//OFFICES
RETURN
{$o/CITY}
{$o/REGION}
{$o/SALES/text()-$o/TARGET/text()}
SORTBY(REGION ASCENDING, diff DESCENDING)