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

Accessing related attributes via relationship query

MKF62

This is probably a pretty simple javascript syntax question but... I successfully ran a relationship query between a polygon layer and table that has multiple matching records. The problem is that I can't figure out how to access each record's attributes. The object returned from the query contains an array of features, so I figured I would just be able to index and select one single feature from the array, but it's not working out that way. I feel like it has something to do with the OBJECTID used in the relationship query, seen at the very top of the tree ("2470"):

What is the syntax for getting at these features/records?

queryableMgmtTractFL<SPAN class="punctuation token">.</SPAN><SPAN class="token function">queryRelatedFeatures</SPAN><SPAN class="punctuation token">(</SPAN>relatedQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">function</SPAN> <SPAN class="punctuation token">(</SPAN>relatedRecords<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>relatedRecords<SPAN class="punctuation token">[</SPAN>features<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">//Doesn't work</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>

Tried this too:

relatedRecords<SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>attributes‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

The error message I get is that "features" is undefined.

Vind meer berichten getagd met

Accepted answers

MKF62

Since the relatedRecords object can contain multiple OIDs and their related records, you have to index using the OID and then get the associated features with that OID.

relatedRecords<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2470</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>attributes‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

RobertScheitlin__GISP

Molly,

Because a RelationshipQuery has the ability to query multiple OIDs the results are an object keyed to the objectids. So my code

feature<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>attributes<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">[</SPAN>queryableMgmtTractFL<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>objectIdField<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">]</SPAN>

Is just getting the ObjectID vale for a particular feature.

MKF62

If the relatedRecords object is already a collection of features organized by ObjectIDs, wouldn't you just need to put the OID in question as the key value for the relatedRecords object? If you had multiple object IDs queried (in my case only one will be queried at a time), you'd just need to iterate through.

<SPAN class="keyword token">var</SPAN> fset <SPAN class="operator token">=</SPAN> relatedRecords<SPAN class="punctuation token">[</SPAN>OID<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">var</SPAN> feature <SPAN class="operator token">=</SPAN> fset<SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>attributes<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I'm a little perplexed by the key you used in the relatedRecords object in the first code line. I would think that would come back as undefined.

RobertScheitlin__GISP

Molly,

The results of a relationship query are organized by ObjectID. So you have to do something like this:

<SPAN class="comment token">//Where feature is the feature that you are intrested in getting the related</SPAN>
<SPAN class="comment token">//records for.</SPAN>
<SPAN class="keyword token">var</SPAN> fset <SPAN class="operator token">=</SPAN> relatedRecords<SPAN class="punctuation token">[</SPAN>feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN>queryableMgmtTractFL<SPAN class="punctuation token">.</SPAN>objectIdField<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍‍
console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>fset<SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

MKF62

Since the relatedRecords object can contain multiple OIDs and their related records, you have to index using the OID and then get the associated features with that OID.

relatedRecords<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2470</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>attributes‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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