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 error when using FeatureSet to get related data

Anonymous User

I'm working with a feature layer and a separate table that have a column in common (many to one relationship). The feature layer common field name is PropName and the table field name is GIS_PropName. I'm attempting to use FeatureSets to get the value of a second field called WMAName using Arcade. I can get as far as the below but when I change the last line to:

return target.WMAName;

I get the following error. Execution Error:Runtime Error: Cannot call member property on object of this type. WMAName

Najděte více příspěvků označených jako

Accepted answers

XanderBakker

In this case target is a collection of records, which might only have one record. You can do something like this:

<SPAN class="keyword token">var</SPAN> target <SPAN class="operator token">=</SPAN> <SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> target<SPAN class="punctuation token">.</SPAN>WMAName<SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// or</SPAN>

<SPAN class="keyword token">var</SPAN> target <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> target<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>WMAName<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>

All comments

XanderBakker

In this case target is a collection of records, which might only have one record. You can do something like this:

<SPAN class="keyword token">var</SPAN> target <SPAN class="operator token">=</SPAN> <SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> target<SPAN class="punctuation token">.</SPAN>WMAName<SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// or</SPAN>

<SPAN class="keyword token">var</SPAN> target <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> target<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>WMAName<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>

Anonymous User

Thanks Xander. That first method worked.

Mitch East

GIS Specialist 3, Game Management

Wildlife Resources Division<http://georgiawildlife.com/>

O: (706) 557-3270 | M: (678) 787-5627

Facebook<http://www.facebook.com/WildlifeResourcesDivisionGADNR> • Twitter<http://twitter.com/georgiawild> • Instagram<http://www.instagram.com/georgiawildlife>

Buy a hunting or fishing license today!<http://georgiawildlife.com/licenses-permits-passes>

—————————————————

A division of the

GEORGIA DEPARTMENT OF NATURAL RESOURCES

XanderBakker

I'm glad it worked. Just remember that the filter will return a collection even if the collection contains only a single record. You will have to drill down to the record to be able to query the individual attribute values.

ahagopian_coj

Hello! In Workforce is a related table with assignment types. I am trying to pull the assignment types description field from this related table into a pop-up. I am trying to use this code (modified of course) but get an execution error. Any tips you can toss my way would be greatly appreciated!

var tbl = FeatureSetByName($map,"workforce_8b965c8647bc45d79891d13f207335c8 - Assignment Types", ['description']);
var descr = $feature.description;
var sql = "assignmenttype = '" + descr + "'";
var target = First(Filter(tbl, sql));
return target.description;

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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