topic Re: SQL syntax for query.where. in ArcGIS JavaScript Maps SDK Questions

SQL syntax for query.where.

ZachLiu1 — Tue, 13 Aug 2013 20:01:41 GMT

I am trying to build a query form on my application, but I met problems building SQL statements.
Anyone knows where to find accurate SQL syntax for query.where?

e.g. This statement does not work.

query.where = "damname = '" + $("input[name='damname']").val() + "'" + " OR " + "HAZCLASS = " + $("input[name='HAZCLASS']").val() + "";

Re: SQL syntax for query.where.

DerekMaune — Tue, 13 Aug 2013 20:57:43 GMT

You don't have quotes around your second value. It sounds like you're having more than one problem with the syntax though. Can you provide more detail? Is it throwing an error or just returning an empty dataset?

Re: SQL syntax for query.where.

ZachLiu1 — Tue, 13 Aug 2013 21:35:45 GMT

The second value is a number so i didn't quote it. Both statements work fine, but I can't join them with a "OR".

Re: SQL syntax for query.where.

VinayBansal — Wed, 14 Aug 2013 02:56:14 GMT

There is no need to add string in query at last. This should work

query.where = "damname = '" + $("input[name='damname']").val() + "'" + " OR " + "HAZCLASS = " + $("input[name='HAZCLASS']").val();

Also, get the values that are coming during debugging in query.where and put that values in your ArcGIS Rest interface to test if it works there.

Re: SQL syntax for query.where.

ZachLiu1 — Wed, 14 Aug 2013 12:16:07 GMT

If I do this and the HAZCLASS input is empty, it will report query failure.

I am using this so far. Don't know if there's a simple way.

query.where = "damname = '" + $("input[name='damname']").val() + "'" + " or " + "HAZCLASS=" + ($("input[name='HAZCLASS']").val()? $("input[name='HAZCLASS']").val(): "'null'");

Re: SQL syntax for query.where.

JanJeske — Sat, 11 Dec 2021 20:14:51 GMT

Hey try this if u need to query for NULL val try this:
In the where clause its simple sql 😉

var val1= $("input[name='damname']").val();
var val2= $("input[name='HAZCLASS']").val();
query.where = "damname = '" + val1+ "' or HAZCLASS " + ((val2 != "")?" = "+val2:" IS NULL");

if there is no need try this:

var val1= $("input[name='damname']").val();
var val2= $("input[name='HAZCLASS']").val();
query.where = "damname = '" + val1+ "' " + ((val2 != "")?"HAZCLASS  = "+val2:"");

Re: SQL syntax for query.where.

JasonZou — Thu, 15 Aug 2013 14:02:31 GMT

Try:

var damValue = $.trim($("input[name='damname']").val()); var hazValue = $.trim($("input[name='HAZCLASS']").val());  var damExpr = "damname = '" + damValue + "'"; var hazExpr = hazValue ? "HAZCLASS = " + hazValue : ""; query.where = damExpr + hazExpr ? " OR " + hazExpr : "";

Re: SQL syntax for query.where.

ZachLiu1 — Thu, 15 Aug 2013 17:00:18 GMT

Thanks Jason, I made a little change of your code and it works perfect for the purpose.

query.where = damExpr + (hazExpr ? " OR " + hazExpr : "");

Also, thanks Jan:)