topic Re: Obtaining Record Attributes from a Hosted Table to Display in Feature Layer Pop-up with Arcade Expression in ArcGIS Online Questions

Obtaining Record Attributes from a Hosted Table to Display in Feature Layer Pop-up with Arcade Expression

HebahFarrag — Sat, 01 Apr 2023 07:42:46 GMT

I'm having trouble figuring out how to retrieve a field from a standalone hosted table and show it in the pop-up of a hosted feature layer. Can anyone assist?

Data Item Overview:
exemplar_list_testing (hosted feature layer)

exemplar_publication_testing (hosted table)

I aim to display the 'paragraph_description' field in the feature layer pop-up from the hosted table.

Current Arcade Expression:

var ExemplarListID = $feature.UniqueID; var ExemplarPublicationGID = "ExemplarListID = @ExemplarListID"; var ExemplarPublications = FeatureSetByName($map, "exemplar_publication_testing"); var RelatedData = Filter(ExemplarPublications, ExemplarPublicationGID); var popupstring = ""; for (var ExemplarPublication in RelatedData){ popupstring += "Paragraph Description: " + ExemplarPublication.Paragraph_Description + TextFormatting.NewLine; } popupstring += TextFormatting.NewLine; return popupstring;

Re: Obtaining Record Attributes from a Hosted Table to Display in Feature Layer Pop-up with Arcade Expression

ChristopherCounsell — Mon, 03 Apr 2023 07:22:19 GMT

There is an issue with the expression in the second line:

var ExemplarPublicationGID = "ExemplarListID = @ExemplarListID";

This line is setting the variable ExemplarPublicationGID to a string, which contains the literal text "ExemplarListID = @ExemplarListID". This is not a valid Arcade expression and will not evaluate correctly.

Instead, the expression should reference the variable ExemplarListID directly, like this:

var ExemplarPublicationGID = "ExemplarListID = '" + ExemplarListID + "'";

This sets ExemplarPublicationGID to a string that contains the value of ExemplarListID, enclosed in single quotes. This will allow the expression to be used as a filter in the Filter function.

Re: Obtaining Record Attributes from a Hosted Table to Display in Feature Layer Pop-up with Arcade Expression

KenBuja — Mon, 03 Apr 2023 13:03:55 GMT

You can use variable substitution (see the Filter help) like that, shown here:

Re: Obtaining Record Attributes from a Hosted Table to Display in Feature Layer Pop-up with Arcade Expression

KenBuja — Mon, 03 Apr 2023 13:08:18 GMT

There is no ExemplarListID field in the exemplar_publication_testing table. Your sql expression should be

var ExemplarPublicationGID = "UniqueID = @ExemplarListID";

Re: Obtaining Record Attributes from a Hosted Table to Display in Feature Layer Pop-up with Arcade Expression

ChristopherCounsell — Mon, 03 Apr 2023 23:13:48 GMT

var ExemplarPublicationGID = "UniqueID= '" + ExemplarListID + "'";