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

[Arcade] How to retrieve all values which has a common ID in another collumn ?

JasonBOCQUET

Hi,

I'm working sometimes on Arcade and i'm blocked by a point :

I have a table with some teams of people. Each people have a manager (the ID is MANAG001, MANAG002...).

Each people is represented by a point on a map.

I want by clicking on one of the people be able to see on the pop-up box all of the other people who have the same manager that the guy who I clicking on.

If I click on me, i'm able to see my manager is MANAG004 and i can see the other people who are managed by MANAG004 on a list or a table in the popup.

How can I do that with Arcade expression ?

I've read that Arcade does not support direct interaction with the clicked point’s ID; so maybe i can"t do that ?

thx 🙂

Find more posts tagged with

Accepted answers

jcarlson

No direct interaction, that's true, but pulling the values into a list and displaying the text is fine.

var fs = FeatureSetByName($map, 'people table', ['name', 'manager_id'], false)

// filter features for matching manager id
var filt_fs = Filter(fs, `manager_id = '${$feature['manager_id']}'`)

// loop through matches, create list
var match_arr = []
for (var f in filt_fs) {
  Push(match_arr, f['name'])
}

return Concatenate(match_arr, '\n')

This will spit out a list of names, each on their own line of text. Swap in your table / field names as needed, see how it works for you.

jcarlson

Put "Concatenate(match_arr, '\n')" in the text object at the end. You're putting the entire array into your HTML object, you don't really need to do that.

return {
  type: 'text',
  text: Concatenate(match_arr, '\n')
}

You could also try replacing \n with <br>.

jcarlson

Change your expression to use FeatureSetByPortalItem instead, that will go around the filter.

var fs = FeatureSetByPortalItem(
  Portal('your portal url'),
  'itemID of the layer',
  0, // or whatever the layer index is
  ['ets_siren', 'ets_date_creation'],
  false
)

All comments

jcarlson

No direct interaction, that's true, but pulling the values into a list and displaying the text is fine.

var fs = FeatureSetByName($map, 'people table', ['name', 'manager_id'], false)

// filter features for matching manager id
var filt_fs = Filter(fs, `manager_id = '${$feature['manager_id']}'`)

// loop through matches, create list
var match_arr = []
for (var f in filt_fs) {
  Push(match_arr, f['name'])
}

return Concatenate(match_arr, '\n')

This will spit out a list of names, each on their own line of text. Swap in your table / field names as needed, see how it works for you.

JasonBOCQUET

Maybe i miss something because it's not working already.

It seems to miss a ")" in your line 4 and i don't understand on the line 4 what does mean "

Filter(fs, `manager_id = '${$feature['manager_id']}'`

why there is duble ${$ ?

jcarlson

Ah, you're right, there should be a closing parenthesis on that line. I'll edit the original post.

The filter statement is using a template literal, a kind of text string where you can insert values into it using ${…}. Anything inside the brackets evaluates as code, and is included in the output text. This expression, for instance:

var x = 'cool'

return `Arcade Expressions are ${Upper(x)}`

Would spit out the text "Arcade Expressions are COOL".

There's a second "$" because that's how we tell Arcade to get the current $feature to access its attributes.

JasonBOCQUET

Ok so I try with my data :

var fs = FeatureSetByName($map, "Effectifs Société", ['$feature.ets_date_creation', '$feature.siren'], false)
var filt_fs = Filter(fs, `$feature.siren = '${$feature['$feature.siren']}'`)

var match_arr = []
for (var f in filt_fs) {
  Push(match_arr, f['$feature.ets_date_creation'])
}
return Concatenate(match_arr, '\n')

but it return nothing again.

JasonBOCQUET

@jcarlson i find how can i see the results, but it seems to show me only one result. He do not reach to have the others line with the same ID's

var fs = FeatureSetByName($map, "Effectifs Société", ['ets_date_creation', 'ets_siren'], false)
var filt_fs = Filter(fs, `ets_siren = '${$feature['ets_siren']}'`)

var match_arr = []
for (var f in filt_fs) {
  Push(match_arr, f['ets_date_creation'])
}
Concatenate(match_arr, '\n')
var HTML = ""
HTML += "<p style='text-align: center; line-height: 0.1;'><strong><span style='font-size: 30px; font-family: Calibri, sans-serif; color: rgb(1, 42, 132);'>"+match_arr+"</span></strong></p>"


return { 
	type : 'text', 
	text : HTML
}

sometime i got 2 times the name of the people concerned by the popup, but i never seen the other people appears.

jcarlson

Put "Concatenate(match_arr, '\n')" in the text object at the end. You're putting the entire array into your HTML object, you don't really need to do that.

return {
  type: 'text',
  text: Concatenate(match_arr, '\n')
}

You could also try replacing \n with <br>.

JasonBOCQUET

Great, your solution work too.

Thanks for your help. Any idea of why I can"t see other people ? Actually he show me only the people which i click on, it's not very interesting.

I miss something to make the other rows with the same ID in my popup ?

jcarlson

I'm not sure I understand. The way it's written, any row with the same ID will be included in the filtered set. Are you testing this against an ID that you know has more than one feature with that value?

JasonBOCQUET

@jcarlson Ok i find why it make a problem. My map is filtered to appears only one type of people (they are classified in 2 under-class).

That's why i do not see other one on the pop-up box, it's because they don't appears on the map.

it's not possible to get they're information (from the second under-class that i don't show on my map) on the pop-up box without show them on the map ?

jcarlson

Change your expression to use FeatureSetByPortalItem instead, that will go around the filter.

var fs = FeatureSetByPortalItem(
  Portal('your portal url'),
  'itemID of the layer',
  0, // or whatever the layer index is
  ['ets_siren', 'ets_date_creation'],
  false
)

JasonBOCQUET

Oh great, it works very well !

Big thanks for your help.

I'm gonna see now if I can integrate this kind of results in a charts to make it more beautiful in term of visualization.

JasonBOCQUET

Hi @jcarlson i want to know if it possible to ameliorate the code.

Because we are using this line

var match_arr = []

The result's rendering is like : ["Agence User","FTO User","Workplace User","IT User"]

it's not very aesthetic, i want to set more code around this to make the result more "friendly user"

In another case I use a code to retrieve a list of transaction provided by a relationship class, here is the code :

var transactionsinv = FeatureSetByRelationshipName($feature,"SDE.TRANSACTIONS_INV")
var info3 = ''
for (var f in transactionsinv){
    info3 += `<div style='text-align: left;'><span style='font-size: 16px; font-family: Calibri, sans-serif; color: rgb(1, 42, 132);'>
        <b>Date : </b>${DefaultValue(f.TRA_TRIMESTRE,'')} ${DefaultValue(Text(f.TRA_DATE,'Y'), 'Pas de date de transaction recensée')}<br>
        <b>Acquéreur : </b>${iif(isEmpty(f.TRA_ACQUEREUR), "Pas d'acquéreur recensé", f.TRA_ACQUEREUR)}<br>
        <b>Surface : </b>${iif(isEmpty(f.TRA_SURFACE),'Pas de surface rencensée', Text(Round(f.TRA_SURFACE,0),'#,###')+" m²")}<br>
        <b>Montant : </b> ${iif(IsEmpty(f.TRA_MONTANT),'Pas de montant recensé',f.TRA_MONTANT)+ " M€"}<br>
        <br></div>`
}

var newVariable3 = iif(isempty(info3),"Pas de transactions",info3);

HTML += "<p style='text-align: left;'><span style='font-family: Calibri, sans-serif; font-size: 16px; color: rgb(1, 42, 132);'>"+newVariable3+"</span></p>"

It is possible to change the line var match_arr = [] to be emancipated from the table side rendering ?

I want to get closer to the rendering that the code above gives me

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.