Having issues to configure the Sorting on Query Results while configuring the app. Using 1.2 Version of the WebApp Builder. Trying to sort the results by order but the pencil is greyed out. Thanks and any help in this regards will be highly appreciated.
The pencil will be grayed out if your map service does not support supportsOrderBy you can check if your map service supports this by going to the REST endpoint page for the layer and looking for this:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
The availability of this advanced features depends on the version of ArcGIS Server you are running. Time to upgrade. Also based on the URL in your image you are looking at the mapservice end point. Try looking at the layers endpoint.
Looking at the Query widgets source code I can see that the server has to support OrderBy and Pagination for the pencil to be enabled.
Here is a thread about when pagination is enabled: How do you enable the "Supports Pagination" on a layer at 10.3?
ArcGIS Server supports `order by fields` from 10.2, but the `order fields` must be an element of `outFields` array; 10.3 conquered this shortcoming but must be enable pagination.
So the order feature in Query and AttributeTable only support 10.3 services which enabled `OrderBy` and `Pagination`.