Arcade Expression throws Data Error / null
Hi Matt Creaney ,
In that case, it does not make sense to start with the assets and find the bays and use the first bay to find the assets. Or does it?
Have a look at the code below and an example result to see if it comes anywhere near what you are looking for.
Using the following expression:
var Buffer_Distance = 100;
var dateFormat = "MM/DD/Y";
var result = "";
//Get Date of Commission
var DateOfCommission = Text($feature.CreationDate, dateFormat);
Console(DateOfCommission);
var Asset_buffer = Buffer($feature, Buffer_Distance, 'meters');
Console("Asset Area is " + Area(Asset_buffer, "square-meters"));
// Find Vehicles that intersect Asset Buffer
var VehicleIntersecting = Intersects(FeatureSetById($map, /* Vehicle Locations */ "Vehicle_Locations_8121", ["date_visited", "visit_duration"], false), Asset_buffer);
var IntersectCount = Count(VehicleIntersecting);
Console("Intersect Count = " + IntersectCount);
// If an intersecting vehicle record is found
var cnt = 0;
result = "Date of Commission: " + DateOfCommission + TextFormatting.NewLine;
if (IntersectCount > 0) {
for (var VehicleStop in VehicleIntersecting) {
//Get Date of Visit
var DateOfVisit = Text(VehicleStop["date_visited"], dateFormat);
Console("Date of Visit = " + DateOfVisit);
Console("Date of Commission = " + DateOfCommission);
// Set result as Visit Duration if Dates of Visit and Commission Match
if (DateOfVisit == DateOfCommission) {
result += " - Duration: " + VehicleStop["visit_duration"] + "h" + TextFormatting.NewLine;
} else {
// switch this off, since you are not interesting in this
cnt += 1;
//result += " - Duration: (" + DateOfVisit + ") = " + VehicleStop["visit_duration"] + "h" + TextFormatting.NewLine;
Console("other date: " + VehicleStop["visit_duration"]);
}
}
if (cnt > 0) {
result += " - " + cnt + " vehicle stops found at different dates..." ;
}
} else {
// handle: no interecting vehicles found
result = "No Intersecting Vehicle Records Found with the same date";
}
return result;Hi Xander Bakker
The expression I wrote is in the Product Commission ITP layer - I am testing through a web mapping application I've just added to the group. In other maps I have using the same database I have many many scripts that successfully execute although none of these access related tables. The popups are accessed through the relate table links.
In this application the expression is supposed to appear under the asset name..
Hi Matt Creaney ,
As far as I have seen you only shared a map with me and the layers. The map has two point feature layers:
- Product database
- Vehicle locations
And the map also has a list of tables. When I click on a feature of the product database not all tables are presented and related tables. Especially the table Product Commission ITP does not appear as related table in the map (no sure of this is because the list is too long).
In order to see how you workflow works, I would need access to the App that you showed. I still believe that it might be more effective to use the Arcade expression to extract all the necessary information and present it in the pop-up, although this depend how the application is configured.
