Latest Contributions by TracySchloss

Thanks for the update.  I keep trying to use FeatureTable and end up going back to using a plain dGrid.  I thought I might be able to manipulate the grid that the FeatureTable is based on, but it doesn't take long to be more trouble than it's worth.  Maybe in some future release.  ... View more

Has this been addressed in subsequent releases?  Some of the threads and the documentation for FeatureTable suggest we need to use a query on the underlying grid to filter the data.  It makes more sense to me to set a definitionExpression on the underlying FeatureLayer.  The variable filterValue is chosen from a filteringSelect.      updateTable: function (filterValue) {           app.testTable.setDefinitionExpression(("Dist_Code = '" + filterValue + "'"); } In this example, app.testTable is defined as app.testTable = new FeatureLayer (pathName+"/arcgis/rest/services/DHSS/EPHT_radonSchool/MapServer/2", {   id: "testTable",   outFields: ["*"]   }); I'm not sure if I need to also set the table to filterSelectedRecords(true).  I'm not getting any errors displayed, but I'm not seeing the results I expected either.  In my example, this featureLayer is just a table; it doesn't contain any graphic component to tie back to my map display.  ... View more

That's what I think I'm doing with domConstruct.empty('schoolSearchDiv'); I'm confused on whether or not I need to create a plain dom 'input' to use before I create my filteringSelect.   domConstruct.create("input", {id: 'schoolSelDiv' }, "schoolSearchDiv" ); var mySelect = new FilteringSelect({ id:'schoolSelect', placeHolder: 'Pick one', ignoreCase: true, queryExpr: '${0}*', maxHeight: 200, store: dataStore, searchAttr: 'label' }, "schoolSelDiv"); I hope to catch some error on what I'm calling the new dom elements I'm creating and which I'm telling it to destroy/empty.   I am seeing the original filteringselect get removed during domConstruct.empty.  It seems to be creating a new empty input DOM element, prior to the new FilteringSelect, but then I'm getting the widget register ID error.  Here's a link: Find District by School ... View more

Here's the identify code, 'myIdentify.js,  with the statisticdefinitions included.  In my case,  this is school year data, which spans calendar year.  The user wanted the 'startschoolyear' and 'endschoolyear' as separate fields. It didn't make sense to include any of the other statistics available, but I can see how they could easily be included. define([     "dojo/on",     "dojo/_base/array",     "dojo/_base/lang",     "dojo/Deferred",     "esri/InfoTemplate",     "esri/tasks/IdentifyTask",     "esri/tasks/IdentifyParameters",     "esri/tasks/query",     "esri/tasks/QueryTask",     "esri/tasks/StatisticDefinition",     "esri/geometry/Point",     "esri/geometry/Extent" ], function(     on, arrayUtils, lang, Deferred, InfoTemplate, IdentifyTask, IdentifyParameters, Query, QueryTask, StatisticDefinition, Point, Extent ) {     return {         runIdentify2: function(point, url) {             app.map.setInfoWindowOnClick(false);             var identifyTask = new IdentifyTask(url);             var identifyParams = new IdentifyParameters();             var def = new Deferred();             app.pt = point;             identifyParams.geometry = point;             identifyParams.layerOption = IdentifyParameters.LAYER_OPTION_ALL;             identifyParams.layerIds = [0];             var pxWidth = app.map.extent.getWidth() / app.map.width;             var padding = 100 * pxWidth;             var qGeom = new Extent({                 "xmin": point.x - padding,                 "ymin": point.y - padding,                 "xmax": point.x + padding,                 "ymax": point.y + padding,                 "spatialReference": app.spatialReference             });             identifyParams.geometry = point;             identifyParams.mapExtent = qGeom;             identifyParams.tolerance = 5;             identifyParams.returnGeometry = true;             identifyTask.execute(identifyParams, function(response){               var newFeats = [];               arrayUtils.map(response, lang.hitch(this, function(result, indx) {                 var feature = result.feature;                 var infoTemplate = new InfoTemplate("Test Results");                 createInfoContent(feature).then(lang.hitch(this, function(str){                   console.info(str);                   infoTemplate.setContent(str);                   feature.setInfoTemplate(infoTemplate);                   newFeats.push(feature);                   console.info(newFeats);                   console.info(response.length);                   if(indx === response.length - 1){                     console.info(newFeats);                     app.map.infoWindow.setFeatures(newFeats);                     app.map.infoWindow.show(point);                   }                 }));               }));             });             function createInfoContent(graphic) {                 var maindef = new Deferred();                 var formatString = "";                 var ctyDist = graphic.attributes.CtyDist;                 var locTest = graphic.attributes.Loc_Code;                 var id = graphic.attributes.SchID;                 formatString =                  "<b>" + graphic.attributes.Facility + "</b><br/>"                 + graphic.attributes.Address                 +  "<br/>" + graphic.attributes.City +  ", MO  " + graphic.attributes.ZIP;                        findSchRelatedRecords(id).then(lang.hitch(this, function(str){                   formatString += str;                   maindef.resolve(formatString);                 }));                 return maindef;             }             function findSchRelatedRecords(id) {                 var maindef = new Deferred();                 var relString = "";            var maxStartStatDef = new StatisticDefinition();    maxStartStatDef.statisticType = "max";   maxStartStatDef.onStatisticField = "SchoolYearStart";    maxStartStatDef.outStatisticFieldName = "latestSchoolYearStart";       var maxEndStatDef = new StatisticDefinition();       maxEndStatDef.statisticType = "max";   maxEndStatDef.onStatisticField = "SchoolYearEnd";    maxEndStatDef.outStatisticFieldName = "latestSchoolYearEnd";                         var schQuery = new Query();                 var queryTask = new QueryTask(app.testTable.url);                 var whereClause = "SchId = '" + id + "'";                 schQuery.where = whereClause;                 schQuery.returnGeometry = false;                 schQuery.outFields = ['*'];     schQuery.outStatistics = [ maxStartStatDef,maxEndStatDef];                     queryTask.execute(schQuery, lang.hitch(this, function(results) {                     var len = results.features.length;                     if (len === 0) {                         relString += "<br/>No test results found";                     } else {    var latestYearStart = results.features[0].attributes.latestSchoolYearStart;    var latestYearEnd =  results.features[0].attributes.latestSchoolYearEnd;    relString += "<br/>Last Year Tested: " + latestYearStart + " / " + latestYearEnd;                     }                     maindef.resolve(relString);                 }));                 return maindef;             }         }     }; }); ... View more

I had discovered the popup problem after lunch.  That was me deleting too many lines of code trying to get minimal lines of code to post as my sample.   The other was what I knew I needed to get to, without knowing how to get there.  Awesome! ... View more

At this stage I'd be happy if I could get any values out of my related table, whether through a 2nd query or a true relationshipquery.  It seems like I ought to be able to come back and add code to find the max year without having to scrap what I've done so far.  My identify is setting the content of the infotemplate up to a point, but my sequence is off for getting and adding the extra information from the table.  I'm only getting the values from the featurelayer, not the other table.  Here's what I have so far.  I can attempt to put it in jsbin or something if that makes it easier for someone.  Sample Radon Testing - School ... View more

I have a point layer of schools, and a related table of radon tests.  I only have one year's worth of test data so far, but the idea is that you could view all tests for a school over the years. What the user requested for the popup is the name of the school and the last year tested.  This sounds simple to them, but with the test results all in the related table, not only would you have to reach into the relationship, you'd also have to sort through the results of the year field to find the most recent.  Then you'd have to pass that to your popup content. They want to see all the results in a table, which could be in the footer.  I'm thinking this could be a featureTable filtered on the results of relationshipQuery?  Or maybe just filtered, period.  I'll know the school ID and I can limit the table to just those results, I think. At the moment, the related table isn't even set up with a relationship, since they didn't give me a unique ID to tie it together. I sent it back to see if they could do a little more data massage to add it.   Instead, I'm attempting to handle this through an identify. I'm still thinking through this.  This is called from a map click event: define ([     "dojo/on", "dojo/_base/array",     "dojo/_base/lang",     "dojo/Deferred",     "esri/tasks/IdentifyTask",     "esri/tasks/IdentifyParameters", "esri/tasks/query", "esri/tasks/QueryTask",     "esri/geometry/Point",     "esri/geometry/Extent"     ], function (       on, arrayUtils,lang,Deferred,IdentifyTask,IdentifyParameters, Query,QueryTask, Point,Extent     ) {      return {   runIdentify: function(map, url, point){    map.setInfoWindowOnClick(false);    var identifyTask = new IdentifyTask(url);    var idParams = new IdentifyParameters();    var def = new Deferred();    idParams.geometry = point;    idParams.layerOption = IdentifyParameters.LAYER_OPTION_ALL;    idParams.layerIds = [0];    var pxWidth = map.extent.getWidth() / map.width;    var padding = 100 * pxWidth;    var qGeom = new Extent({     "xmin": point.x - padding,     "ymin": point.y - padding,     "xmax": point.x + padding,     "ymax": point.y + padding,     "spatialReference": app.spatialReference    });    idParams.geometry = point;    idParams.mapExtent = qGeom;    idParams.tolerance = 5;    idParams.returnGeometry = true;    app.cityName = "";       identifyTask.execute(idParams).then(lang.hitch(this, function(results){     var fs = [];     if (results.length > 0) {      arrayUtils.forEach (results, function( result) {       var feature = result.feature;       var formatString = "";       var ctyDist = feature.attributes.CtyDist;       var locTest = feature.attributes.Loc_Code;       var nm = feature.attributes.Facility             formatString = "<b>" + feature.attributes.Facility + "</b><br/>" +       feature.attributes.Address +       "<br/>" +       feature.attributes.City +       ", MO  " +       feature.attributes.ZIP             var addedString = new Deferred();             addedString = findSchRelatedRecords(nm, ctyDist);             formatString += "<br/>" + addedString;       return feature;      });      app.map.infoWindow.setFeatures([def]);      app.map.infoWindow.show(point);          }     return def;        }));         function findSchRelatedRecords(nm, id){     var relString = " ";                 var schQuery = new Query;                 var queryTask = new QueryTask(app.testTable.url);                 var whereClause = "Facility = '" + nm + "' AND Dist_Code = '" + id + "'";                 schQuery.where = whereClause;                 schQuery.returnGeometry = false;                 schQuery.outFields = ['*'];                                 queryTask.execute(schQuery, lang.hitch(this, function(results){                                         var len = results.features.length;                     if (len === 0) {                         relString += "No test results found";                     }                     else {                         arrayUtils.forEach(results, function(r){                             relString += "Start Year: " + r.attributes.ScholYearStart;                         });                     }                                     }));                 return relString;             }   } } }); ... View more

So far so good.  I added the code to my extent change handler and the table now contains only the current map extent features.   What is controlling the text in the grid header?  It states the number of records and the number selected.  Limiting the table, the values in the header still reflect the original total number of features.  ... View more

You're describing exactly how I always populated my grid, but I'm not seeing that I can get that fine grained when I'm using a featureTable instead.  It's a lot more of a closed box in terms of determining what the store/memory is for it, and you don't set up any sort of query for it either.   It's more "Here's my featureLayer, how I want the table to display, and my div", and the object takes care getting its own store set up.  .  The table offered in Web App Builder I believe does let you tie the table to the extent.  That functionality hasn't made it's way into the JS API featureTable object, as far as I can tell.   ... View more

I'm glad that was enough of a suggestion to work with.  I finished the project I needed this for, leaving it as-is.  I'll have to dig back into that code and see if I can add this.  I didn't have just one layer that was important, I wanted the information from the layers to appear consistently, basically in the same order I had added them to the map.  The concept should still work, though, with modification to your code.  ... View more

I never got a resolution myself.  I didn't attempt this idea, but I wonder if there would be a way to capture the information before it was displayed, reorder the sequence and then display.   I'm not sure what events you'd even be listening for.  ... View more