Arcade Data Expression- Related Table

TSmith

Hello,

 

I am relatively new to arcade, and attempting to figure out how to use a data expression to feed indicators/gauges based on an inspection date field in a related table. 

I currently have a pop-up within the map that uses this expression:

 

 

 var BlowoffHistory= FeatureSetByRelationshipName($feature,"Blowoff_Flushing_Inspection")var LatestDate = Max(BlowoffHistory,"flushingdate") var FormatDate = Date(LatestDate) return FormatDate 

 

my goal is to reference related data and check to see if the most recent inspection date occurred within the last year. If it did not, the feature should be passed through to an indicator widget, displaying the assets that are overdue for inspection. Any pointers/tips on how to accomplish this? 

 

 

jcarlson

So, the difference between the popup and the dashboard widgets is that the dashboard can potentially reference all features at once, whereas the popup is specific to a single feature.

There are a few ways you can do this, but it depends on what you want the output to look like. Do you want a list of just those features which are overdue? That might look like this:

// Set portal and layers

var portal = Portal('your portal URL');
var fs = FeatureSetByPortalItem(
    portal,
    'itemID of service',
    layer index, // Probably 0, but maybe different if you have multiple layers/tables in the service
    ['list', 'of', 'fields'],
    false
);

// Empty feature array and feat object to populate output
var features = [];
var feat;

// Set "one year ago" date
var year_ago = DateAdd(Now(), -1, 'years');

// Iterate over features in main layer
for (var f in fs){
    
    // Get related records
    var rel_fs = FeatureSetByRelationshipName(
        $feature,
        "Blowoff_Flushing_Inspection"
        ['flushingdate'],
        false
    );

    // Get most recent date from related records
    var latest = Max(rel_fs, 'flushingdate');

    // If latest date not within a year, add feature to output array
    if (latest < year_ago) {
        var feat = {
            attributes: {
                'some_id': f['id_field'],
                'last_inspection: latest
            }
        }
        
        Push(features, feat);
    };
    
// Create output dictionary
var outdict = {
    fields: [
        { name: 'some_id', type: 'esriFieldTypeString'},
        { name: 'last_inspection', type: 'esriFieldTypeDate'}
    ],
    geometryType: '',
    features: features
};

return FeatureSet(Text(outdict))

It's hard to say for certain if this is what you want, lacking more information about your dashboard and not having a live layer to test this against, but this should at least get you a list of overdue inspection features.

If you wanted to add a spatial component to this list, say, have the list items zoom to a location on a map, the expression would need to be altered, but not much.