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 it possible to use Arcades Intersects() function to filter dynamic text

LindsayRaabe_FPCWA

I'd like to add some dynamic text to a layout that returns attribute values from a layer, but instead of returning all values, visible values or values from an expression, I would like to try write an arcade expression that only returns values where the source layer intersects with another layer which has a filter applied to it. My example would be returning Lot numbers from a Land Parcel layer for lots that have plantation areas on them, and not the neighbouring lots.

I've tried using Intersects() and the $map and $datastore profiles to lookup my plantation layer, but my understanding is the dynamic text doesn't recognise the $map profile and the $datastore profile only returns layers in a feature service.

I've also looked at including a dynamic table, but I can't format that to read as text, and also can't remove duplicate values.

Find more posts tagged with

Desktop

Accepted answers

JohannesLindner

Ah, and the spatial join doesn't update, didn't know that. OK, then let's try doing it in Dynamic Text and Arcade.

I've tried using Intersects() and the $map and $datastore profiles to lookup my plantation layer, but my understanding is the dynamic text doesn't recognise the $map profile and the $datastore profile only returns layers in a feature service.

Correct, the Arcade Layout profile doesn't recognize the $map global (which is a bit weird, because you specify the map frame you want to extract the table attribute from). But $datastore will work as long as Plantations and Lots are in the same database / feature service.

This will list all Lots numbers (TextField1 in my layer) intersected by Plantations (note that you insert a table attribute for the plantation layer):

var lots = FeaturesetByName($datastore, "Lots")
var i_lots = Intersects($feature, lots)
var lot_names = []
for(var lot in i_lots) {
    Push(lot_names, lot.TextField1)
}
return Concatenate(lot_names, ", ")

This works fine if you have only one plantation:

With multiple plantations on different lots, the lot numbers will be unsorted:

With multiple plantations on the same lots, the lot numbers will be duplicated:

All comments

JohannesLindner

Aren't you describing a Spatial Join?

add a Spatial Join to your Lots layer (intersect with Plantation layer, keep all features)
This will add a column "Join_Count"
in the layout, add a table frame for the joined Lots layer, filter by Join_Count

LindsayRaabe_FPCWA

Correct, and I would do this if it were a one off project - my desire is to create an automated solution for a template which can be opened, a definition query set for a plantation, zoom to the plantation and the layout information updates automatically based on the returned information. We have dynamic text returning simple information from visible rows of that layer (i.e. Plantation Name), but this obviously extends to other layers that we want to return information for, but require further filtering beyond the simple "Visible Rows" setting.

JohannesLindner

Ah, and the spatial join doesn't update, didn't know that. OK, then let's try doing it in Dynamic Text and Arcade.

I've tried using Intersects() and the $map and $datastore profiles to lookup my plantation layer, but my understanding is the dynamic text doesn't recognise the $map profile and the $datastore profile only returns layers in a feature service.

This will list all Lots numbers (TextField1 in my layer) intersected by Plantations (note that you insert a table attribute for the plantation layer):

var lots = FeaturesetByName($datastore, "Lots")
var i_lots = Intersects($feature, lots)
var lot_names = []
for(var lot in i_lots) {
    Push(lot_names, lot.TextField1)
}
return Concatenate(lot_names, ", ")

This works fine if you have only one plantation:

With multiple plantations on different lots, the lot numbers will be unsorted:

With multiple plantations on the same lots, the lot numbers will be duplicated:

LindsayRaabe_FPCWA

Thanks for your explanation. I've accepted it as the solution, because I'm sure it works as you've stated - just not in my particular case as the 2 layers are not in the same database. Will think on it some more to see if I can work around that, but for now, will accept a manual step in my map automation process! I'm sure this code will still prove useful in the future!

LukeGilner1

Hi @LindsayRaabe_FPCWA - curious if you ever found a solution to this? I have a very similar scenario and the 2 AGOL hosted layers are not in the same database.

LoganShank

This is crucial functionality that is currently missing from layouts. Prior to 3.5, I was able to leverage $datastore to at least aggregate and manipulate data from within my database/service to customize text elements on my layout. However this functionality that has worked perfectly for years was removed with the latest update.

Here is a recent idea that was made to add $datastore and $map back into the Layout profile. I have never quite understood why $map was not an option considering your layout is driven by a map and you have to specify a map before you can add a dynamic text element.

Idea: Arcade - Add $datastore and $map to the Layout Profile

$datastore was recently removed in the layout profile.

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.