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

[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.

[MuditAgarwal · Accepted solution]

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

[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.