topic Re: query.where issu in ArcGIS JavaScript Maps SDK Questions

query.where issu

khadijaahal_el_fadl — Tue, 14 May 2013 09:42:56 GMT

Hi , i try to query on more than one field, I want to have somthing like
"query.where= "field1='"+value1+"'" && "field2='"+value2+"'" ; but it doesn't work, it consider just the last field :it works as it was one only field wich is the last one. if you have Any idea please

Re: query.where issu

VinayBansal — Tue, 14 May 2013 11:18:49 GMT

Try putting "AND" instead of "&&" in where clause

Re: query.where issu

khadijaahal_el_fadl — Tue, 14 May 2013 12:23:23 GMT

Try putting "AND" instead of "&&" in where clause

thank you for replying , but I had already tried it and it doesn't work too.

Re: query.where issu

ReneRubalcava — Tue, 14 May 2013 12:31:26 GMT

Is that your exact query?
This query.where= "field1='"+value1+"'" && "field2='"+value2+"'" is a boolean expression, true or false.
Is this the exact code you are using?
It should be formed as query.where = "field1='" + value1 + "' AND field2='" + value2 + "'"
Try to test it via the Query REST page and see if it works as expected.

Re: query.where issu

khadijaahal_el_fadl — Tue, 14 May 2013 13:01:53 GMT

Is that your exact query?
This query.where= "field1='"+value1+"'" && "field2='"+value2+"'" is a boolean expression, true or false.
Is this the exact code you are using?
It should be formed as query.where = "field1='" + value1 + "' AND field2='" + value2 + "'"
Try to test it via the Query REST page and see if it works as expected.

Hi,thank you for replaying. I tested the query as you suggested in the REST page and I had an error:
"{
"error" :
{
    "code" : 400,
    "message" : "Unable to complete operation.",
    "details" : [
      "Unable to complete Query operation."
    ]
}
}"

Re: query.where issu

ReneRubalcava — Tue, 14 May 2013 13:12:22 GMT

I think if a field value is numeric, you can eliminate the single quotes, could be an issue. Tough to diagnose without looking at the data. How about if you do one query a time, without trying to combine them?

Re: query.where issu

khadijaahal_el_fadl — Tue, 14 May 2013 13:36:09 GMT

I think if a field value is numeric, you can eliminate the single quotes, could be an issue. Tough to diagnose without looking at the data. How about if you do one query a time, without trying to combine them?

I teied this on the rest page :
field1='value1' AND field2='value2'
and it works

Re: query.where issu

khadijaahal_el_fadl — Tue, 14 May 2013 14:42:30 GMT

the problem is that when I use the "AND" in JS code , it's not recognized. Have you any idea about that?

Re: query.where issu

KenBuja — Tue, 14 May 2013 15:19:06 GMT

Can you post what isn't working in your code?

Re: query.where issu

khadijaahal_el_fadl — Tue, 14 May 2013 15:24:49 GMT

Can you post what isn't working in your code?

"
var val1=this.widgets.textSearch.getValue();
var val2=this.widgets.exp.getValue();
if( val1&&val2){q.where="p_from='"+val1+"'" &&"p_to='"+val2+"'";} "

I've tried to replace "&&" withe "AND" but still not working

Re: query.where issu

KenBuja — Tue, 14 May 2013 16:11:09 GMT

Try this instead

if( val1&&val2){q.where="p_from='"+val1+"' AND p_to='"+val2+"'";}

Re: query.where issu

khadijaahal_el_fadl — Tue, 14 May 2013 17:31:25 GMT

Try this instead

if( val1&&val2){q.where="p_from='"+val1+"' AND p_to='"+val2+"'";}

thank you so much ,It works finally thanks to you 🙂

Re: query.where issu

KenBuja — Tue, 14 May 2013 17:52:39 GMT

Gald to help. When you run into problems like this, you should use the debugger to see how the where clause is interpreted by the code.

Don't forget to click the check mark on the post that best answered your question.