topic Re: query.orderByFields bug in ArcGIS JavaScript Maps SDK Questions

query.orderByFields bug

StevenHaslemore — Wed, 19 Feb 2014 16:00:50 GMT

After applying the ArcGIS Server 10.1 Quality Improvement Patch we're getting errors on queries using the orderByFields parameter.

query.outSpatialReference = map.spatialReference;
query.returnGeometry = false;
query.outFields = ["*"];
query.where = "1=1";
query.orderByFields = ["OBJECTID"];

The js api encodes this into the request as
orderByFields=OBJECTID <-- FAILS with "{"error":{"code":400,"message":"Unable to complete operation.","details":[]}}"

Running the same query through the rest service explorer results in that parameter being encoded as
orderByFields=["OBJECTID"] <--- WORKS

I can confirm our endpoint table Supports Advanced Queries and I have tested this against the latest api version.
Is there another query parameter that I'm missing?

Re: query.orderByFields bug

JeffPace — Wed, 19 Feb 2014 16:56:28 GMT

After applying the ArcGIS Server 10.1 Quality Improvement Patch we're getting errors on queries using the orderByFields parameter.

query.outSpatialReference = map.spatialReference;
query.returnGeometry = false;
query.outFields = ["*"];
query.where = "1=1";
query.orderByFields = ["OBJECTID"];

The js api encodes this into the request as
orderByFields=OBJECTID <-- FAILS with "{"error":{"code":400,"message":"Unable to complete operation.","details":[]}}"

Running the same query through the rest service explorer results in that parameter being encoded as
orderByFields=["OBJECTID"] <--- WORKS

I can confirm our endpoint table Supports Advanced Queries and I have tested this against the latest api version.
Is there another query parameter that I'm missing?

Terrible work around but have you tried

query.orderByFields = ["[\"OBJECTID\"]"];

Re: query.orderByFields bug

StevenHaslemore — Wed, 19 Feb 2014 20:19:37 GMT

Terrible work around but have you tried
query.orderByFields = ["[\"OBJECTID\"]"];

Very sneaky, the old sting that looks like an array inside an array trick, it works!

Re: query.orderByFields bug

JeffPace — Thu, 20 Feb 2014 14:52:41 GMT

im a hack, i almost dont want credit for that!!!

Glad it worked, make sure you comment it well in your code so when it changes back in the next version you can find it quickly and revert 🙂