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

Is there an example on how to access related record groups?

AnikaHirt

I am making a relationship query with multiple Objects IDs and receiving multiple related record groups. I can access the Object IDs for the related records but I don't know how to access the actual records for that ID. Is there an example on how to access related record groups and its records?

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

Accepted answers

AnikaHirt

Using the executeRelationShipQuery on a queryTask an object with the related record groups is returned. The OIDs can be used as a key to then get to the object Ids (or whatever is needed) within the related record groups. This is how I did it:

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">
var</SPAN> query <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> new RelationshipQuery(); 
query.outfields; 
query.objectids [queryIds]; // multiple Ids e.g. [105,106,233]
query.relationshipId = 2;

queryTask.executeRelationshipQuery(query, function(realtedRecordsGroups)){
&nbsp;&nbsp;&nbsp;allRelatedRecordsIds = [];
&nbsp;&nbsp;&nbsp;for(var obid in relatedRecordsGroups){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;allRelatedRecordsGroups.push(results.features<I>.attributes.OBJECTID);
&nbsp;&nbsp;&nbsp;}
});</I>var queryTask = new QueryTask("http//...");

All comments

RobertScheitlin__GISP

Anika,

Have you seen this sample?

Query and edit related records | ArcGIS API for JavaScript 3.23

AnikaHirt

Thanks Robert for taking a look at it. I'm actually using executeRelationshipQuery on a queryTask but even then is the example really feeding multiple ObjectIDs into the query? I'm looking at line 151: relatedQuery.objectIds = [graphicAttributes.objectid];

RobertScheitlin__GISP

Anika,

No that sample is just querying one ObjectId. But Querying multiple is supported you just use the OID i=as the array key when going through the returned results (as the sample does show).

AnikaHirt

Robert,

Sure, I can query for multiple but I need an example how I can actually access the result. I am able to get the keys but not the actual related record group records. So I was hoping to see if it is done somewhere to get a better understanding.

RobertScheitlin__GISP

Anika,

The sample I provided show how to get the results from the related query based on the OID. So if you have queried for multiple OIDs then you just use one of those OIDs to get the related records from the results.

incidentLayer<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>
&nbsp; <SPAN class="keyword token">var</SPAN> fset <SPAN class="operator token">=</SPAN> relatedRecords<SPAN class="punctuation token">[</SPAN>graphicAttributes<SPAN class="punctuation token">.</SPAN>objectid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

So in line 2 above the results for one specific OID is returned based on using that OID as the key in the relatedRecords array from the relates query. The fset is an array of feature that are related to the OID.

AnikaHirt

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">
var</SPAN> query <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> new RelationshipQuery(); 
query.outfields; 
query.objectids [queryIds]; // multiple Ids e.g. [105,106,233]
query.relationshipId = 2;

queryTask.executeRelationshipQuery(query, function(realtedRecordsGroups)){
&nbsp;&nbsp;&nbsp;allRelatedRecordsIds = [];
&nbsp;&nbsp;&nbsp;for(var obid in relatedRecordsGroups){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;allRelatedRecordsGroups.push(results.features<I>.attributes.OBJECTID);
&nbsp;&nbsp;&nbsp;}
});</I>var queryTask = new QueryTask("http//...");

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.