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;
}
}
}
});
