is there a way to sort by more than one column value? i.e. have a field fiscalmonth and fiscalyear and want to sort by fiscalyear, fiscalmonth
In a service you can specify queries that can allow you to sort on multiple fields.
So you can use the Query infotable function for that.
Also see: 03.14.06.01 Query Parameter for Query Services in the Wiki
Retrieving data ...