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

Arcade - Update Feature Class based on related table

KierenTinning2

All,

I am trying to implement an attribute rule which updates a feature class field when the related 1:M table gets updated. The process right now is, the field in the related table changes, we get the keys, roll up the data into a string and then get the related record in the feature class and write the text value.

Issue is, a) the for loop is in error and if I comment it our and put a dummy value in my text variable, it doesn't actually write anything.

Any help would be appreciated.- thank you

var tbl = FeatureSetByName($datastore,"DB.LAND.CustomerAddress");
var fc = FeatureSetByName($datastore,"DB.LAND.AddressLocation");
var locationeguidKey = $feature["locationeguid"];
var CustomerSql = "locationeguidKey = '" + locationeguidKey + "'";
var premiseSQL = "GlobalID = '" + locationeguidKey + "'";
var CustomerAddressResult = Filter(tbl, CustomerSql);
var txt = null;

var address;

for (var address in nonCustomerAddressResult){
txt = Text(address.building_number, ',');
}

return {

if (Count(txt) > 0){
txt = Left(txt, Count(txt) - 1);
premiseResult = Filter(fc, premiseSQL)
// premiseKey.labeltext = txt;
}

"result" : txt,

"edit":[{
"className": "premiseResult",
"updates" : [{
"labeltext": txt
}]
}]
}

Encontre mais publicações marcadas com

Accepted answers

All comments

XanderBakker

Hi KierenTinning ,

For testing in the pop-up I would probably first use something like this:

<SPAN class="keyword token">var</SPAN> tbl <SPAN class="operator token">=</SPAN> <SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$datastore<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"DB.LAND.NonCustomerAddress"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> fc <SPAN class="operator token">=</SPAN> <SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$datastore<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"DB.LAND.Premise"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> premiseKey <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"GlobalID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// replace with an existing GlobalID from the table</SPAN>
<SPAN class="keyword token">var</SPAN> nonCustomerSql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"GlobalID = @premiseKey"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN>nonCustomerSql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> nonCustomerAddressResult <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> nonCustomerSql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Count:"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>nonCustomerAddressResult<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> txt <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>nonCustomerAddressResult<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> address <SPAN class="keyword token">in</SPAN> nonCustomerAddressResult<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
        txt <SPAN class="operator token">=</SPAN> txt <SPAN class="operator token">+</SPAN> address<SPAN class="punctuation token">.</SPAN>building_number <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="comment token">//premiseKey = address.premiseguid;</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">" - building_number:"</SPAN> <SPAN class="operator token">+</SPAN> address<SPAN class="punctuation token">.</SPAN>building_number<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">" - txt:"</SPAN> <SPAN class="operator token">+</SPAN> txt<SPAN class="punctuation token">)</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">" - premiseguid:"</SPAN> <SPAN class="operator token">+</SPAN> address<SPAN class="punctuation token">.</SPAN>premiseguid<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> txt<SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

... and check the messages that are written to the console.

XanderBakker

Hi Kieren Tinning ,

Would I still use $map in the attribute rule?

No, $map is not available for attribute rules. They are executed at the database level and at that level there is no knowledge about any map. I also recommend using the $datastore in the pop-up to be closer to the actual situation you want to solve.

Also, the $feature here is referencing the point I clicked, however in the attribute rule it's actually reversed as it would be from the table to the feature?

That changes things a bit. You will have to use a default value for the table record to simulate the process. Instead of using

<SPAN class="keyword token">var</SPAN> locationeguidKey <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"locationeguid"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

You should assign an existing "loctioneguid" value from your table to ensure that you can simulate the process.

As for the SQL, I am using it as I need to roll up all of the values from the table and then write them to the the feature in a comma separated list.

The SQL will not work the way you configured it. Verify if you can use FeatureSetByRelationshipName function and if not, change the sql using the example I provided before. Either use this:

<SPAN class="keyword token">var</SPAN> nonCustomerSql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"premiseguid = @premiseKey"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> premiseSQL <SPAN class="operator token">=</SPAN> <SPAN class="string token">"GlobalID = @premiseKey"</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

... or:

<SPAN class="keyword token">var</SPAN> nonCustomerSql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"premiseguid = '{"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">Upper</SPAN><SPAN class="punctuation token">(</SPAN>premiseKey<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"}'"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> premiseSQL <SPAN class="operator token">=</SPAN> <SPAN class="string token">"GlobalID = '{"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">Upper</SPAN><SPAN class="punctuation token">(</SPAN>premiseKey<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"}'"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The following line will not work:

txt <SPAN class="operator token">=</SPAN> txt <SPAN class="operator token">+</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN>address<SPAN class="punctuation token">.</SPAN>building_number<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">','</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

If the building number is numeric then you will have to use the Text function to convert it to text (applying any formatting you want) and concatenate it with the comma.

txt <SPAN class="operator token">=</SPAN> txt <SPAN class="operator token">+</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN>address<SPAN class="punctuation token">.</SPAN>building_number<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

The line:

premiseKey<SPAN class="punctuation token">.</SPAN>labeltext <SPAN class="operator token">=</SPAN> txt<SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

... will result in an error, since premiseKey is a GlobalID and does not have a property "labeltext".

KierenTinning2

Xander Bakker‌, thank you. I am much further ahead, the only part the script appears to be failing on now is an "failed edit operation, Required keyword not defined in script". I wonder if it is the 'labeltext' element, which is actually a field that the result needs to be written to

var tbl = FeatureSetByName($datastore,"DB.LAND.NonCustomerAddress");
var fc = FeatureSetByName($datastore,"DB.LAND.Premise");
var premiseKey = $feature["GlobalID"];
var nonCustomerSql = "GlobalID = '" + premiseKey + "'";
var nonCustomerAddressResult = Filter(tbl, nonCustomerSql);

var txt = null;

for (var address in nonCustomerAddressResult){
txt = txt + address.building_number + ',';
premiseKey = address.premiseguid;
}

var premiseSQL = "GlobalID = '" + premiseKey + "'";
var premiseResult = Filter(fc, premiseSQL);

return {

"result" : txt,

"edit" : [{
"className" : "DB.LAND.Premise",
"updates" : [{
"labeltext" : txt
}]

}]

}

KierenTinning2

Xander, Thank you ,I hadn't even noticed the logic error.

I've updated the code here - for the popup - would I still use $map in the attribute rule? I wouldn't think so, but I could be wrong. Also, the $feature here is referencing the point I clicked, however in the attribute rule it's actually reversed as it would be from the table to the feature?

As for the SQL, I am using it as I need to roll up all of the values from the table and then write them to the the feature in a comma separated list.

var tbl = FeatureSetByName($map,"Non Customer Address");
var fc = FeatureSetByName($map,"Premise");
var premiseKey = $feature["GlobalID"];
var nonCustomerSql = "premiseguid = '" + premiseKey + "'";
var premiseSQL = "GlobalID = '" + premiseKey + "'";
var nonCustomerAddressResult = Filter(tbl, nonCustomerSql);
var txt = null;
var premiseResult = Filter(fc, premiseSQL);

for (var address in nonCustomerAddressResult){
txt = txt + Text(address.building_number, ',');
}

If (count(txt) > 0){
premiseResult = Filter(fc, premiseSQL);
premiseKey.labeltext = txt;
}

return {

"result": txt,
}

XanderBakker

Hi Kieren Tinning ,

A couple of things to start with:

If the data is related through a relationshipclass, use the "FeatureSetByRelationshipName" to access any related data.
If that is not the case, keep in mind that a valid sql expression to filter the data on global id requires son additional formatting. Example: var sql = "parentglobalid = '{" + Upper(code) + "}'";
However, I think it should be possible to use: var premiseSQL = "GlobalID = @locationeguidKey";
I would take out the if statement that is within the return statement and place it before the return
In the for loop you are accessing a variable called "nonCustomerAddressResult". I suppose that should be "CustomerAddressResult"
In the for loop you overwrite for each address the value you assign to variable txt. If you just need a single adress,just use the First (and check if you have any results).
Try the expression for instance in a pop-up and return the txt variable to see if it gives any results. If you have the correct value assigned to the variable txt we will see the next step to write the value to the output.

Participe da Conversa

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

Links Rápidos

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