Related Record Attributes in Pop-up Display with Arcade Expression

RyanElvrum2

My goal is to create a pop-up expression using Arcade to show attribute values from a filtered related table two-relationships deep.

My data is related as follows;

Service Location (Point feature) --> Service Account (Table) --> Meters (Table)

I am able to create an pop-up expression for the Service Location that returns attributes from the related Service Account table, but I would like to go one level deeper and also return attributes from the related Meter table.

Currently my Arcade expression is;

var ServiceLocationGID = $feature.GlobalID
var ServiceAccounts = FeatureSetByName($map,"Service Account - Electric")
var filterstatement = 'ServiceLocationGID = @ServiceLocationGID'

var relatedData = Filter(ServiceAccounts, filterstatement)

var popupString = ''
for ( var f in relatedData){

popupString += "First Name: " + Text(Proper(f.firstname)) + TextFormatting.Newline
+ "Last Name: " + Proper(f.lastname) + TextFormatting.Newline
+ "Service Address 1: " + Proper(f.serviceaddr1) + TextFormatting.Newline
+ "Service Address 2: " + Proper(f.serviceaddr2) + TextFormatting.Newline
+ "Account Number: " + f.AccountNumber + TextFormatting.Newline + TextFormatting.Newline
}
return popupString

 

I am unsure on how to format the expression to then filter the meter table and return attribute values from the related record to include in my pop-up string.

XanderBakker

Hi @RyanElvrum2 ,

 

Do you have multiple meters for a single service account? If so, you will only get a single meter in the pop-up string. Also, the meter number does not need to be cast to string since this will always be a string when cascading a text with other information. 

Try this: 

var ServiceLocationGID = $feature.GlobalID;
var SqlServiceAccounts = "ServiceLocationGID = @ServiceLocationGID";

var ServiceAccounts = FeatureSetByName($map, "ServiceAccounts");
var RelatedServiceAccounts = Filter(ServiceAccounts, SqlServiceAccounts);

var Meters = FeatureSetByName($map, "Meters");
var popupstring = "";
for (var ServiceAccount in RelatedServiceAccounts){
    
    popupstring += "First Name:  " + Text(Proper(ServiceAccount.firstname)) + TextFormatting.Newline;
    popupstring += "Last Name:  " + Proper(ServiceAccount.lastname) + TextFormatting.Newline;
    popupstring += "Service Address 1:  " + Proper(ServiceAccount.serviceaddr1) + TextFormatting.Newline;
    popupstring += "Service Address 2:  " + Proper(ServiceAccount.serviceaddr2) + TextFormatting.Newline;
    popupstring += "Account Number: " + ServiceAccount.AccountNumber + TextFormatting.Newline;
    
    var ServiceAccountGID = ServiceAccount.GlobalID;
    var SqlMeters = "ServiceAccountGID = @ServiceAccountGID";
    
    var RelatedMeters = Filter(Meters, SqlMeters);
    for (var Meter in RelatedMeters) {
        popupstring += " - Meter Number: " + Meter.MeterID + TextFormatting.Newline;
    }
    popupstring += TextFormatting.Newline;
}

Return popupstring;