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

Custom Attribute Expression in ArcGIS Online to Show Related Table Information

KieranClark

I have a map that shows international submarine cables and their landing points around the world. I have a standalone table added to my map that lists all the landing points and what cables they are associated with like so:

My list of landings is unique City/State/Country names and it's possible for more than one cable system to come to a single landing. What I want to do - and I think I have all the correct tables and data needed for this - is to create an attribute expression so that when someone clicks on a Landing Point it shows all the Cable Systems associated with that landing. Fortaleza, for instance, is associated with 14 cable systems.

I was able to do something similar in ArcGIS Pro using a Relate but I'm trying to figure out how to do the same thing in my web map. Basically what I need to do is match the "Name" field from my Landing Points layer to the "Cable_Landings_Export.City" field in my standalone table and then add all the cable system names from the "All_Cables_Table_Export.SystemName" field as a list, preferably bulleted or something and not a comma separated list.

I'm not a coder so I'm a little lost trying to work with Arcade and not sure where I should even start.

Find more posts tagged with

Accepted answers

All comments

KieranClark

Yes, the following has returned the field not found error:

var cityname = $feature["STF_Cable_DBO_tblLanding_City"]; // read out the city
var sql = "Cable_Landings_Export_City" + " = " + cityname; // create query
var table = FeatureSetByName($map, "LandingPlusCableTable"); // get access to table
var related_records = Filter(table, sql); // filter the table for relevant records

var cnt = Count(related_records); // determine the number of records found

var result = "";
if (cnt == 0) {
    // no records found
    result = "No cable systems found";
} else {
    // we have related records, let's create the text to return
    result = cnt + "cable system(s) found:";
    for (record in related_records) {
        txt = TextFormatting.NewLine + " - " + All_Cables_Table_Export_SystemName; // use the correct field name from the table
        result += txt;
    }
}

return result;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>

Sorry, how do you get it to post with all the nice color coding and such like you had?

XanderBakker

Hi kclark_SubTelForum ,

Can you also post the code you tried?

KieranClark

Thanks so much for this, this is definitely a great start.

However, I keep getting "Field not found" errors and I'm not really sure what to do as it's not highlighting where things are going wrong. Let me describe the tables/layers I'm using a little more in detail with the field names.

The standalone table that has landings linked to each cable is named "LandingPlusCableTable" and has the following fields:

Cable_Landings_Export_City - This contains the name of the city where cables land.

Cable_Landings_Export_State_Province - The state or province where the city is located, shouldn't be relevant to this

Cable_Landings_Export_Country - The country where the city is located, shouldn't be relevant to this

All_Cables_Table_Export_OBJECTID - This field contains the CableID that is the unique identifier for each record in our submarine cable database.

All_Cables_Table_Export_SystemName - This field contains the name of the cable system that lands at the city

My Landing Points feature is structured as follows:

"STFLandings20180529_JOIN"

The only relevant field here should be the one that is pulled the City name: "STF_Cable_DBO_tblLanding_City" which has the alias "City"

Please let me know if you need additional information.

XanderBakker

Hi Kieran Clark ,

There are a couple of things you will need to do in the expression. I assume that you have a point featureclass with the landing points and the name of the city:

Read out the name of the city of the landing point the user clicked on
Get access to the table of LandingPlusCableTable
Create a query using the name of the city
Use a filter to get all the related records from the table
Loop through the resulting records and construct a string with all the information you want to present

The code could look like this, but you will have to adjust the table name and fields to match your data:

<SPAN class="keyword token">var</SPAN> cityname <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"City Field Name"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// read out the city</SPAN>
<SPAN class="keyword token">var</SPAN> sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"City_Field_Name_in_table"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" = "</SPAN> <SPAN class="operator token">+</SPAN> cityname<SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// create query</SPAN>
<SPAN class="keyword token">var</SPAN> table <SPAN class="operator token">=</SPAN> <SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Exact name of table as used in the map"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// get access to table</SPAN>
<SPAN class="keyword token">var</SPAN> related_records <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// filter the table for relevant records</SPAN>

<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>related_records<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// determine the number of records found</SPAN>

<SPAN class="keyword token">var</SPAN> result <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>cnt <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="comment token">// no records found</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"No cable systems found"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="comment token">// we have related records, let's create the text to return</SPAN>
    result <SPAN class="operator token">=</SPAN> cnt <SPAN class="operator token">+</SPAN> <SPAN class="string token">"cable system(s) found:"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN>record <SPAN class="keyword token">in</SPAN> related_records<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        txt <SPAN class="operator token">=</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine <SPAN class="operator token">+</SPAN> <SPAN class="string token">" - "</SPAN> <SPAN class="operator token">+</SPAN> record<SPAN class="punctuation token">.</SPAN>systemname<SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// use the correct field name from the table</SPAN>
        result <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> txt<SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> result<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>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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