nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update field in Parent layer IF related layer record is given specific field value

JamesBooth

I'm struggling to get this attribute rule working.

My Setup:
Parent Layer: WNV_StagnantWaterSites (point feature class)
Related Layer: WNV_SiteVisits (point feature class)
Relationship: 1:M (SiteCode as Primary & Foreign Key, short numeric)
Notification: Both directions
Record Count: 628 parent records, 50,000+ related records
Relationship Class: WNV_StagnantWaterSites_TO_WNV_SiteVisits
Goal:
I need to update the SiteRisk field (text: "Other", "Low", "Moderate", "High") in WNV_StagnantWaterSites based on related WNV_SiteVisits records where LarvacideRequest = 1 (Yes) in the last 12 months (SiteVisitDate field).

Logic:
0 records → SiteRisk = Low
1 record → SiteRisk = Moderate
2+ records → SiteRisk = High
Downgrades:
High → Moderate if no Yes records in 12 months
Moderate → Low if no Yes records in 12 months
Issue:
My attribute rule validates and saves, but SiteRisk does not update, no matter how I modify WNV_SiteVisits. Any help from an Attribute Rule Guru would be greatly appreciated! 🙏

// Relationship class name
var relationshipName = "WNV_StagnantWaterSites_TO_WNV_SiteVisits";

// Define the cutoff date for the last 12 months
var today = Now();
var twelveMonthsAgo = DateAdd(today, -12, "months");

// Fetch related site visit records (Child Features)
var relatedVisits = FeatureSetByRelationshipName($feature, relationshipName, ["LarvacideRequest", "SiteVisitDate"], false);

// Debugging: Log how many related visits were found
Console("<span class="lia-unicode-emoji" title=":magnifying_glass_tilted_left:">🔍</span> Found " + Count(relatedVisits) + " related site visit records.");

// Filter visits where LarvacideRequest = 1 (Yes) AND occurred in the past 12 months
var recentLarvacideVisits = Filter(relatedVisits, "LarvacideRequest = 1 AND SiteVisitDate >= @twelveMonthsAgo");

// Count qualifying visits
var visitCount = Count(recentLarvacideVisits);

// Debugging: Log how many visits met the criteria
Console(":calendar:</img> " + visitCount + " site visits in the past 12 months had LarvacideRequest = 1.");

// Determine new SiteRisk value based on visit count
var newSiteRisk = "";
if (visitCount == 0) {
    newSiteRisk = "Low";
} else if (visitCount == 1) {
    newSiteRisk = "Moderate";
} else if (visitCount >= 2) {
    newSiteRisk = "High";
}

// Fetch the parent feature (WNV_StagnantWaterSites)
var parentFeatures = FeatureSetByRelationshipName($feature, relationshipName, ["SiteRisk"], true);

// Ensure we have at least one parent
if (Count(parentFeatures) > 0) {
    var parent = First(parentFeatures);

    // Get the existing SiteRisk value
    var currentRisk = parent.SiteRisk;

    // Debugging: Log the existing SiteRisk before updating
    Console("<span class="lia-unicode-emoji" title=":counterclockwise_arrows_button:">🔄</span> Current SiteRisk: " + currentRisk);

    // Only update if the risk level actually changes
    if (currentRisk != newSiteRisk) {
        Console("<span class="lia-unicode-emoji" title=":white_heavy_check_mark:">✅</span> Updating SiteRisk from " + currentRisk + " to " + newSiteRisk);
        
        return {
            "edit": [
                {
                    "className": "WNV_StagnantWaterSites",
                    "updates": [
                        {
                            "objectID": parent.OBJECTID,
                            "attributes": {
                                "SiteRisk": newSiteRisk
                            }
                        }
                    ]
                }
            ]
        };
    } else {
        Console(":warning:</img> No update needed. SiteRisk remains: " + currentRisk);
    }
} else {
    Console("<span class="lia-unicode-emoji" title=":cross_mark:">❌</span> No parent found for this site visit.");
}

// No update needed
return null;

Finde mehr Beiträge mit dem Tag

Accepted answers

Jake_S

@JamesBooth well I love to be proven wrong, even by me.

// Relationship class name
var relationshipName = "WNV_StagnantWaterSites_TO_WNV_SiteVisits";
var parentGlobalID;
var newSiteRisk = "";

// Define the cutoff date for the last 12 months
var today = Now();
var twelveMonthsAgo = DateAdd(today, -12, "months");

// Fetch related parent record (WNV_StagnantWaterSites)
var relatedParent = FeatureSetByRelationshipName($feature, "WNV_StagnantWaterSites_TO_WNV_SiteVisits", ["GlobalID"], false);

for (var parent in relatedParent) {
    parentGlobalID = parent.GlobalID;
    // Fetch related site visit records (Child Features)
    var relatedVisits = FeatureSetByRelationshipName(parent, "WNV_StagnantWaterSites_TO_WNV_SiteVisits", ["GlobalID","LarvacideRequest","SiteVisitDate"], false);

    // Debugging: Log how many related visits were found
    Console(" Found " + Count(relatedVisits) + " related site visit records.");

    // Filter visits where LarvacideRequest = 1 (Yes) AND occurred in the past 12 months
    var recentLarvacideVisits = Filter(relatedVisits, "LarvacideRequest = 1 AND SiteVisitDate >= @twelveMonthsAgo");

    // Count qualifying visits
    var visitCount = Count(recentLarvacideVisits);

    // Debugging: Log how many visits met the criteria
    Console(":calendar: " + visitCount + " site visits in the past 12 months had LarvacideRequest = 1.");

    // Determine new SiteRisk value based on visit count
    if (visitCount == 0) {
        newSiteRisk = "Low";
    } else if (visitCount == 1) {
        newSiteRisk = "Moderate";
    } else if (visitCount >= 2) {
        newSiteRisk = "High";
    }
}

return {
    'edit': [{
        'className': 'WNV_StagnantWaterSites',
        'updates': [{
            'globalID': parentGlobalID,
            'attributes': {
                "SiteRisk": newSiteRisk
            }
        }]
    }]
}

Try this applied to your in place of your original on the WNV_SiteVisits.

All comments

Jake_S

Hey James,

Couple things. In your return you are using the parent.OBJECTID (line 56), I would use a globalId. you can get this from your relationship class.

Also, I would just return, not return null (line 73). A simple return ends the expression evaluation, a return null, is trying to populate an objects field value with null.

Start there, and let us know what happens.

~Jake

Jake_S

Line 13 is not doing what you think it is. FeatureSetByRelationshipName returns the related records for a given $feature, your parents that are return for that specific $feature.

If I'm assuming correctly you are trying to collect all the WNV_SiteVisits for each, filtered, for your WNV_StagnantWaterSites and then update.

If correct, you would either need this on your WNV_StagnantWaterSites with some sort of trigger or as a batch calculation.

Because this is a M:N relationship if applied to the WNV_SiteVisits you would have to go get all your WNV_StagnantWaterSitesparents that are related to that one $feature (FeatureSetByRelationshipName).

var parentGlobalList = []

var parentFeatures = FeatureSetByRelationshipName($feature, relationshipName, ["GLOBALID"], true);

for (var parent in parentFeatures){
    Push(parentGlobalList, parent.GLOBALID)
}

Once you have those WNV_StagnantWaterSites.GlobalIDs you would have to find a way to get back to the WNV_SiteVisits and get the related visits for each WNV_StagnantWaterSites GlobalID. Currently I do not believe there is a way to go backwards in a relationship. I'd love to be wrong and I hope the greater community can correct me.

If you can..... use that list to iterate over each globalid in the list to get all the related WNV_SiteVisits. Then filter. Get your count and push your edit up to a dictionary of globals

Push(parentUpdates, {
    'attributes': Dictionary(
        SiteRisk, newSiteRisk)
})

to then push your edits in your return dictionary.

JamesBooth

Thanks for your response Jake! I appreciate your assistance very much! I'm completely new to Arcade and I'll admit I'm using AI tools to assist, which is why I'm likely having issues. My relationship between WNV_StagnantWaterSites and WNV_SiteVisits is actually 1:M. I have one WNV_StagnantWaterSites record with multiple WNV_SiteVisits records. Both are point feature classes. Parent represents the Stagnant Water Site. Child records are point locations surrounding the stagnant water site. Staff want to know specifically where students are collecting on a pond as an example.

I tried your suggestions of using GlobalID instead of ObjectID and I also removed the return null, and just have return. Unfortunately, I still don't have my SiteRisk level changing. Even if I trigger the rule by applying a LarvacideRequest = "1" (Yes), nothing happens to the SiteRisk in the parent point feature layer. My updated syntax is at bottom.

I also wonder what my execution parameters should be set at. This is what I have:

// Define the related records from the WNV_SiteVisits layer
var relatedRecords = FeatureSetByRelationshipName($feature, "SDEDB1.GISADMIN.WNV_StagnantWaterSites_TO_WNV_SiteVisits");
var currentDate = Now();
var oneYearAgo = DateAdd(currentDate, -1, 'years');
var larvacideRequestCount = 0;

// Iterate through related records to count LarvacideRequest values of "1" (Yes) in the past 12 months
for (var record in relatedRecords) {
    if (record["LarvacideRequest"] == 1 && record["SiteVisitDate"] >= oneYearAgo) {
        larvacideRequestCount++;
    }
}

// Determine the new SiteRisk value based on the count of LarvacideRequest values
var newSiteRisk = "";
if (larvacideRequestCount == 0) {
    newSiteRisk = "Low";
} else if (larvacideRequestCount == 1) {
    newSiteRisk = "Moderate";
} else if (larvacideRequestCount >= 2) {
    newSiteRisk = "High";
}

// Update the parent record's SiteRisk field if it needs to be changed
if ($feature["SiteRisk"] != newSiteRisk) {
    return {
        "edit": [{
            "className": "SDEDB1.GISADMIN.WNV_StagnantWaterSites",
            "updates": [{
                "GlobalID": $feature["GlobalID"],
                "attributes": {
                    "SiteRisk": newSiteRisk
                }
            }]
        }]
    };
}

// End the expression evaluation if no update is needed
return;

Jake_S

@JamesBooth my apologies, I glossed over the initial part not realizing the relationship was 1:M.

Few questions,

Can you provide a screenshot of that relationship properties?

catalog > right click relationship > properties

Also are you able provide empty data sets for the schema (create a copy and delete the contents)? If not that's fine.

I's want to test a solution.

~Jake

Jake_S

@JamesBooth did a recording that may help.

JamesBooth

Jake_S

@JamesBooth well I love to be proven wrong, even by me.

// Relationship class name
var relationshipName = "WNV_StagnantWaterSites_TO_WNV_SiteVisits";
var parentGlobalID;
var newSiteRisk = "";

// Define the cutoff date for the last 12 months
var today = Now();
var twelveMonthsAgo = DateAdd(today, -12, "months");

// Fetch related parent record (WNV_StagnantWaterSites)
var relatedParent = FeatureSetByRelationshipName($feature, "WNV_StagnantWaterSites_TO_WNV_SiteVisits", ["GlobalID"], false);

for (var parent in relatedParent) {
    parentGlobalID = parent.GlobalID;
    // Fetch related site visit records (Child Features)
    var relatedVisits = FeatureSetByRelationshipName(parent, "WNV_StagnantWaterSites_TO_WNV_SiteVisits", ["GlobalID","LarvacideRequest","SiteVisitDate"], false);

    // Debugging: Log how many related visits were found
    Console(" Found " + Count(relatedVisits) + " related site visit records.");

    // Filter visits where LarvacideRequest = 1 (Yes) AND occurred in the past 12 months
    var recentLarvacideVisits = Filter(relatedVisits, "LarvacideRequest = 1 AND SiteVisitDate >= @twelveMonthsAgo");

    // Count qualifying visits
    var visitCount = Count(recentLarvacideVisits);

    // Debugging: Log how many visits met the criteria
    Console(":calendar: " + visitCount + " site visits in the past 12 months had LarvacideRequest = 1.");

    // Determine new SiteRisk value based on visit count
    if (visitCount == 0) {
        newSiteRisk = "Low";
    } else if (visitCount == 1) {
        newSiteRisk = "Moderate";
    } else if (visitCount >= 2) {
        newSiteRisk = "High";
    }
}

return {
    'edit': [{
        'className': 'WNV_StagnantWaterSites',
        'updates': [{
            'globalID': parentGlobalID,
            'attributes': {
                "SiteRisk": newSiteRisk
            }
        }]
    }]
}

Try this applied to your in place of your original on the WNV_SiteVisits.

JamesBooth

Thanks Jake! I will try this shortly later today and I'll let you know how it goes. I actually may not even need this rule anymore lol! Might be changing the workflow slightly so that user has more control on when SiteRisk needs changing. But I still want to see if I can get this working! So thank you! I'll keep you apprised!

JamesBooth

It works!! Fantastic. There does remain a small issue though and I'm trying to find it! The issue is deleting any WNV_SiteVisits records. If I create a new site visit and add a high larva count, which successfully triggers my "LarvacideRequest" field to become "1" (Yes), then the SiteRisk changes to moderate in the Parent, which is exactly what I want. But if I delete that WNV_SiteVisits record instantly, the SiteRisk level (value) remains the same in the Parent, and I would want it go back to 'Low' risk. I'm sure I'm missing something obvious. Add, update and delete are the triggers. And I have "exclude from application evaluation" checked because I got an error saying it needed to be checked given certain functions in the code (Edit()). Once that was checked, the attribute rule performs fine, with the exception of when I delete a WNV_SiteVisits record. SiteRisk remains the same.

Jake_S

I saw this issue in my testing. I'm looking to get some answers internally. This was discussed way back when here Attribute Rule Delete Trigger to Update Another Feature with no luck. I tried to modify our code to use, as the article suggests, (line 10 - 14) to check if the edit is DELETE and replace $feature with $originalFeature with no luck.

// Relationship class name
var relationshipName = "WNV_StagnantWaterSites_TO_WNV_SiteVisits";
var parentGlobalID;
var newSiteRisk = "";

// Define the cutoff date for the last 12 months
var today = Now();
var twelveMonthsAgo = DateAdd(today, -12, "months");

var childFeature = $feature

if ($editcontext.editType == "Delete"){
   childFeature = $originalFeature
}


// Fetch related parent record (WNV_StagnantWaterSites)
var relatedParent = FeatureSetByRelationshipName(childFeature, "WNV_StagnantWaterSites_TO_WNV_SiteVisits", ["GlobalID"], false);

for (var parent in relatedParent) {
    parentGlobalID = parent.GlobalID;
    // Fetch related site visit records (Child Features)
    var relatedVisits = FeatureSetByRelationshipName(parent, "WNV_StagnantWaterSites_TO_WNV_SiteVisits", ["GlobalID","LarvacideRequest","SiteVisitDate"], false);

    // Debugging: Log how many related visits were found
    Console(" Found " + Count(relatedVisits) + " related site visit records.");

    // Filter visits where LarvacideRequest = 1 (Yes) AND occurred in the past 12 months
    var recentLarvacideVisits = Filter(relatedVisits, "LarvacideRequest = 1 AND SiteVisitDate >= @twelveMonthsAgo");

    // Count qualifying visits
    var visitCount = Count(recentLarvacideVisits);

    // Debugging: Log how many visits met the criteria
    Console(":calendar: " + visitCount + " site visits in the past 12 months had LarvacideRequest = 1.");

    // Determine new SiteRisk value based on visit count
    if (visitCount == 0) {
        newSiteRisk = "Low";
    } else if (visitCount == 1) {
        newSiteRisk = "Moderate";
    } else if (visitCount >= 2) {
        newSiteRisk = "High";
    }
}

return {
    'edit': [{
        'className': 'WNV_StagnantWaterSites',
        'updates': [{
            'globalID': parentGlobalID,
            'attributes': {
                "SiteRisk": newSiteRisk
            }
        }]
    }]
}

JamesBooth

I took yours above and tried this to see if it would do the trick, but no luck as well! Getting close I think though! I would think it's possible! (hopeful positivity lol!)

// Relationship class name
var relationshipName = "WNV_StagnantWaterSites_TO_WNV_SiteVisits";
var parentGlobalID;
var newSiteRisk = "";

// Define the cutoff date for the last 12 months
var today = Now();
var twelveMonthsAgo = DateAdd(today, -12, "months");

// Determine if the operation is a delete and set the correct reference
var childFeature = $feature;
if ($editcontext.editType == "Delete") {
    childFeature = $originalFeature;
}

// Fetch related parent record (WNV_StagnantWaterSites)
var relatedParent = FeatureSetByRelationshipName(childFeature, relationshipName, ["GlobalID"], false);

if (IsEmpty(relatedParent)) {
    Console("<span class="lia-unicode-emoji" title=":cross_mark:">❌</span> No related parent found for deleted site visit.");
    return;
} else {
    Console("<span class="lia-unicode-emoji" title=":white_heavy_check_mark:">✅</span> Found parent feature. Proceeding with update.");
}

// Process the parent feature
for (var parent in relatedParent) {
    parentGlobalID = parent.GlobalID;

    // Fetch all remaining site visits **AFTER** deletion
    var remainingVisits = FeatureSetByRelationshipName(parent, relationshipName, ["LarvacideRequest", "SiteVisitDate"], false);

    Console("<span class="lia-unicode-emoji" title=":magnifying_glass_tilted_right:">🔎</span> Remaining visits after delete: " + Count(remainingVisits));

    // If no visits remain, reset SiteRisk to "Low"
    if (Count(remainingVisits) == 0) {
        Console("<span class="lia-unicode-emoji" title=":stop_sign:">🛑</span> No remaining site visits. Resetting SiteRisk to Low.");
        newSiteRisk = "Low";
    } else {
        // Filter visits where LarvacideRequest = 1 AND occurred in the past 12 months
        var recentLarvacideVisits = Filter(remainingVisits, "LarvacideRequest = 1 AND SiteVisitDate >= @twelveMonthsAgo");
        var visitCount = Count(recentLarvacideVisits);

        Console(":bar_chart:</img> Recalculating SiteRisk: " + visitCount + " valid site visits remain.");

        // Assign SiteRisk based on visit count
        if (visitCount == 0) {
            newSiteRisk = "Low";
        } else if (visitCount == 1) {
            newSiteRisk = "Moderate";
        } else if (visitCount >= 2) {
            newSiteRisk = "High";
        }
    }
}

// Apply the SiteRisk update to the parent feature
return {
    'edit': [{
        'className': 'SDEDB1.GISADMIN.WNV_StagnantWaterSites',
        'updates': [{
            'globalID': parentGlobalID,
            'attributes': {
                "SiteRisk": newSiteRisk
            }
        }]
    }]
};

Jake_S

@JamesBooth I still have not heard back from our internal resources. As soon as I do, I'll post.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.