topic Re: Query Widget 3.0 sort results in ArcGIS Viewer for Flex Questions

Query Widget 3.0 sort results

NedCake — Thu, 27 Sep 2012 12:25:43 GMT

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

Re: Query Widget 3.0 sort results

MarcWeinshenker1 — Fri, 28 Sep 2012 13:55:06 GMT

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

Re: Query Widget 3.0 sort results

NedCake — Fri, 28 Sep 2012 19:22:43 GMT

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

Re: Query Widget 3.0 sort results

MarcWeinshenker1 — Fri, 28 Sep 2012 19:31:15 GMT

Outstanding! Thank you.

Re: Query Widget 3.0 sort results

BrianKratcha — Wed, 03 Oct 2012 19:21:26 GMT

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?

Re: Query Widget 3.0 sort results

BjornSvensson — Thu, 04 Oct 2012 13:53:04 GMT

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.

Re: Query Widget 3.0 sort results

PeterHoffman — Fri, 23 Nov 2012 17:39:05 GMT

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,

Re: Query Widget 3.0 sort results

MarcWeinshenker1 — Sat, 11 Dec 2021 19:07:55 GMT

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,

Re: Query Widget 3.0 sort results

PeterHoffman — Mon, 26 Nov 2012 12:27:44 GMT

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.

Re: Query Widget 3.0 sort results

MarcWeinshenker1 — Mon, 26 Nov 2012 12:47:19 GMT

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.

Re: Query Widget 3.0 sort results

PeterHoffman — Mon, 26 Nov 2012 13:47:19 GMT

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>

Re: Query Widget 3.0 sort results

MarcWeinshenker1 — Mon, 26 Nov 2012 14:09:10 GMT

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.

Re: Query Widget 3.0 sort results

PeterHoffman — Mon, 26 Nov 2012 14:51:31 GMT

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

Re: Query Widget 3.0 sort results

AngieAllison — Tue, 27 Nov 2012 18:56:33 GMT

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