topic Re: Sort Unique Values in Ascending Order using Query Builder in ArcGIS API for Flex Questions

Sort Unique Values in Ascending Order using Query Builder

JasonHancheruk — Mon, 17 May 2010 15:17:48 GMT

I am trying to return only unique values and then sort them in ascending order using Query Builder for SFV1 1.3. I have tried to adapt some codes that were published in the old forums, but nothing has worked. Has anybody implemented this in there own project? Any help would be appreciated.

/* private function onFieldValuesRereivalsuccess(obj:Object):void{
   mqbMessage = "Values has been retreived."
   CursorManager.removeBusyCursor();
   var fset:FeatureSet = obj as FeatureSet;
   mqbMessage = "";
   mFldValues = fset.features;
}
*/

private function onFieldValuesRereivalsuccess(obj:Object):void
{
   mqbMessage = "Values have been retreived."
   CursorManager.removeBusyCursor();
   var fset:FeatureSet = obj as FeatureSet;
   mqbMessage = "";
//use the uniquearray function to get a unique list.
   mFldValues = uniqueArray(fset.features);
}

private function uniqueArray(a:Array) : Array
{
      var unique : Array = new Array();
      var contains : Boolean;

       for( var i:Number = 0; i<a.length; i++ )
      {
            contains = false;
            for (var j:Number = 0; j<unique.length; j++)
           {
                if (a == unique) contains = true;
            }
            if (!contains)
    {
        if (a != "")
        {
            unique.push(a);
        }
    }
      }
      return unique;
}

Jason

Re: Sort Unique Values in Ascending Order using Query Builder

CristianJonhson — Sat, 11 Dec 2021 11:54:56 GMT

I dont know if I understood what u were asking for, but maybe it is something like that?

  private function sortArrayRemoveDupl(arr:Array):Array
   {
    var newArr:Array=[];    
    var pivo:Object=arr.shift();   
    arr.sort();    
    newArr.push(pivo);    
    while (pivo!=null)
    {
     if (pivo == arr[0])     
      pivo = arr.shift();
     else{newArr.push(pivo); pivo = arr.shift(); }
    }
    newArr.sort();
    return newArr;
   }

This should set a new array with unique values and order it... but remember, if u give a featureSet to sort and remove duplicated, it will compare FULL objects, not only the field u want, to do a sort on a field from a table, u should use feature.attributes.ATRIBUTE.

Att.,
Cristiano Benato

Re: Sort Unique Values in Ascending Order using Query Builder

SusanMordy1 — Wed, 19 May 2010 21:27:11 GMT

Barbara's code posted here: http://forums.esri.com/Thread.asp?c=158&f=2421&t=302204

Will return unique values.

You just need to add:

private var mFldValues2:Array = null;

to QueryBuilderWidget.mxml in addition to the code provided by Barbara.

Not ascending, but it's a step in the right direction.

Re: Sort Unique Values in Ascending Order using Query Builder

JasonHancheruk — Tue, 25 May 2010 20:10:39 GMT

Sorry I did not reply sooner, but I thought these threads would send an email as the older forums did. Guess I need to check my settings.

The action script I used was incorporated from Mark Hoyland in the forum, http://forums.esri.com/Thread.asp?c=158&f=2421&t=302204, as the one from Barbara Patterson caused 14 errors of "1013: The private attribute may be used only on class definitions" through the rest of the private functions in the QueryBuilderWidget.mxml.

Not sure how to fix this error?

Thanks,
Jason

Re: Sort Unique Values in Ascending Order using Query Builder

NathanEnge — Sat, 11 Dec 2021 11:54:58 GMT

private function onFieldValuesRereivalsuccess(obj:Object):void{
   mqbMessage = "Values have been retrieved."
   CursorManager.removeBusyCursor();
   var fset:FeatureSet = obj as FeatureSet;
   mqbMessage = "";
   //First array that contains all the features   
   mFldValues2 = fset.features;
   //The name of the field the user has selected
   var fldname:String = fieldsLst.selectedItem.Name
   var contains : Boolean;
   //The new array that will contain only unique features based on the selected field
   mFldValues = new Array(); 
   
   
   for( var i:Number = 0; i<mFldValues2.length; i++ ) {
            contains = false;
            for (var j:Number = 0; j<mFldValues.length; j++)
           {
              // Lines below return the string value for the selected fields from the 2 arrays
               
               var item1:String = mFldValues2.attributes[fieldsLst.selectedItem.Name];
               var item2:String = mFldValues.attributes[fieldsLst.selectedItem.Name];
               if (item1 == item2) contains = true;
          }
          //if the value is not already in the array add it to the array
            if (!contains)
            {
                 mFldValues.push(mFldValues2);
            }  
      } 
      
      
      var myArray:Array = new Array();
      var strValue:String = "";
      for (var a:Number = 0; a<mFldValues.length; a++)
      { 
       strValue = mFldValues.attributes[fieldsLst.selectedItem.Name].toString();
       myArray.push(strValue);
       //Alert.show(myArray.toString());
      }
      
     
      var temp:String = "";
      var tmpObject:Object = null;
      
      for (var x:Number = 0; x < myArray.length; x++)
      {
      for (var z:Number = 0; z < myArray.length; z++)
      {
       if (myArray > myArray[z+1])
       {
        temp = myArray;
        tmpObject = mFldValues;
        
        myArray = myArray[z+1];
        mFldValues = mFldValues[z+1];
        
        myArray[z+1] = temp;
        mFldValues[z+1] = tmpObject;
       }
      }
      }
      
      /*
      for (var y:Number = 0; y < myArray.length; y++)
      {
       //Alert.show(myArray.toString());
       Alert.show(mFldValues.attributes[fieldsLst.selectedItem.Name].toString());
      }
      */
  }