nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Order QueryTask results?

TimLowrimore

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.

Find more posts tagged with

Accepted answers

All comments

DerekLoi

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

HemingZhu

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"?

DerekLoi

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);

HemingZhu

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

DerekLoi

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.

HemingZhu

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

MarkSmith

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.

PeteVitt

Was it ever determined if the ordering could be achieved?

ReneeMaxwell

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.