topic Re: Format for Queries Connected with AND/OR in ArcGIS JavaScript Maps SDK Questions

Format for Queries Connected with AND/OR

ChrisFarver — Thu, 19 May 2011 21:40:28 GMT

Hi,

I'm having a bit of trouble trying to find the correct format for connecting two queries together with AND. I feel I've tried so many different combinations, but haven't found a way that works.

What I'm trying to code is a query that searches through a list of houses/apartments by a specified range. At first I was using
query.where = "3_bedrooms <= " + rent;

But found that it would return a lot of properties, as many were initialized to having a rent of 0.

So I tried combining statements along the lines of
query.where = "3_bedrooms > " + 0 + "AND 3_bedrooms <= " + rent;

And many other variations of this line, but nothing seems to work. Been searching online for the correct format, but haven't found anything yet. Can anyone help me out?

Thanks

Re: Format for Queries Connected with AND/OR

derekswingley1 — Thu, 19 May 2011 22:21:05 GMT

I find the best place to test these things out is at your REST endpoint. You can play around with different syntax to see what actually works and then drop that in your app.

One thing about the where clause you posted:

query.where = "3_bedrooms > " + 0 + "AND 3_bedrooms <= " + rent;

I think you need another space before your AND:

query.where = "3_bedrooms > " + 0 + " AND 3_bedrooms <= " + rent;

Edit: just to confirm, the datatype of the 3_bedrooms field is not a string, right?

Re: Format for Queries Connected with AND/OR

ChrisFarver — Thu, 19 May 2011 22:35:32 GMT

Correct, the datatype for 3_bedrooms is an integer.

Correction: Got it to work. Thanks for the help

Re: Format for Queries Connected with AND/OR

derekswingley1 — Thu, 19 May 2011 23:45:52 GMT

Check out the where clause and the results here: http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/Petroleum/KSWells/MapServer/0/query?&where=SECTION+%3E+0+and+SECTION+%3C%3D+2&returnGeometry=false&outFields=section&f=html

The where clause being used is: SECTION > 0 and SECTION <= 2

Re: Format for Queries Connected with AND/OR

derekswingley1 — Fri, 20 May 2011 00:43:50 GMT

Glad to help. Care to elaborate on what fixed it for you?

Re: Format for Queries Connected with AND/OR

ChrisFarver — Sat, 04 Jun 2011 23:52:53 GMT

Ah sorry I didn't see the other response.

I think it was just the proper placement of the quotation marks, but especially that extra space that you pointed out really did it. Now it's working like a charm.

Thanks again.