topic Re: Order QueryTask results? in ArcGIS JavaScript Maps SDK Questions

Order QueryTask results?

TimLowrimore — Fri, 16 Apr 2010 20:48:25 GMT

Is there a way to order QueryTask results?

I have a query and query tasks setup to return a featureset of polylines and I'd like to have them ordered by shape.len. Is that possible?

Thanks.

Re: Order QueryTask results?

ReneeMaxwell — Wed, 19 May 2010 17:25:50 GMT

I have the same questions. I'd also like to limit the query results to the first 10. I can't find any documentation on this. I tried using normal SQL query syntax but that failed.

Re: Order QueryTask results?

PeteVitt — Wed, 15 Dec 2010 14:33:35 GMT

Was it ever determined if the ordering could be achieved?

Re: Order QueryTask results?

MarkSmith — Thu, 16 Dec 2010 09:35:11 GMT

Hi,

The only way I found to do this was to insert the query results into a javascript multidimensional array. You can then sort the array on a column and access the rows in the array if that helps.

Re: Order QueryTask results?

HemingZhu — Thu, 16 Dec 2010 19:09:20 GMT

Is there a way to order QueryTask results?

I have a query and query tasks setup to return a featureset of polylines and I'd like to have them ordered by shape.len. Is that possible?

Thanks.

Try this: query.where = " your where clause.. ORDER BY SHAPE.LEN"; Note: only work on 9.3.1 above

Re: Order QueryTask results?

DerekLoi — Mon, 14 Mar 2011 21:04:00 GMT

Try this: query.where = " your where clause.. ORDER BY SHAPE.LEN"; Note: only work on 9.3.1 above

So has anyone confirmed that this works? I'm trying this and it doesn't seem to work.

Re: Order QueryTask results?

HemingZhu — Tue, 15 Mar 2011 12:44:30 GMT

So has anyone confirmed that this works? I'm trying this and it doesn't seem to work.

I used ORDER BY in you code a couple of times and I have no problem with it. It is an added feature on 9.3.1. I don't see why it would not work on 10...

Re: Order QueryTask results?

DerekLoi — Sat, 11 Dec 2021 21:54:58 GMT

I used ORDER BY in you code a couple of times and I have no problem with it. It is an added feature on 9.3.1. I don't see why it would not work on 10...

so can you show an example of your code? i'm not so sure if the problem lies with ver 9.3.1 or ver 10.. the problem lies with the version of the API... I'm using v2.2 of the Javascript API ....
here's my code and it just dies at the "query.where" line...
if i take out the ".. ORDER BY" and just use query.where = "ACTIVE = 'Y'" then it works without a hitch

        var queryTask = new esri.tasks.QueryTask(serviceURL + "/" + index);
        var query = new esri.tasks.Query();
        query.returnGeometry = false;
        query.outFields = ["INDEX", "ADDRESS", "ZIP"];
 query.where = "ACTIVE = 'Y'.. ORDER BY INDEX";
 queryTask.execute(query,queryResults);

Re: Order QueryTask results?

HemingZhu — Sat, 11 Dec 2021 21:55:00 GMT

so can you show an example of your code? i'm not so sure if the problem lies with ver 9.3.1 or ver 10.. the problem lies with the version of the API... I'm using v2.2 of the Javascript API ....
here's my code and it just dies at the "query.where" line...
if i take out the ".. ORDER BY" and just use query.where = "ACTIVE = 'Y'" then it works without a hitch
        var queryTask = new esri.tasks.QueryTask(serviceURL + "/" + index);
        var query = new esri.tasks.Query();
        query.returnGeometry = false;
        query.outFields = ["INDEX", "ADDRESS", "ZIP"];
 query.where = "ACTIVE = 'Y'.. ORDER BY INDEX";
 queryTask.execute(query,queryResults);

what is the two dots for in your code ".. ORDER BY INDEX"?

Re: Order QueryTask results?

DerekLoi — Wed, 16 Mar 2011 15:25:10 GMT

what is the two dots for in your code ".. ORDER BY INDEX"?

ah crap... (i think i need to take a break from coding for a bit)
thanks for your help