topic Re: Feature Info Widget - Related Inspection Table Sorting by Most Recent Date. Not Possible? in ArcGIS Experience Builder Questions

Feature Info Widget - Related Inspection Table Sorting by Most Recent Date. Not Possible?

ArmstKP — Wed, 28 Sep 2022 14:56:37 GMT

I created a feature info widget that is my related table. The feature's related table is sorted by the date descending in the web map, but that setting seems to be not honored when it is brought into ExB when I click on a feature. The oldest record shows up first with an arrow to scroll to the newer record, which can be fairly annoying if there are a lot of inspections on a feature and you want to see the latest inspection first, while also wanting to see the rest....

Re: Feature Info Widget - Related Inspection Table Sorting by Most Recent Date. Not Possible?

JessicaRamirez1 — Mon, 10 Oct 2022 18:04:18 GMT

I used an arcade expression to solve this issue. In this script, I'm only returning the latest result so you'll have to edit that. I hope this helps

var relatedrecords = OrderBy(FeatureSetByRelationshipName($feature,"myFeatureLayer"), 'Effective_Date DESC');
var cnt = Count(relatedrecords);

var relatedinfo = "";
if (cnt > 0) {
var info = First(relatedrecords);
relatedinfo = Text(ToLocal(info.Effective_Date), "MM/DD/Y");
}

return relatedinfo;

Re: Feature Info Widget - Related Inspection Table Sorting by Most Recent Date. Not Possible?

Wei_Ying — Wed, 21 Dec 2022 22:43:30 GMT

Hi @ArmstKP ,

Thanks for sharing your problem.
The sorting you saved in the map is not honored into FeatureInfo, it only honors the popup setting. So one workaround is like @JessicaRamirez1 suggested using an arcade expression. Or inside ExB, at the datasource, you can create a data view of this related table to sort on select field and then use it in FeatureInfo.

Re: Feature Info Widget - Related Inspection Table Sorting by Most Recent Date. Not Possible?

ArmstKP — Thu, 04 Jan 2024 18:42:16 GMT

@JessicaRamirez1 I have used scripts like this before, but where did you add the script/expression in ExB?

Re: Feature Info Widget - Related Inspection Table Sorting by Most Recent Date. Not Possible?

JessicaRamirez1 — Fri, 05 Jan 2024 16:47:26 GMT

@ArmstKP I configured the layers pop-up in the web map, the same web map that I added to EB. That's where the script lives, in the pop-up configuration option on the layer.