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 pop-up

DEI

Hi all,

I'm trying to use an Arcade expression in my web map pop-up to list the most current inspection reading for a point. I have a set of location points with a related 1:M inspection table which includes numerous readings per point (with dates) recorded over the last several months. This is what I have:

var Ra=(FeatureSetByRelationshipName($feature,"Bal2021"));
var Rb=Reverse([Ra]);

return First(Rb);

Test returns the entire array in chronological order. Can anyone please suggest how I could display just the most current reading?

Vind meer berichten getagd met

Mapping

Arcade

Accepted answers

DEI

In case anyone else may need it, I was able to figure out a solution by following along with this post and making some modifications. Here's what I ended up with:

var Ra = OrderBy(FeatureSetByRelationshipName($feature,"Bal2021"), "Date_Time DESC");

var cnt = Count(Ra);

if (cnt > 0) {

var Rb = First(Ra).RaDe;

} else var Rb= "";

return Rb;

All comments

jcarlson

Reverse returns an Array. What you probably want is OrderBy, which will return a FeatureSet. Calling First on the FeatureSet will give you the individual features.

var Ra = FeatureSetByRelationshipName($feature, "Bal2021");
var Rb = OrderBy(Ra, 'your-date-field DESC');

return First(Rb);

Also, this will just return a single Feature. If you're looking for a reading value, you would need to access that specifically.

First(Rb)['reading-value-field']

DEI

That was fast – thanks!

I tried your suggestion but the Test returns the first reading from
January. I would like to display the last reading from June. I think what
I’m looking for is something like a ‘Last’ or ‘Reverse’ function to call on
the FeatureSet.

jcarlson

Hm. Could you paste a sample of the Ra FeatureSet? And also the Rb FeatureSet you're getting when you attempt to sort it?

DEI

Please see the attached screenshots.

DEI

In case anyone else may need it, I was able to figure out a solution by following along with this post and making some modifications. Here's what I ended up with:

var Ra = OrderBy(FeatureSetByRelationshipName($feature,"Bal2021"), "Date_Time DESC");

var cnt = Count(Ra);

if (cnt > 0) {

var Rb = First(Ra).RaDe;

} else var Rb= "";

return Rb;

DEI

I'm trying to display quarterly inspection results in my pop ups but it's proving to be more difficult than I thought. Here's an example:

var tbl = Orderby(FeatureSetByRelationshipName($feature,"Day10Rem"), "Rem10Date");
var tbc = OrderBy(FeatureSetByRelationshipName($feature,"Day10Rem"), "Rem10Conc");
var Qc = IIf(tbl >= Date(2021,6,1) && tbl < Date(2021,10,1), "Rem10Conc", "");
return Qc

Could anyone please point me in the right direction or offer suggestions?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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