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

Populate a value from one table to another using a joining field

GdB_Admin

Hello,

I am trying to populate a field based on where a joining ID is between two tables. I have a relationship class set up between two tables but I want to bring over another value than just a GlobalID. So I was trying to use an attribute class to do this but it is not working for me. Can someone help?

My joining field is LocationGlobalID = GlobalID

The field I want populated from one table to the other is GdBOrderNumber = GdBOrderNumber

var f_gid = $feature.LocationGlobalID;

var Project = FeatureSetByName($datastore, "Database.DBO.[Other Table]", ["*"], true);
var Join = Filter(Project, "GlobalID = @f_gid");

return {
'result': $feature.GdBOrderNumber,
'edit': [
{"GdBOrderNumber": $feature.GdBOrderNumber
} 
]
};

Encontre mais publicações marcadas com

Accepted answers

JohannesLindner

Ah OK, in that case, you're editing the $feature itself, which makes it a little easier:

// calculation attribute rule
// triggers: insert(, update)
// field: GdBOrderNumber

var f_gid = $feature.LocationGlobalID;
var related_records = FeatureSetByName($datastore, "Database.DBO.[FeatureClass]", ["*"], false);
var Join = Filter(related_records, "GlobalID = @f_gid");

// return GdBOrderNumber of the first feature in Join
// if Join is empty (no related features found), return null
var firstJoin = First(Join)
if(firstJoin == null) {
    return null
}
return firstJoin.GdBOrderNumber

// or, if you leave the field parameter empty:
return {
    "result": {"attributes": {"GdBOrderNumber": firstJoin.GdBOrderNumber}}
}

All comments

JohannesLindner

Ah OK, in that case, you're editing the $feature itself, which makes it a little easier:

// calculation attribute rule
// triggers: insert(, update)
// field: GdBOrderNumber

var f_gid = $feature.LocationGlobalID;
var related_records = FeatureSetByName($datastore, "Database.DBO.[FeatureClass]", ["*"], false);
var Join = Filter(related_records, "GlobalID = @f_gid");

// return GdBOrderNumber of the first feature in Join
// if Join is empty (no related features found), return null
var firstJoin = First(Join)
if(firstJoin == null) {
    return null
}
return firstJoin.GdBOrderNumber

// or, if you leave the field parameter empty:
return {
    "result": {"attributes": {"GdBOrderNumber": firstJoin.GdBOrderNumber}}
}

GdB_Admin

@JohannesLindner I spoke a bit too early on this. what you gave me works but it is in the wrong direction form what I am looking for. the set up is the FeatureClass has the relationship class on it. When an inspection is done it is being put into the table using that GlobalID = LocationGlobalID. From here now that the Table has a new record in it I need to use that Relationship Class ID (LocationGlobalID) and grab the GdBOrderNumber field from the FeatureClass and apply it to the Table. I am putting the Attribute Rule on the Table because that is where the Insert is taking place. I tried to change the code you gave me but it keeps giving me errors or just does nothing. I tried to use the LocationGlobalID field in the dictionary like you said but it is telling me I need to use the GlobalID field, but when I do that it does not do anything. Here is what I have:

var f_gid = $feature.LocationGlobalID;
var related_records = FeatureSetByName($datastore, "Database.DBO.[FeatureClass]", ["*"], false);
var Join = Filter(related_records, "GlobalID = @f_gid");

// create and fill the update array
var updates = []
for(var record in Join) {
// updates is an array of dictionaries
// the dictionaries are built like this:
// {"globalID": "GID of the edited feature", "attributes": {"Field": value}}
var update = {"LocationGlobalID": record.GlobalID, "attributes": {"GdBOrderNumber": record.GdBOrderNumber}}
Push(updates, update)
}

// apply the edits
return {
"edit": [
{
"className": "Database.DBO.[Table]",
"updates": updates
}
]
}

GdB_Admin

That is what i was looking for and thank you for the link that will help a lot

JohannesLindner

So, you have Table A with this rule and you want to populate the field "GdBOrderNumber" on Table B, is that correct?

// calculation attribute rule
// triggers: insert(, update)
// field: empty

// get the related record(s)
// either use FeatureSetByName() and Filter() like you did
// or use the relationship class:
var related_records = FeatureSetByRelationshipName($feature, "RelationShipName", ["GlobalID"], false)
// we're only interested in the related records' GlobalID, because we need that to identify them in the return dictionary

// create and fill the update array
var updates = []
for(var record in related_records) {
    // updates is an array of dictionaries
    // the dictionaries are built like this:
    // {"globalID": "GID of the edited feature", "attributes": {"Field": value}}
    var update = {"globalID": record.GlobalID, "attributes": {"GdBOrderNumber": $feature.GdBOrderNumber}}
    Push(updates, update)
}

// apply the edits
return {
    "edit": [
        {
            "className": "Database.DBO.OtherTable",
            "updates": updates
        }
    ]
}

To learn more about the return dictionary keywords, read this: Attribute rule dictionary keywords—ArcGIS Pro | Documentation

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Entrar
Registrar

Links Rápidos

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