query operation order by

1133
8
07-28-2011 04:03 PM
LukePhilips
New Contributor III
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.
0 Kudos
8 Replies
LukePhilips
New Contributor III
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.
0 Kudos
SrinivasVinnakota
Esri Contributor
Query operations at 10.0 and prior releases do not support ORDER BY clause.
0 Kudos
LukePhilips
New Contributor III
Query operations at 10.0 and prior releases do not support ORDER BY clause.

what's the plan going forward?
0 Kudos
SrinivasVinnakota
Esri Contributor
this feature should be available at 10.1
0 Kudos
LukePhilips
New Contributor III
will I see this feature in the 10.1 beta?
0 Kudos
SrinivasVinnakota
Esri Contributor
Yes, it is available in Beta 1.
0 Kudos
OrlandoCarvajal
New Contributor III
Will it be possible to use this ORDER BY parameter combined with "returnIdsOnly" so the Ids get returned in a particular order?
0 Kudos
SrinivasVinnakota
Esri Contributor
Neocan,
  "orderByFields" can be used combination with "returnIdsOnly" to return object ids in the desired order.
0 Kudos