topic Re: Why Won't My Query Count the Related Features? in ArcGIS JavaScript Maps SDK Questions

Why Won't My Query Count the Related Features?

ChrisSergent — Sun, 12 Dec 2021 01:50:44 GMT

I am trying to count the related features when the user clicks on a feature, but my query won't run. An example of what I am trying to do in our REST Service directory is the following:

The Where Statement: SUPPORTID='691'

The URL to run the where statement: Layer: Sign (ID: 0)

I have also published app at: maps.decaturil.gov/streetSigns/

And the latest version is on github at: csergent45/streetSigns at 297fa633f0ebb529862e35b7019c04d7259fbfe8 · GitHub

In my code, I have entered the following for the code block to run the query and to display a count in the console, but it's not working:

// url the query task is to be performed on
            var queryTask = new QueryTask(config.signLayerUrl);
            var query = esriQuery();


            // count related records
            esriQuery.where = "SUPPORTID =='" + supportId + "'";
            // display number of related records in console
            queryTask.executeForCount(query,function(count){
                console.log(count);
            })

The supportId is the support ID of the feature that was clicked on.

The config.signLayerUrl is the URL that I am querying.

Why doesn't this work? I referenced the API at: https://developers.arcgis.com/javascript/jsapi/querytask-amd.html#executeforcount

Re: Why Won't My Query Count the Related Features?

RobertScheitlin__GISP — Wed, 10 Jun 2015 16:36:37 GMT

Chris,

your SQL sntax should not have equal equal.

esriQuery.where = "SUPPORTID = '" + supportId + "'";

Re: Why Won't My Query Count the Related Features?

ChrisSergent — Wed, 10 Jun 2015 16:41:39 GMT

I updated my code to that, but I still receive the following: {"error":{"code":400,"message":"Unable to complete operation.","details":[]}}

Re: Why Won't My Query Count the Related Features?

RobertScheitlin__GISP — Wed, 10 Jun 2015 16:54:11 GMT

What type of field is SUPPORTID? If it is a numeric field then your SQL Syntax should look like this instead:

esriQuery.where = "SUPPORTID = " + supportId;

Re: Why Won't My Query Count the Related Features?

ChrisSergent — Wed, 10 Jun 2015 16:59:09 GMT

It's an esriInteger, but does not appear to populate the where statement:

f:json
returnIdsOnly:true
returnCountOnly:true
where:
returnGeometry:false
spatialRel:esriSpatialRelIntersects

I got this from the network tab.

Re: Why Won't My Query Count the Related Features?

thejuskambi — Wed, 10 Jun 2015 17:07:21 GMT

you have made a typo error it is not esriQuery.where = "SUPPORTID =='" + supportId + "'"; it should be query.where....

Re: Why Won't My Query Count the Related Features?

RobertScheitlin__GISP — Wed, 10 Jun 2015 17:09:20 GMT

Thanks

thejus I was focusing on the SQL statement and missed that.

Re: Why Won't My Query Count the Related Features?

thejuskambi — Wed, 10 Jun 2015 17:11:50 GMT

also you may want to use query = new esriQuery();

Re: Why Won't My Query Count the Related Features?

ChrisSergent — Wed, 10 Jun 2015 18:29:47 GMT

That did it. Thanks.

Re: Why Won't My Query Count the Related Features?

ChrisSergent — Wed, 10 Jun 2015 18:30:15 GMT

I updated that as well.