topic Re: Query Widget - Results sorted Alphabetically or Numerically in ArcGIS Viewer for Flex Questions

Query Widget - Results sorted Alphabetically or Numerically

BrianKratcha — Thu, 07 Oct 2010 18:57:43 GMT

Is there an easy way to have my Query Widget return results sorted alphabetically or numerically? Right now the results come back sorted randomly.

Thanks,

Brian

Re: Query Widget - Results sorted Alphabetically or Numerically

MarcWeinshenker1 — Fri, 10 Dec 2021 22:02:09 GMT

Here's a solution I picked up off the forums a while back. You'll need to edit QueryWidget.mxml and recompile. In the function onResult, add the middle line as shown in the first code snippet to call a sorting function for the query results.

 
                            queryResultAC = createQueryResults(featureSet);
       queryResultAC = SortDataGridData("title",queryResultAC);
                            addSharedData(widgetTitle, queryResultAC);

Then put this sorting function somewhere in the module.

private function SortDataGridData(strFieldNameToSort:String,recACToSort:ArrayCollection):ArrayCollection{  
    try{
     // CC -Orginal code by BJ and found at forum post http://forums.esri.com/Thread.asp?c=158&f=2421&t=285419&mc=6#msgid886159
     var dataSortField:SortField = new SortField();
     dataSortField.name=strFieldNameToSort;
     var alphabetDataSort:Sort = new Sort();
     alphabetDataSort.fields=[dataSortField];
     recACToSort.sort=alphabetDataSort;
     recACToSort.refresh();
    }
    catch(error:Error){
    }
    return recACToSort;
   }

Re: Query Widget - Results sorted Alphabetically or Numerically

BrianKratcha — Fri, 10 Dec 2021 22:02:12 GMT

 
                            queryResultAC = createQueryResults(featureSet);
       queryResultAC = SortDataGridData("title",queryResultAC);
                            addSharedData(widgetTitle, queryResultAC);

Then put this sorting function somewhere in the module.

private function SortDataGridData(strFieldNameToSort:String,recACToSort:ArrayCollection):ArrayCollection{  
    try{
     // CC -Orginal code by BJ and found at forum post http://forums.esri.com/Thread.asp?c=158&f=2421&t=285419&mc=6#msgid886159
     var dataSortField:SortField = new SortField();
     dataSortField.name=strFieldNameToSort;
     var alphabetDataSort:Sort = new Sort();
     alphabetDataSort.fields=[dataSortField];
     recACToSort.sort=alphabetDataSort;
     recACToSort.refresh();
    }
    catch(error:Error){
    }
    return recACToSort;
   }

Thanks for the reply RockvilleGIS,

One thing I had to add was this code below into the QueryWidget.mxml code to keep from getting an error.

                                      import mx.collections.SortField;
   import mx.collections.Sort;
   import mx.collections.ArrayCollection;

Thanks again,

Brian

Re: Query Widget - Results sorted Alphabetically or Numerically

R__CraigHolmes — Thu, 14 Oct 2010 15:48:15 GMT

NICE!
Thanks Gents.
I wasn't putting in the import mx.collections.Sort; along with the import mx.collections.SortField;
She's sortin' now though!

Re: Query Widget - Results sorted Alphabetically or Numerically

TorstenSchramm — Mon, 18 Oct 2010 10:07:48 GMT

great work
thanks,
Torsten

Re: Query Widget - Results sorted Alphabetically or Numerically

JuneAcosta — Thu, 30 Dec 2010 03:10:30 GMT

I just added the above code to the query widget for Flex Viewer 2.2, but my data is still not sorting. I changed the "title" to the field name of my layer that I want to sort-- I get no errors, but still no sorting. Did anyone else run into this issue? Did you resolve it?

-June

Re: Query Widget - Results sorted Alphabetically or Numerically

KeithBornhorst — Sun, 09 Jan 2011 15:14:29 GMT

June,

Change the sort field back to "title" and the Query widget will sort your results based upon the <titlefield> specified in your widget config file. The embedded code only allows sorting on QueryResult fields (title, content, link, etc.). Additional, more complex code would be needed to support sorting on
alternative fields.

Re: Query Widget - Results sorted Alphabetically or Numerically

DerekTokarz1 — Thu, 20 Jan 2011 14:45:05 GMT

I keep getting an error in Flex builder that says

"1013: The private attribute may only be used on class property definitions."
The error refers to the Array Collection field or line shown in the code below.

// for Alpha
     private function SortDataGridData(strFieldNameToSort:String,recACToSort:ArrayCollection):ArrayCollection{
      try{
       // CC -Orginal code by BJ and found at forum post http://forums.esri.com/Thread.asp?c=158&f=2421&t=285419&mc=6#msgid886159
       var dataSortField:SortField = new SortField();
       dataSortField.name=strFieldNameToSort;
       var alphabetDataSort:Sort = new Sort();
       alphabetDataSort.fields=[dataSortField];
       recACToSort.sort=alphabetDataSort;
       recACToSort.refresh();
      }
      catch(error:Error){
      }
      return recACToSort;
     }

Any ideas as to what can be causing this. I am a beginner in flex so please bare with me.
Thanks,

Derek

Re: Query Widget - Results sorted Alphabetically or Numerically

JuneAcosta — Mon, 24 Jan 2011 18:33:14 GMT

Keith,

Thanks for the help- I would have never figured it out.

-june

Re: Query Widget - Results sorted Alphabetically or Numerically

SarahSchrader — Thu, 10 Feb 2011 13:56:49 GMT

Thank you! This worked perfectly!! The fact that our query list was not alphabetical was one of the first things my supervisor noticed and asked to have changed. I'm glad that you already put this code together and shared it so I didn't have to figure out how to create this from scratch.

Re: Query Widget - Results sorted Alphabetically or Numerically

JonBeets1 — Wed, 23 Nov 2011 17:54:25 GMT

If someone already has this done can you please send me the compiled widget?...

It's also interesting that a sorting feature wasn't built into the widget originally. No one wants to scroll through a 100 result query that's not sorted... 😉

Jon Beets

Jon.Beets@us.af.mil

Re: Query Widget - Results sorted Alphabetically or Numerically

BrianKratcha — Wed, 27 Jun 2012 14:58:41 GMT

Is anyone else having problems getting the above to work in 3.0?

Re: Query Widget - Results sorted Alphabetically or Numerically

MelissaPrindiville — Fri, 20 Jul 2012 14:56:51 GMT

I am having a problem with the code in version 3. Any ideas on how to fix it? No errors just doesn't sort. I had it working in previous versions.

Re: Query Widget - Results sorted Alphabetically or Numerically

MarkHuffman — Wed, 01 Aug 2012 20:33:13 GMT

I tried this code for the first time in a version 3 viewer. I updated it to match changes between 2 and 3. I confirm that, although no errors are thrown, no sorting is done either. Can whoever has adapted the code successfully please post? Thanks.

Mark

Re: Query Widget - Results sorted Alphabetically or Numerically

daveespinosa-aguilar — Wed, 01 Aug 2012 21:27:47 GMT

also having same issues with 3... no errors, still queries, doesn't sort. looking into it further...

Re: Query Widget - Results sorted Alphabetically or Numerically

SerenaO_Connor — Wed, 08 Aug 2012 13:57:41 GMT

Just wondering has this been sorted for 3.0

I have a list of buildings which I need to show alphabetically and just wondering what code I should add.

<?xml version="1.0" ?>
<configuration>
    <layer>http://localhost:6080/arcgis/rest/services/UCC/Buildings/MapServer/0</layer>
    <query/>
    <titlefield>Name</titlefield>
    <linkfield>Name2</linkfield>
    <refreshrate>3</refreshrate>
    <zoomscale>15000</zoomscale>
    <fields all="false">
        <field name="Name" alias="Name"/>
    </fields>
</configuration>

Any help would be much appreciated.
S

Re: Query Widget - Results sorted Alphabetically or Numerically

BrianKratcha — Mon, 17 Sep 2012 13:43:19 GMT

So has anyone had any luck?

Re: Query Widget - Results sorted Alphabetically or Numerically

MarcWeinshenker1 — Fri, 28 Sep 2012 15:49:21 GMT

For anyone following this thread, I found the same problem when converting to Flex Viewer 3.0 and I have filed a support incident to see if this can be addressed.

[edit -- solution posted here http://forums.arcgis.com/threads/67832-Query-Widget-3.0-sort-results?p=236775&posted=1#post236775 ]

Marc

Re: Query Widget - Results sorted Alphabetically or Numerically

JohnGregorovic — Mon, 17 Dec 2012 20:02:30 GMT

Worked great for me, thank you for you help.

Re: Query Widget - Results sorted Alphabetically or Numerically

HeatherGonzago — Tue, 18 Dec 2012 16:32:51 GMT

This functionality is directly provided out of the box using 3.1.

Refer to http://resources.arcgis.com/en/help/flex-viewer/concepts/index.html#/Query_widget/01m30000003m000000/

Order by

and http://resources.arcgis.com/en/help/flex-viewer/concepts/index.html#/Query_widget_tags/01m30000000t000000/

if working with tag references