topic Re: Order By Fields not working in ArcGIS Server 10.1. in ArcGIS JavaScript Maps SDK Questions

Order By Fields not working in ArcGIS Server 10.1.

MuditAgarwal — Tue, 23 Sep 2014 04:11:55 GMT

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

Re: Order By Fields not working in ArcGIS Server 10.1.

RobertScheitlin__GISP — Tue, 23 Sep 2014 12:33:10 GMT

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.

Re: Order By Fields not working in ArcGIS Server 10.1.

MuditAgarwal — Fri, 26 Sep 2014 07:42:00 GMT

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

Re: Order By Fields not working in ArcGIS Server 10.1.

RobertScheitlin__GISP — Fri, 26 Sep 2014 13:19:15 GMT

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.