nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

query operation order by

LukePhilips

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.

Vind meer berichten getagd met

Accepted answers

All comments

LukePhilips

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.

SrinivasVinnakota

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

LukePhilips

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

what's the plan going forward?

SrinivasVinnakota

this feature should be available at 10.1

LukePhilips

will I see this feature in the 10.1 beta?

SrinivasVinnakota

Yes, it is available in Beta 1.

OrlandoCarvajal

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

SrinivasVinnakota

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.