Sort Unique Values in Ascending Order using Query Builder

JasonHancheruk

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

NathanEnge

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());
      }
      */
  }