topic Re: Query.where Syntax in ArcGIS API for Flex Questions

Query.where Syntax

WesBailes — Mon, 15 Nov 2010 15:17:45 GMT

I am trying to implement a DISTINCT query. Is this method supported? Can't seem to get it to work. Here is my current syntax:

query.where = "DISTINCT Map WHERE DISTRICT= '" + strDistrict + "'"

Is there any documentation on query syntax for map services (or feature services). Thanks for any suggestions!

Re: Query.where Syntax

RobertScheitlin__GISP — Mon, 15 Nov 2010 16:40:26 GMT

Wes,

No that is not supported. What you are attempting to do is specify a SELECT statement and all you are allowed to do is specify the WHERE portion of the SELECT statement as the property alludes to.

Re: Query.where Syntax

WesBailes — Tue, 16 Nov 2010 13:58:49 GMT

Thanks Robert! Kind of what I figured. I found a workaround for my situation that seems to work fine.

Re: Query.where Syntax

DavidSavory1 — Thu, 16 Dec 2010 22:55:46 GMT

Hi Wes,

I have a need to do same thing and was hoping to find an elegant solution. I was planning on developing a post query algorithm to find the unique values. Would you mind sharing your solution.

Thanks,
David Savory

Re: Query.where Syntax

WesBailes — Fri, 17 Dec 2010 11:29:15 GMT

Hi Wes,

I have a need to do same thing and was hoping to find an elegant solution. I was planning on developing a post query algorithm to find the unique values. Would you mind sharing your solution.

Thanks,
David Savory

In this scenario I am attempting to find the distinct Map within the query. You will need an ArrayList or ArrayCollection declared somewhere (mapsAL).

function onResult(featureSet:FeatureSet, token:Object = null):void
        {
             var i:int = 1;
             var j:int=0;
             var item:String;
             var sortAttr:Array;

             sortAttr=featureSet.attributes.sortOn("Map");
             //loop to add unique Map values to the mapsAL array list
             for (j=0; j<featureSet.attributes.length-1; j++)
                 {
                       item = sortAttr.Map;
                       //getItemIndex returns -1 it item is not found in the array
                       i=mapsAL.getItemIndex(item);
                       if (i==-1){
                       mapsAL.addItem(item);
                  }
        }

Re: Query.where Syntax

MayJeff — Fri, 17 Dec 2010 14:18:12 GMT

I try to get unique value on my query combo box. Without if statement there are no errors, but just got same value on the combo box.
(TypeError: Error #1006: getItemIndex is not a function.
at querycombo/private:init/onResult())

See code below:

             function onResult(featureSet:FeatureSet, token:Object = null):void
                {
                 var StArr:Array = [];
                 for each (var myGra:Graphic in featureSet.features)
                 {
                 //if (StArr.getItemIndex(myGra.attributes["township"].toString()) == -1 )
// {
StArr.push(myGra.attributes["township"].toString());
// }
                 }
                 StArr.sort();
                 StCb.dataProvider = StArr;
                }

Thank you.

Re: Query.where Syntax

WesBailes — Fri, 17 Dec 2010 15:07:32 GMT

I try to get unique value on my query combo box. Without if statement there are no errors, but just got same value on the combo box.
(TypeError: Error #1006: getItemIndex is not a function.
at querycombo/private:init/onResult())

See code below:

             function onResult(featureSet:FeatureSet, token:Object = null):void
                {
                 var StArr:Array = [];
                 for each (var myGra:Graphic in featureSet.features)
                 {
                 //if (StArr.getItemIndex(myGra.attributes["township"].toString()) == -1 )
// {
StArr.push(myGra.attributes["township"].toString());
// }
                 }
                 StArr.sort();
                 StCb.dataProvider = StArr;
                }

Thank you.

You are getting the error due to the fact that .getItemIndex is not a member of the Array Class. Use a ArrayList or ArrayCollection to store the values.