I am having trouble with for loops. This example prints out the second item in the array. var array = [ "RC-22p" , "RC-22e" ] ; ; for ( var c in array ) { var invoice = array [ c ] } return invoice The result is RC-22e. I am trying to loop through an array, look up the corresponding globalid and update that related record. When I run my code the first item in the array is completed, but it stops after the first one, it doesn't loop... How can I get my for loop to loop when my return is updating another feature class? var array = [ "RC-22H" , "RC-22I" ] ; var pipe = "" ; var invoice = "" ; var i = "" ; var c = "" ; //loop for ( var c in array ) { //lookup globalid based on item in array var pipe = FeatureSetByName ( $datastore , "SUDOECMS.DBO.doe_EAP_pipelineabandon" ) ; var invoice = filter ( pipe , "invoice = '" + array [ c ] + "'" ) ; var i = first ( invoice ) ; //if feature value is q_1, update the other record if ( $feature . q_x = = 'q_1' ) { return { "result" : $feature . q_x , 'edit' : [ { 'className' : 'SUDOECMS.DBO.doe_EAP_pipelineabandon' , 'updates' : [ { 'globalID' : i . GlobalID , 'attributes' : { 'q_1' : $feature . status , 'q_1comments' : $feature . q_xcomments , 'q_1rank' : $feature . q_xrank } } ] } ] } } //stops here but I want to repeat, it only updates the other record based on RC-22H, it does not update RC-22I. Xander Bakker

Hi TLongSUGF , I think it will be very difficult to provide working code without access to the data, but have a look at the code below. I changed some variable name to make it a bit more understandable for me. Some observations: * I removed some redundant declarations from the start of the expression * On row 5 and 6 I simplified the SQL * In the loop that starts on line 12, "contract" is a feature/row and to access the attribute you have to use the name of the field (edit that on line 14) * I have places the modification of the update array inside a validation of the pipe count * When accessing a field by its name that contains underscores in the name, it might be better to use "$feature["Field_Name"] than $feature.Field_Name. This might not be an issue anymore, but is was some time ago. var updates = [ ] ; var counter = 0 ; var contract_fc = FeatureSetByName ( $datastore , "SUDOECMS.DBO.doe_EAP_pipelineabandon_contracts" , [ "contract" ] , false ) ; var rowid = $feature . uniquerowid ; var sql = "parentrowid = @rowid" ; var contracts = Filter ( contract_fc , sql ) ; var cnt = count ( contracts ) ; //var array = ["AM-094", "AM-095"] if ( cnt > 0 ) { for ( var contract in contracts ) { var abandonedpipes = FeatureSetByName ( $datastore , "SUDOECMS.DBO.doe_EAP_pipelineabandon" , [ "*" ] , false ) ; var invoice_id = contract [ "NameOfFieldWithInvoiceID" ] ; // edit this! var sql2 = "invoice = @invoice_id" ; var pipes = Filter ( abandonedpipes , sql2 ) ; if ( Count ( pipes ) > 0 ) { var pipe = first ( pipes ) ; // why only the first??? updates [ counter ] = { 'globalID' : pipe . GlobalID , 'attributes' : { 'q_1' : $feature . status , 'q_1comments' : $feature [ "q_xcomments" ] , 'q_1rank' : $feature [ "q_xrank" ] } } counter ++ ; } } return { 'result' : $feature [ "q_x" ] , 'edit' : [ { 'className' : 'SUDOECMS.DBO.doe_EAP_pipelineabandon' , 'updates' : updates } ] } ; } else { return $feature [ "q_x" ] ; }

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 For Loop & Attribute Updates on other Features

TLongSUGF

I am having trouble with for loops. This example prints out the second item in the array.

var array <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"RC-22p"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"RC-22e"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">for</SPAN><SPAN class="punctuation token">(</SPAN>var <SPAN class="number token">c</SPAN> <SPAN class="operator token">in</SPAN> array<SPAN class="punctuation token">)</SPAN> {
    var invoice <SPAN class="operator token">=</SPAN> array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">c</SPAN><SPAN class="punctuation token">]</SPAN>
    
    }
    <SPAN class="keyword token">return</SPAN> invoice‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The result is RC-22e.

I am trying to loop through an array, look up the corresponding globalid and update that related record. When I run my code the first item in the array is completed, but it stops after the first one, it doesn't loop... How can I get my for loop to loop when my return is updating another feature class?

var array <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"RC-22H"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"RC-22I"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
var pipe <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
var invoice <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
var i <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
var <SPAN class="number token">c</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">//loop</SPAN>
<SPAN class="keyword token">for</SPAN><SPAN class="punctuation token">(</SPAN>var <SPAN class="number token">c</SPAN> <SPAN class="operator token">in</SPAN> array<SPAN class="punctuation token">)</SPAN> 
{
<SPAN class="comment token">//lookup globalid based on item in array</SPAN>
    var pipe <SPAN class="operator token">=</SPAN> FeatureSetByName<SPAN class="punctuation token">(</SPAN>$datastore<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"SUDOECMS.DBO.doe_EAP_pipelineabandon"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    var invoice <SPAN class="operator token">=</SPAN> filter<SPAN class="punctuation token">(</SPAN>pipe<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"invoice = '"</SPAN> <SPAN class="operator token">+</SPAN> array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">c</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    var i <SPAN class="operator token">=</SPAN> <SPAN class="token function">first</SPAN><SPAN class="punctuation token">(</SPAN>invoice<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">//if feature value is q_1, update the other record        </SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>q_x <SPAN class="operator token">=</SPAN><SPAN class="operator token">=</SPAN> <SPAN class="string token">'q_1'</SPAN><SPAN class="punctuation token">)</SPAN>{     
            <SPAN class="keyword token">return</SPAN> {
               <SPAN class="string token">"result"</SPAN>: $feature<SPAN class="punctuation token">.</SPAN>q_x<SPAN class="punctuation token">,</SPAN>
                   <SPAN class="string token">'edit'</SPAN>: <SPAN class="punctuation token">[</SPAN>{
                       <SPAN class="string token">'className'</SPAN>: <SPAN class="string token">'SUDOECMS.DBO.doe_EAP_pipelineabandon'</SPAN><SPAN class="punctuation token">,</SPAN>
                   <SPAN class="string token">'updates'</SPAN>: <SPAN class="punctuation token">[</SPAN>{
                       <SPAN class="string token">'globalID'</SPAN>: i<SPAN class="punctuation token">.</SPAN>GlobalID<SPAN class="punctuation token">,</SPAN>
                       <SPAN class="string token">'attributes'</SPAN>: {
                           <SPAN class="string token">'q_1'</SPAN>: $feature<SPAN class="punctuation token">.</SPAN><SPAN class="keyword token">status</SPAN><SPAN class="punctuation token">,</SPAN>
                           <SPAN class="string token">'q_1comments'</SPAN> :  $feature<SPAN class="punctuation token">.</SPAN>q_xcomments<SPAN class="punctuation token">,</SPAN>
                           <SPAN class="string token">'q_1rank'</SPAN> :  $feature<SPAN class="punctuation token">.</SPAN>q_xrank
                                          }
                                   }<SPAN class="punctuation token">]</SPAN>
                            }<SPAN class="punctuation token">]</SPAN>
                       }
}
<SPAN class="comment token">//stops here but I want to repeat, it only updates the other record based on RC-22H, it does not update RC-22I.                ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Xander Bakker‌

Trouver plus de publications taguées avec

Accepted answers

XanderBakker

Hi TLongSUGF ,

I think it will be very difficult to provide working code without access to the data, but have a look at the code below. I changed some variable name to make it a bit more understandable for me. Some observations:

I removed some redundant declarations from the start of the expression
On row 5 and 6 I simplified the SQL
In the loop that starts on line 12, "contract" is a feature/row and to access the attribute you have to use the name of the field (edit that on line 14)
I have places the modification of the update array inside a validation of the pipe count
When accessing a field by its name that contains underscores in the name, it might be better to use "$feature["Field_Name"] than $feature.Field_Name. This might not be an issue anymore, but is was some time ago.

<SPAN class="keyword token">var</SPAN> updates <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> counter <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> contract_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">"SUDOECMS.DBO.doe_EAP_pipelineabandon_contracts"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"contract"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> rowid <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>uniquerowid<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"parentrowid = @rowid"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> contracts <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>contract_fc<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">count</SPAN><SPAN class="punctuation token">(</SPAN>contracts<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">//var array = ["AM-094", "AM-095"]</SPAN>

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt <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> contract <SPAN class="keyword token">in</SPAN> contracts<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">var</SPAN> abandonedpipes <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">"SUDOECMS.DBO.doe_EAP_pipelineabandon"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">var</SPAN> invoice_id <SPAN class="operator token">=</SPAN> contract<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"NameOfFieldWithInvoiceID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// edit this!</SPAN>
        <SPAN class="keyword token">var</SPAN> sql2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"invoice = @invoice_id"</SPAN><SPAN class="punctuation token">;</SPAN>          
        <SPAN class="keyword token">var</SPAN> pipes <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>abandonedpipes<SPAN class="punctuation token">,</SPAN> sql2<SPAN class="punctuation 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>pipes<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">var</SPAN> pipe <SPAN class="operator token">=</SPAN> <SPAN class="token function">first</SPAN><SPAN class="punctuation token">(</SPAN>pipes<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// why only the first???</SPAN>
            updates<SPAN class="punctuation token">[</SPAN>counter<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'globalID'</SPAN><SPAN class="punctuation token">:</SPAN> pipe<SPAN class="punctuation token">.</SPAN>GlobalID<SPAN class="punctuation token">,</SPAN>
                                <SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
                                   <SPAN class="string token">'q_1'</SPAN><SPAN class="punctuation token">:</SPAN> $feature<SPAN class="punctuation token">.</SPAN>status<SPAN class="punctuation token">,</SPAN>
                                   <SPAN class="string token">'q_1comments'</SPAN><SPAN class="punctuation token">:</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"q_xcomments"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                                   <SPAN class="string token">'q_1rank'</SPAN><SPAN class="punctuation token">:</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"q_xrank"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN>
                         <SPAN class="punctuation token">}</SPAN>
            counter<SPAN class="operator token">++</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'result'</SPAN><SPAN class="punctuation token">:</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"q_x"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
            <SPAN class="string token">'edit'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'className'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SUDOECMS.DBO.doe_EAP_pipelineabandon'</SPAN><SPAN class="punctuation token">,</SPAN>
                      <SPAN class="string token">'updates'</SPAN><SPAN class="punctuation token">:</SPAN> updates<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"q_x"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<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>‍</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>

All comments

TLongSUGF

Speechless. I added the name of the field as mentioned above and it worked.

I will compare yours and mine to get a better understanding. You rock!

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">var</SPAN> pipe <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> <SPAN class="" style="color: #d74444; border: 0px; font-weight: inherit; font-size: 14px;">first</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>pipes<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">;</SPAN> <SPAN class="" style="color: slategray; border: 0px; font-weight: inherit; font-size: 14px;">// why only the first???</SPAN>

This is to make sure I only have one record. If that makes sense.

XanderBakker

Hi TLongSUGF ,

I removed some redundant declarations from the start of the expression
On row 5 and 6 I simplified the SQL
In the loop that starts on line 12, "contract" is a feature/row and to access the attribute you have to use the name of the field (edit that on line 14)
I have places the modification of the update array inside a validation of the pipe count
When accessing a field by its name that contains underscores in the name, it might be better to use "$feature["Field_Name"] than $feature.Field_Name. This might not be an issue anymore, but is was some time ago.

<SPAN class="keyword token">var</SPAN> updates <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> counter <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> contract_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">"SUDOECMS.DBO.doe_EAP_pipelineabandon_contracts"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"contract"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> rowid <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>uniquerowid<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"parentrowid = @rowid"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> contracts <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>contract_fc<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">count</SPAN><SPAN class="punctuation token">(</SPAN>contracts<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">//var array = ["AM-094", "AM-095"]</SPAN>

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt <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> contract <SPAN class="keyword token">in</SPAN> contracts<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">var</SPAN> abandonedpipes <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">"SUDOECMS.DBO.doe_EAP_pipelineabandon"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">var</SPAN> invoice_id <SPAN class="operator token">=</SPAN> contract<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"NameOfFieldWithInvoiceID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// edit this!</SPAN>
        <SPAN class="keyword token">var</SPAN> sql2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"invoice = @invoice_id"</SPAN><SPAN class="punctuation token">;</SPAN>          
        <SPAN class="keyword token">var</SPAN> pipes <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>abandonedpipes<SPAN class="punctuation token">,</SPAN> sql2<SPAN class="punctuation 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>pipes<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">var</SPAN> pipe <SPAN class="operator token">=</SPAN> <SPAN class="token function">first</SPAN><SPAN class="punctuation token">(</SPAN>pipes<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// why only the first???</SPAN>
            updates<SPAN class="punctuation token">[</SPAN>counter<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'globalID'</SPAN><SPAN class="punctuation token">:</SPAN> pipe<SPAN class="punctuation token">.</SPAN>GlobalID<SPAN class="punctuation token">,</SPAN>
                                <SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
                                   <SPAN class="string token">'q_1'</SPAN><SPAN class="punctuation token">:</SPAN> $feature<SPAN class="punctuation token">.</SPAN>status<SPAN class="punctuation token">,</SPAN>
                                   <SPAN class="string token">'q_1comments'</SPAN><SPAN class="punctuation token">:</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"q_xcomments"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                                   <SPAN class="string token">'q_1rank'</SPAN><SPAN class="punctuation token">:</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"q_xrank"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN>
                         <SPAN class="punctuation token">}</SPAN>
            counter<SPAN class="operator token">++</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'result'</SPAN><SPAN class="punctuation token">:</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"q_x"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
            <SPAN class="string token">'edit'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'className'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SUDOECMS.DBO.doe_EAP_pipelineabandon'</SPAN><SPAN class="punctuation token">,</SPAN>
                      <SPAN class="string token">'updates'</SPAN><SPAN class="punctuation token">:</SPAN> updates<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"q_x"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<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>‍</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>

TLongSUGF

I did get that to work, but I had hard coded in my array. Now I am trying to create my array on insert. Lines 8 - 11 grab the related records and put them in an array.

This breaks on line 17 when I comment out the hard coded array (line 12, but works when using var array. It would appear as though my array is not getting created. Any Ideas?

var pipe <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
var invoice <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
var i <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
var <SPAN class="number token">c</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
var u <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
var counter <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN>

var contract_fc <SPAN class="operator token">=</SPAN> FeatureSetByName<SPAN class="punctuation token">(</SPAN>$datastore<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"SUDOECMS.DBO.doe_EAP_pipelineabandon_contracts"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"contract"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
var sql <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"parentrowid = '"</SPAN> <SPAN class="operator token">+</SPAN> $feature<SPAN class="punctuation token">.</SPAN>uniquerowid <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN>
var array <SPAN class="operator token">=</SPAN> filter<SPAN class="punctuation token">(</SPAN>contract_fc<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN>
var cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">count</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">//var array = ["AM-094", "AM-095"]</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> {
<SPAN class="keyword token">for</SPAN><SPAN class="punctuation token">(</SPAN>var <SPAN class="number token">c</SPAN> <SPAN class="operator token">in</SPAN> array<SPAN class="punctuation token">)</SPAN> 
{

    var pipe <SPAN class="operator token">=</SPAN> FeatureSetByName<SPAN class="punctuation token">(</SPAN>$datastore<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"SUDOECMS.DBO.doe_EAP_pipelineabandon"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    var invoice <SPAN class="operator token">=</SPAN> filter<SPAN class="punctuation token">(</SPAN>pipe<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"invoice = '"</SPAN> <SPAN class="operator token">+</SPAN> array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">c</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    var i <SPAN class="operator token">=</SPAN> <SPAN class="token function">first</SPAN><SPAN class="punctuation token">(</SPAN>invoice<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        u<SPAN class="punctuation token">[</SPAN>counter<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> {<SPAN class="string token">'globalID'</SPAN>: i<SPAN class="punctuation token">.</SPAN>GlobalID<SPAN class="punctuation token">,</SPAN>
                       <SPAN class="string token">'attributes'</SPAN>: {
                           <SPAN class="string token">'q_1'</SPAN>: $feature<SPAN class="punctuation token">.</SPAN><SPAN class="keyword token">status</SPAN><SPAN class="punctuation token">,</SPAN>
                           <SPAN class="string token">'q_1comments'</SPAN> :  $feature<SPAN class="punctuation token">.</SPAN>q_xcomments<SPAN class="punctuation token">,</SPAN>
                           <SPAN class="string token">'q_1rank'</SPAN> :  $feature<SPAN class="punctuation token">.</SPAN>q_xrank
                                          }
                      }
                       counter<SPAN class="operator token">+</SPAN><SPAN class="operator token">+</SPAN>
    }
          <SPAN class="keyword token">return</SPAN>   {
               <SPAN class="string token">"result"</SPAN>: $feature<SPAN class="punctuation token">.</SPAN>q_x<SPAN class="punctuation token">,</SPAN>
                   <SPAN class="string token">'edit'</SPAN>: <SPAN class="punctuation token">[</SPAN>{
                       <SPAN class="string token">'className'</SPAN>: <SPAN class="string token">'SUDOECMS.DBO.doe_EAP_pipelineabandon'</SPAN><SPAN class="punctuation token">,</SPAN>
                   <SPAN class="string token">'updates'</SPAN>: u
                            }<SPAN class="punctuation token">]</SPAN>
                       }
                   }
<SPAN class="keyword token">else</SPAN> {
<SPAN class="keyword token">return</SPAN> $feature<SPAN class="punctuation token">.</SPAN>q_x
           }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</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>

TLongSUGF

Got it, thanks! You the man!

XanderBakker

Hi T L ,

When you use a "return" inside a loop, you exit the expression the first time it hits the return.

To update multiple features you need to return a list with all the updates. Have a look at the variable "AddList" in the example "Edit another feature class with a calculation rule" at this page: Attribute rule script expression examples—ArcGIS Pro | Documentation .

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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