nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

TracySchloss

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!

Find more posts tagged with

Accepted answers

ChristopherBlinn1

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.

All comments

ChristopherBlinn1

Glad you found it!

TracySchloss

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

 queryTask.on('error', populateErrorHandler);

TracySchloss

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.

ChristopherBlinn1

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.

TracySchloss

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.

ChristopherBlinn1

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.