topic query.where clause using variable for field name instead of hard coded in ArcGIS JavaScript Maps SDK Questions

query.where clause using variable for field name instead of hard coded

TracySchloss — Fri, 11 Oct 2013 18:14:55 GMT

I'm sure if it wasn't Friday afternoon, I'd figure this out on my own.

I am trying to set up a more generic function to construct and execute a query task. Instead of having my query.where clause be something like

selQuery.where = "DISTRICT= '" + myCode + "'";  //myCode coming from a FilteringSelect value

I'd like the field name to also be a variable. But I think the syntax for the where clause needs to be in the form of "FIELDNAME" = 'myValue', and I'm not quite sure how to get the quotes properly formatted in the string.

Please someone who's brain is still functioning, help me out!

Re: query.where clause using variable for field name instead of hard coded

ChristopherBlinn1 — Fri, 11 Oct 2013 18:30:10 GMT

Tracy,

Just make sure your field variable is a string. There where property is type string..

var myField = "DISTRICT"; . . . selQuery.where = myField + " = '" + myCode + "'"

I actually build the entire where statement in a string variable in most of my applications, then set .where to the variable.

Hope this helps and Happy Friday,
Chris B.

Re: query.where clause using variable for field name instead of hard coded

TracySchloss — Fri, 11 Oct 2013 19:03:22 GMT

I tried that first, before I sent this and it wasn't working. I've changed several places in this function to use variables instead, maybe I should be expand to other lines. This might not be the problem at all!

Like I said - Friday - brain dead.

Re: query.where clause using variable for field name instead of hard coded

ChristopherBlinn1 — Fri, 11 Oct 2013 19:21:40 GMT

If you would like to post your entire function, I'd gladly take a look at it.

Or if your application is publicly accessible I can look from there.

Re: query.where clause using variable for field name instead of hard coded

TracySchloss — Fri, 11 Oct 2013 20:04:23 GMT

Thanks for the offer. I have a feeling it's something right in front of me, so I'm going to try a little longer. No sense in embarrassing myself.

Re: query.where clause using variable for field name instead of hard coded

TracySchloss — Fri, 11 Oct 2013 20:10:26 GMT

Sure enough, I had renamed my errorHandler function, but forgot to change the queryTask.on event listener

 queryTask.on('error', populateErrorHandler);

Re: query.where clause using variable for field name instead of hard coded

ChristopherBlinn1 — Fri, 11 Oct 2013 20:13:57 GMT

Glad you found it!