topic Arcade Popup Filter by Feature Variable in ArcGIS Online Questions

Arcade Popup Filter by Feature Variable

MeleKoneya — Thu, 16 Feb 2023 17:17:04 GMT

I am trying to to filter a table in the new Map Viewer and show the filtered records in a popup. I have a fire incident map feature with associated units in the table.

This code only works if I put in the incident_number explicitly.

var incident = $feature.incident_number

incident = 23069675

var u = FeatureSetByName($map, "PFD CAD Calls - Units", ['incident_number', 'unit_id'])

var codeStatement = 'incident_number = @incident';

Console(incident)

var us = Filter(u, codeStatement)

Console(Count(us))

var popupString = 'Units:';

for(var x in us)

{

popupString += Text(x.unit_id)

}

return {

popupString

}

Re: Arcade Popup Filter by Feature Variable

JohannesLindner — Thu, 16 Feb 2023 18:59:32 GMT

To post code:

Try doing a null check:

var incident = $feature.incident_number if(incident == null) { return "No Incident number!" } var u = ...

Re: Arcade Popup Filter by Feature Variable

MeleKoneya — Sat, 18 Feb 2023 16:17:31 GMT

I was able to get this working. Not sure why I was having issues before.

var incident = $feature.incident_number

Console(incident)

if(incident == null) { return "No Incident number!" }

var u = FeatureSetByName($map, "Unit Status", ['incident_number', 'unit_id'])

var codeStatement = 'incident_number = @incident'

Console(codeStatement)

var us = Filter(u, codeStatement)

OrderBy(us, 'unit_id ASC')

Console(Count(us))

var Units = ""

for(var x in us)

{

Units += Text(x.unit_id) + TextFormatting.NewLine

}

return {

Units

}

Re: Arcade Popup Filter by Feature Variable

JohannesLindner — Sun, 19 Feb 2023 08:46:31 GMT

You had issues before because you didn't have the null check.

When IncidentNumber is null, codeStatement will be "incident_number = ". That is an invalid sql statement, so the Filter() function will fail.

When the Arcade expression is validated, it uses default values (I think, not too sure about that. @jcarlson ?), so the expression didn't get validated because it raised an error, until you set incident to a non-null value.

With the null check I suggested, you return a default response if the IncidentNumber is null. When you return from a script, the rest of the script isn't executed anymore, so Filter() doesn't get a chance to raise an error, so the expression validates.

Re: Arcade Popup Filter by Feature Variable

jcarlson — Tue, 21 Feb 2023 14:57:39 GMT

I think it depends on where you test the expression. In Pro, I often get the green check mark for a valid expression, but there's actually invalid data in the table that throws an error somewhere further down. But I can test the same expression in a web context and get the error identified right away, so I would guess there is something going on with default values. Hard to fully observe it, though.