topic query operation order by in ArcGIS REST APIs and Services Questions

query operation order by

LukePhilips — Thu, 28 Jul 2011 23:03:57 GMT

is it possible to query a service and have it return an order set of data? it seems the result set of a query envelope is a random order. essentially the ordered attribute is a market value and I want an those points with the highest market value up until I hit the max returned results parameter. e.g. the 500 highest valued points for any given envelope.

Re: query operation order by

LukePhilips — Thu, 28 Jul 2011 23:40:53 GMT

this is very close to my issue:
http://forums.arcgis.com/threads/2789-order-querytask-results
likewise it seems the 'order by' in the where clause works by accident. It works when only a where statement is populated and nothing else, it does not work when I enter any kind of filter geometry.

Re: query operation order by

SrinivasVinnakota — Fri, 29 Jul 2011 18:09:47 GMT

Query operations at 10.0 and prior releases do not support ORDER BY clause.

Re: query operation order by

LukePhilips — Wed, 03 Aug 2011 15:24:02 GMT

Query operations at 10.0 and prior releases do not support ORDER BY clause.

what's the plan going forward?

Re: query operation order by

SrinivasVinnakota — Wed, 03 Aug 2011 18:24:50 GMT

this feature should be available at 10.1

Re: query operation order by

LukePhilips — Thu, 04 Aug 2011 21:55:18 GMT

will I see this feature in the 10.1 beta?

Re: query operation order by

SrinivasVinnakota — Fri, 05 Aug 2011 13:13:19 GMT

Yes, it is available in Beta 1.

Re: query operation order by

OrlandoCarvajal — Mon, 29 Aug 2011 20:33:30 GMT

Will it be possible to use this ORDER BY parameter combined with "returnIdsOnly" so the Ids get returned in a particular order?

Re: query operation order by

SrinivasVinnakota — Tue, 30 Aug 2011 13:44:59 GMT

Neocan,
"orderByFields" can be used combination with "returnIdsOnly" to return object ids in the desired order.