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.

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

[PeteVitt]

Was it ever determined if the ordering could be achieved?

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

[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

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

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]

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

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