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 3.0 sort results

NedCake

There were code samples available at previous versions of SFV to enable sorting in this widget. Nothing yet at version 3.0. Any help would be appreciated.

Ned Cake
TLCGIS

Trouver plus de publications taguées avec

Accepted answers

NedCake

We got it to work! This will sort using the title field designated in the config file.

Add This function to QueryWidget .mxml

                        //COMPARE FUNCTION
   private function sortByAttribute(a:Object, b:Object):Object
   {
    var x:String = a.attributes[queryTitleField].toLowerCase();
    var y:String = b.attributes[queryTitleField].toLowerCase();
    return ((x < y) ? -1 : ((x > y) ? 1 : 0));
   }

Add this code to the query features function at about line 310
                       // sort feature set
        featureSet.features.sort(sortByAttribute); //sort by calling compare function

Thanks to John Marquez from TLCGIS and ESRI staff
Ned Cake

All comments

AngieAllison

WHERE IS THIS QUERY WIDGET?? i am trying to get a query widget for flexviewer 3.0 and not finding one.

PeterHoffman

I made the changes you suggested w/o luck.
Maybe api 3.1 will have this functionality builtin.
Thanks for your help.

MarcWeinshenker1

I only see a couple of functional differences in your config file from what I am doing, and they may or may not be relevant but could be worth experimenting with. For the Query I use <query> OBJECTID > 0 </query> to get all results. And I don't use any filterfield. My data source, again not that I see how it might matter, is from SDE.

PeterHoffman

The sort used to work using api 2.X and the other sort function. I am using sdk 4.6 and I used a clean version of the query widget code.
Here is my xml code:

<?xml version="1.0" ?>
<configuration label="Suffolk County Buildingss">
    <layer>http://gistestdev:6080/arcgis/rest/services/CountyBuildings/MapServer/0</layer>
    <query>1=1</query>
    <titlefield>BUILDINGNU</titlefield>
    <linkfield></linkfield>
    <fields all="false">
        <field name="BUILDINGNU" alias="#"/>
        <field name="CURRENTUSE" alias="Name"/>
        <field name="COUNTYCOMP" alias="Complex"/>
         <field name="CURRENTSTAFF" alias="Current Staff"/>
    </fields>
      <filterfield>
        <name>BUILDINGNU</name>
        <alias>Filter by Building #</alias>
    </filterfield>
    <refreshrate></refreshrate>
    <zoomscale>25000</zoomscale>
</configuration>

MarcWeinshenker1

Not sure what to suggest, but make sure there are no obvious problems with the added function, such as missing some content or that it was copied into the wrong place. Maybe even delete the function then copy and paste it back in from the code posted above. Look at the configuration xml to be sure the layer, the query, and the fields are properly accounted for and maybe experiment with other layers/fields to see if they behave differently. Have you made other modifications to the Query widget code or just this? Also, what Flex SDK are you using? I'm using 4.6. If none of these things turns up anything, then it's beyond my expertise.

I made the code changes, now I get a error 1009. If I comment out the sort line I get 691 records but they are not sorted of course.

PeterHoffman

I made the code changes, now I get a error 1009. If I comment out the sort line I get 691 records but they are not sorted of course.

MarcWeinshenker1

Here you go.

                    function onResult(featureSet:FeatureSet, token:Object = null):void
                    {
                        try
                        {
    // sort feature set with sortByAttribute compare function added below
    featureSet.features.sort(sortByAttribute); 
       
                            queryResultAC = createQueryResults(featureSet);
                            addSharedData(widgetTitle, queryResultAC);

                            clearMessage();

I am having trouble modifying the code, where do I put the featureSet. stuff? Can you show a section of the code because I am getting a 1069 error.

Thanks,

PeterHoffman

I am having trouble modifying the code, where do I put the featureSet. stuff? Can you show a section of the code because I am getting a 1069 error.

Thanks,

BjornSvensson

FYI: In the next version (3.1) of the Flex Viewer, you will be able to specify a sort field (orderbyfield) for both Query and Search widget.

BrianKratcha

Thanks I have it sorting in most cases,

One problem that I ran into is that the code gives an error when the sort field values start with numbers.

For example = 139-Newton or 155- Thomas. Unfortunately, I cannot change the values of the data.

Any ideas on this?

MarcWeinshenker1

Outstanding! Thank you.

NedCake

MarcWeinshenker1

I'm struggling with this myself as I am converting my Flex viewer apps from 2.5 to 3.0. I've tried a lot of things and nothing works. I'm going to file a support incident and see if I can get esri help. Really can't understand why sorting is not including in the published widget.

[edit -- incident has been assigned. I will share whatever comes of it.]

Marc

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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