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 issu

khadijaahal_el_fadl

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

Encontre mais publicações marcadas com

Accepted answers

kenbuja

Try this instead

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

All comments

kenbuja

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.

khadijaahal_el_fadl

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 🙂

kenbuja

Try this instead

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

khadijaahal_el_fadl

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

kenbuja

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

khadijaahal_el_fadl

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

khadijaahal_el_fadl

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

ReneRubalcava

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?

khadijaahal_el_fadl

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."
    ]
}
}"

ReneRubalcava

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.

khadijaahal_el_fadl

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

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

VinayBansal

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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