topic Re: Arcade date return error in ArcGIS Online Developers Questions

Arcade date return error

ScottStepro1 — Fri, 06 May 2022 17:23:20 GMT

Good morning,

New to Arcade and was able to borrow and modify this statement from others to pull last date returns from related tables.

Background: This is used to pull last dates from two different tables and display them in the a popup, one table is for collections, the other is for assessments. This data is used in field to record garbage collection activities and assess overall cleanliness of a stretch of road.

What it does: The script looks at the table, find the last record date of a selected segment and if none found, return the text "none to date".

Issue: As you can see from the screen shots attached, It works like a champ for the collections table but not for the assessment table and not sure why. (tables and images attached for reference)

Only noticeable difference in the tables (to me): The collection table has finish and start date fields and attachments enabled whereas the collection table only has a single date field and no attachments. Layer and tables were created, related and shared to AGOL via ArcMAP.

COLLECTION

var relRec = orderby(FeatureSetByRelationshipName($feature,"Collections"), "FinishTime DES");
var cnt = Count(relRec);
var relatedInfo = "";
if (cnt>0) { var info = First(relRec);
relatedInfo = Text(ToLocal(info.FinishTime),"MM/DD/Y");
} else var relatedInfo="None To Date";

return relatedInfo;

ASSESSMENT

var relRec = orderby(FeatureSetByRelationshipName($feature,"Assessments"), "AssessDate DES");
var cnt = Count(relRec);
var relatedInfo = "";
if (cnt>0) { var info = First(relRec);
relatedInfo = Text(ToLocal(info.FinishTime),"MM/DD/Y");
} else var relatedInfo="None To Date";

return relatedInfo;

Scratching my head...

Re: Arcade date return error

jcarlson — Fri, 06 May 2022 14:34:21 GMT

What is the expression for the assessments?

Re: Arcade date return error

ScottStepro1 — Fri, 06 May 2022 17:24:55 GMT

That would help indeed...

UPDATED ABOVE

Re: Arcade date return error

ScottStepro1 — Fri, 06 May 2022 17:29:03 GMT

Found it! See bold...

var relRec = orderby(FeatureSetByRelationshipName($feature,"Assessments"), "AssessDate DES");
var cnt = Count(relRec);
var relatedInfo = "";
if (cnt>0) { var info = First(relRec);
relatedInfo = Text(ToLocal(info.FinishTime),"MM/DD/Y");
} else var relatedInfo="None To Date";

Re: Arcade date return error

jcarlson — Fri, 06 May 2022 17:32:02 GMT

Hm. I figured they were probably pretty similar. The only thing I can figure is that there's some error happening earlier in the expression. Since you initially set the relatedInfo variable to an empty string, maybe that's what is being returned?

Try changing that third line to "var relatedInfo = 'test value'" and see if your popup returns that, or if it's truly not returning anything at all.

Another idea is to include some Console commands in your expression to check the output. Maybe include Console(relRec) and Console(cnt) to see if your initial steps are returning what you expect.

Re: Arcade date return error

ScottStepro1 — Fri, 06 May 2022 17:43:52 GMT

I figured it out... totally overlooked changing the code in the text conversion in line 5 thanks for looking at it Josh

Re: Arcade date return error

jcarlson — Fri, 06 May 2022 17:51:18 GMT

Any time! Sometimes just sharing the problem makes it clearer to you, even if you end up figuring it out for yourself.