topic Re: Query Syntax in ArcGIS API for Silverlight Questions

Query Syntax

JayKappy — Fri, 22 Apr 2011 12:25:02 GMT

I know this might not be ArcGIS API question and rather more a general programming question but I have been all over silverlight forums and keep getting references to LINQ query structure...

Where Equal to is represented with ==
Greater than equal to with >=
etc

But this is more in the body of the ESRI.ArcGIS.Client.Tasks.Query and they dont seem to work...
PrecinctValue2 is a variable set to result of another query...its set to a specific attribute value from that found record...there will be only 1 record returned..

This works:
query.Where = String.Format("ELEM_TEXT LIKE '%{0}%'", PrecinctValue2.Trim)

But I need EQUAL to the value in the string....I have been trying == instead of the LIKE..
This DOES NOT work...Any quick thoughts?

query.Where = String.Format("ELEM_TEXT == '%{0}%'", PrecinctValue2.Trim)

Any quick thoughts....no worries either way....just thought I would give this a try....

Re: Query Syntax

TerryGiles — Sat, 11 Dec 2021 10:43:20 GMT

Jay,

Just use a single equal sign in the where clause.

query.Where = "ELEM_TEXT = '" + PrecinctValue2.Trim + "'";

note that are there are single quote marks around precinctvalue2 since this is a string field. Numeric (and date types I believe) do not need these.

TG

Re: Query Syntax

JayKappy — Fri, 22 Apr 2011 15:59:44 GMT

Thank you terry....very apprecited...sort fo feel stupid....so much more simple syntax than teh example I as using....

Can I assume that you can simply use >=, <=, >, < symbology as well to create Greater Than Equal to, Less THan Equal to, Greater THan, Less Than...making sure the variable is numeric...

THanks Again...very appreciated

Re: Query Syntax

TerryGiles — Fri, 22 Apr 2011 16:19:36 GMT

yep just use >=, <, etc.. in the string you set for the Where property. Depending on the underlying data source you can also use

between <number> and <number> or between '<date>' and '<date>'. Dates are enclosed in single quote marks like a string.

Terry

Re: Query Syntax

JayKappy — Fri, 22 Apr 2011 19:19:14 GMT

THanks again...have a great weekend....