topic Re: Query (Return) All Points In Query Task and Query Object in ArcGIS JavaScript Maps SDK Questions

Query (Return) All Points In Query Task and Query Object

BehrouzHosseini — Sat, 11 Dec 2021 20:39:22 GMT

Using ArcGIS JavaScript API 3.21 I need to grab all Points on a Server. The code works for me with Query.where clause at

query.where = "FeederID = 'RMT001'";‍

but as I said I need to get all Points. I tried to run the query without any Query.where statement but not getting back anything. can you please let me know how to get all Points?

function execute () {
       var query = new Query();
       query.where = "FeederID  = 'RMT001'";
       query.returnGeometry = true;
       query.outFields = [ "CreationUser", "FName" ];
       queryTask.execute(query, showResults);
    } ‍‍‍‍‍‍‍

Re: Query (Return) All Points In Query Task and Query Object

RobertScheitlin__GISP — Wed, 27 Sep 2017 16:15:22 GMT

Bengi,

Just use:

query.where = "1=1";

Re: Query (Return) All Points In Query Task and Query Object

Mehretab — Sat, 11 Dec 2021 20:39:25 GMT

Is all except query expression (<>) valid in the JavaScript API. I couldn't get a result of the query.

query.where = "(NAMETEXT <> '"+valuefromcombo+"')"‍‍

I am aware it can work with successive OR statements like

query.where = "(NAMETEXT = '"+valuefromcombo+"') OR (NAMETEXT ='Havel')";
‍‍‍

query.where = "NAMETEXT in ('xxx', 'yyyy')";‍‍

Note:valuefromcombo is a user impute variable and it is text to be clear if in case there is an issue of (<>) expression with text values?

Re: Query (Return) All Points In Query Task and Query Object

RobertScheitlin__GISP — Tue, 31 Jul 2018 11:29:05 GMT

No <> is not valid SQL. You need to use NOT Instead.

Re: Query (Return) All Points In Query Task and Query Object

Mehretab — Tue, 31 Jul 2018 13:36:50 GMT

query.where = "(NAMETEXT NOT LIKE 'Havel')";‍

Worked perfectly. Thanks Robert!!!!