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

Query Widget - Results sorted Alphabetically or Numerically

BrianKratcha

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

Find more posts tagged with

Accepted answers

All comments

HeatherGonzago

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

JohnGregorovic

Worked great for me, thank you for you help.

MarcWeinshenker1

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

BrianKratcha

So has anyone had any luck?

SerenaO_Connor

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

daveespinosa-aguilar

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

MarkHuffman

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

MelissaPrindiville

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.

BrianKratcha

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

JonBeets1

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

SarahSchrader

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.

JuneAcosta

Keith,

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

-june

DerekTokarz1

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

KeithBornhorst

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.

JuneAcosta

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

TorstenSchramm

great work
thanks,
Torsten

R__CraigHolmes

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!

BrianKratcha

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

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

MarcWeinshenker1

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

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.