topic Re: Cannot get queryTask with query to return expected result in ArcGIS JavaScript Maps SDK Questions

Cannot get queryTask with query to return expected result

MichelleRogers1 — Fri, 10 Dec 2021 21:56:19 GMT

I am working with an existing website that I did most of the code on. It is a Emergency Operations Center website with automatic vehicle tracking as well as history queries. I was able to query the history for the vehicles with no problem, but I am now trying to query the history of the 911 calls and am coming across some issues. Any help is greatly appreciated!

Here is the code I am working with:

window.Calls911HistoricalUrl = "http://gis10204:6080/arcgis/rest/services/GeoEvent/AVL_911_Historical_WebOut/FeatureServer/0";
window.Calls911HistoricalOutFields = ["PhoneNumber", "CallType", "TimeStamp"];

registry.byId("execute911bynumber").on("click", execute911bynumber);
  function execute911bynumber(){
  var queryTask = new QueryTask(window.Calls911HistoricalUrl);
  var query = new Query();
  query.returnGeometry = false;
  query.outFields = window.Calls911HistoricalOutFields;
  query.where = "PhoneNumber = " +"'"+number+"'";
  queryTask.execute(query, function(results) {
  var data = [];
  var data = array.map(results.features, function(feature) {
  return {
  //property names used here match those used when creating the dgrid                  
  "Phonenumber": feature.attributes[window.Calls911HistoricalOutFields[0]],                  
  "Calltype": feature.attributes[window.Calls911HistoricalOutFields[1]],
  "Timereceived": feature.attributes[window.Calls911HistoricalOutFields[2]]
  }
  });
  var memStore = new Memory({ data: data });
  //create historical data dgrid
  window.grid2 = new (declare([OnDemandGrid, Selection]))({
  bufferRows: Infinity,
  store:memStore,
  maxRowsPerPage: 5000,
  columns: {         
  "Phonenumber": "Phone Number",
  "Calltype": "Call Type",
  "Timereceived": {"label": "Time Received", "formatter": formatTimestamp}
  },
  loadingMessage: "Loading data...",
  noDataMessage: "No records found."
  }, "grid2");
  grid2.set("sort", [{attribute:"Timereceived", descending:true}]);
  });
  grid2.setStore();
  }

The html code is as follows:

<div data-dojo-type="dijit/layout/ContentPane" id="911historyPane"
  data-dojo-props="title:'911 History'" style="background-color:#bee8ff;">
  <div>
  Phone Number: <input type="text" id="number" size="20">
  </div>
  <div>
  Start Date & Time: <input id="911date" type="text" size="20"><a href="javascript:NewCal('911date', 'mmddyyyy')"><img src="images/cal.gif" width="18" height="18" border="0"></a>
  </div>
  <div>
  End Date & Time: <input id="911date2" type="text" size="20"><a href="javascript:NewCal('911date2', 'mmddyyyy')"><img src="images/cal.gif" width="18" height="18" border="0"></a>
  </div>
  <div>
  <button id ="execute911bydate" data-dojo-type="dijit.form.Button" type="button" data-dojo-attach-point="button" title="Search By Date">Search By Date
  </button>
  <button id ="show911" data-dojo-type="dijit.form.Button" type="button" data-dojo-attach-point="button" title="Show on Map" >Show on Map
  </button>
  <button id ="clear911" data-dojo-type="dijit.form.Button" type="button" data-dojo-attach-point="button" title="Clear" >Clear History
  </button>
  </div>
  <div>
  <button id="execute911bynumber" data-dojo-type="dijit.form.Button" type="button" data-dojo-attach-point="button" title="Search By Number"> Search By Number
  </button>
  <button dojotype="dijit.form.Button" id="911historyHelp" title="Help">
  <img src="images/Help.png" width=15px height=15px/>
  </button>
  </div>
  <div id="grid2" class="claro"></div>
  </div>

I was able to search on date alone and come up with the correct information, but when I try and search on phone number alone, I am getting no results even though I know that there are at least 5 calls for that phone number. I have also tried using query.text = dom.byId("number").value; but using that throws an error, "unable to complete operation". Again, any help figuring this out is greatly appreciated.

Michelle

Re: Cannot get queryTask with query to return expected result

RobertScheitlin__GISP — Wed, 14 Jan 2015 17:51:29 GMT

Michelle,

What is the field type of your PhoneNumber? If it is a number and not a text then your SQL should not wrap the number in quotes like you do for text.

Re: Cannot get queryTask with query to return expected result

MichelleRogers1 — Wed, 14 Jan 2015 17:54:40 GMT

Robert,

The field type for PhoneNumber is a string because it has the dashes included, not just the numbers.

Re: Cannot get queryTask with query to return expected result

RobertScheitlin__GISP — Wed, 14 Jan 2015 17:59:12 GMT

Have you done a

console.info(query.where);

to see what the where clause looks like?

Re: Cannot get queryTask with query to return expected result

JoelBennett — Wed, 14 Jan 2015 18:55:43 GMT

The only problem I see here is in the line:

query.where = "PhoneNumber = " +"'"+number+"'";

The problem is that I don't see where the variable "number" is declared or assigned a value. Unless you've declared and assigned the value elsewhere, this could be the main issue. Perhaps the following might make a difference:

query.where = "PhoneNumber = '" + dom.byId("number").value + "'";

Re: Cannot get queryTask with query to return expected result

MichelleRogers1 — Wed, 14 Jan 2015 18:58:00 GMT

Robert,

This is what the console log shows when I do a console.info(query.where);

PhoneNumber ='[object HTMLInputElement]'

I don't see anything wrong with it, but the response that I get is this:

{"objectIdFieldName":"OBJECTID","globalIdFieldName":"","features":[]}

So, it is returning an empty set for some reason, even though the query is correct and when I do the query from the rest endpoint, I get 5 records like I am expecting.

Re: Cannot get queryTask with query to return expected result

RobertScheitlin__GISP — Wed, 14 Jan 2015 19:05:57 GMT

Michelle,

PhoneNumber ='[object HTMLInputElement]' is not a valid SQL Statement. Like Joel posted above try

query.where = "PhoneNumber = '" + dom.byId("number").value + "'";

Re: Cannot get queryTask with query to return expected result

MichelleRogers1 — Wed, 14 Jan 2015 19:06:07 GMT

Joel,

That got it! The only thing I changed was adding in a single quote in front of the value. The correct code looks like this:

query.where = "PhoneNumber="+"'"+dom.byId("number").value+"'";