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; } } }

Order By Fields not working in ArcGIS Server 10.1.

MuditAgarwal

Hello Everyone,

Does ArcGIS Server 10.1 supports Order By Fields on layer resource coming from FGDB ? We are working on Arcgis server 10.1 with QIP installed and data source is FGDB. Layer resource Supports Advanced Queries. I am writing ORDER BY clause like [fieldName ASC]. Order by on any field is not working. Any help appreciated.

Thanks

Mudit

Find more posts tagged with

Accepted answers

MuditAgarwal

Thanks Robert for quick reply. I am using ORDER BY in REST API interface available when you hit URL (http://ServerName/arcgis/rest/services/ServiceName/MapServer/layerIndex/query) in browser. I tried the way you described but no luck so I managed it by sorting the values in java script array after getting the result.

Thanks

Mudit

All comments

RobertScheitlin__GISP

Mudit,

So you are saying that when you go to the RSET Service Directory page for your service you specify a field for the "Order By Fields:" item on the web form and it does not order the results? If this is truly the case then you should call tech support on this.

MuditAgarwal

Thanks

Mudit

RobertScheitlin__GISP

Mudit,

Because you are using ArcGIS Server 10.1 you do have the ability to use the Order by Fields property. Here is an example of how it is used:

query.orderByFields = ["STATE_NAME DESC"];

Not sure how you are try to do this without seeing your code, but it sounds like you are trying to add a ORDER BY to your Where clause and this is not supported.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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