topic Arcade Expression pulling from Related Records in ArcGIS Online Questions

Arcade Expression pulling from Related Records

CRBData1 — Tue, 24 Jan 2023 20:56:54 GMT

Hi all I need some help! This is my arcade expression which is resulting in all palms returning a 'Yes' value. Any clue what is wrong with my expression? Any help is appreciated.

Mahalo,

Meg

var reltbl = OrderBy(FeatureSetById($map, /* Individual Palm Damage Survey */ "Collector_Palms_9566"),"SurveyDate DES")
var cnt = Count(reltbl)

var sprdmg = ''
var borehls = ''
var inrfrnd = ''
var outfrnd = ''

if (cnt>0){
var info = First(reltbl);
sprdmg = info.SpearDamage;
borehls = info.BoreHoles;
inrfrnd = info.InnerFrondsDamaged;
outfrnd = info.OuterFrondsDamaged;

if(sprdmg == "No" && borehls == "No" && inrfrnd == "0" && outfrnd == "0"){
return "No"
}
if(sprdmg == NULL && borehls == NULL && inrfrnd == NULL && outfrnd == NULL){
return "Null"
}else {
return "Yes"
}
}

Re: Arcade Expression pulling from Related Records

KenBuja — Tue, 24 Jan 2023 21:13:57 GMT

Are the InnerFrondsDamaged and OuterFrondsDamaged fields numeric or text? If they're numbers, than your first if statement should be

if(sprdmg == "No" && borehls == "No" && inrfrnd == 0 && outfrnd == 0){

Re: Arcade Expression pulling from Related Records

jcarlson — Tue, 24 Jan 2023 21:15:31 GMT

Hard to tell, exactly, but the way this is written, your conditions have a few different "offramps".

If no values exist in the related table, it wouldn't return anything.
If those four fields are "No" or "0", it returns "No"
- Are the second two fields really strings? If they are integers, write it 'inrfrnd == 0'. Checking an integer field being equal to a string will guarantee that nothing will ever satisfy the condition.
If all the fields are null, it returns "Null". Nothing appears wrong with this condition, but you may want to try using IsEmpty(sprdmg) instead, on the off chance that a field has an empty string, which is not the same as a true null.
Else return "Yes"

My guess is that maybe point 2 is evaluating strings / integers, so it's always missed, and maybe you have empty strings, so point 3 is being missed as well?

Any chance this layer is public? It's always easier to diagnose issues with access to the data.

Re: Arcade Expression pulling from Related Records

crbdata — Tue, 24 Jan 2023 23:34:43 GMT

The two fields are strings and the other two are integers so I went with your suggestion writing it as infrnd == 0 instead. And even with just that first line of statement (removing the other lines) to test it, the value would result in Null so it must be a problem with that first line.

I found that if I made a label with a similar arcade expression instead of in the pop up, this worked and shows what palms are currently damaged vs. not.

Thank you all for your help and quick responses as well!