topic Re: Domains in Arcade in ArcGIS Online Questions

Domains in Arcade

NWEdisonTeam — Tue, 11 Aug 2020 19:45:06 GMT

I am trying to parse out a conditional expression for visually displaying locations in Arcade (Arcgis Online) that contains two domains and I am either A, not getting the resultant I want, or B getting an error, depending on how I structure it.

if (DomainName($feature,"WA") == 8/10/2020 - 8/16/2020 && DomainName($feature,"InSta") == 'To Be Installed') {Return 'Needs to Be Installed'}

This version returns null values. Any help would be appreciated!

Re: Domains in Arcade

KenBuja — Sat, 11 Dec 2021 07:41:06 GMT

Are the domain values for "WA" strings? If so, your syntax is incorrect

if (DomainName($feature,"WA") == "8/10/2020 - 8/16/2020" && DomainName($feature,"InSta") == 'To Be Installed') {
    Return 'Needs to Be Installed';
}‍‍‍‍‍‍

Otherwise, what are the values?

Re: Domains in Arcade

NWEdisonTeam — Tue, 11 Aug 2020 20:15:14 GMT

The domains are indeed strings. It is not a Date type column. Also the " " around "WA" should be ' '. Apologies.

Re: Domains in Arcade

KenBuja — Wed, 12 Aug 2020 14:20:10 GMT

Does adding the quotes around the date range help or are you still getting unexpected results?

Re: Domains in Arcade

NWEdisonTeam — Wed, 12 Aug 2020 14:24:57 GMT

Taking the quotes away on the date range makes it turn blue, which I am assuming is the code recognizing the Domain code/name. Removing the quotes from the 'To Be Installed' seems to nullify the expression and create an error. Otherwise, the expression will return no values which is wrong.

Re: Domains in Arcade

KenBuja — Wed, 12 Aug 2020 15:01:59 GMT

If I understand what you're saying, the colors change if the text is a string value (red), a function or number (blue), or part of the Javascript syntax (black). It isn't doing any compiling to recognize domain values. Are you able to supply screen shots of your expression and the data?

For example, here is one of the scripts I have that uses fields with domains. I'm not using the DomainName function, but just working with the codes. The field "Benthic Status" has three possible codes. If I click on the pencil icon for that field, it shows the codes and their names.

Re: Domains in Arcade

NWEdisonTeam — Wed, 12 Aug 2020 15:44:49 GMT

So in my code it is not recognizing that 'To Be Installed' Is a Code

Re: Domains in Arcade

KenBuja — Sat, 11 Dec 2021 07:41:09 GMT

You have to enclose any string values in quotes. You could either use "if/else" or the IIF function to also return values that don't meet your criteria.

if (DomainName($feature,'WA') == '8/10/2020 - 8/16/2020' && DomainName($feature,'InSta') == 'To Be Installed') {
    return 'Needs to Be Installed';
} else {
    return "Didn't meet criteria";
}

or

iif(DomainName($feature,'WA') == '8/10/2020 - 8/16/2020' && DomainName($feature,'InSta') == 'To Be Installed', 'Needs to Be Installed', "Didn't meet criteria");‍‍‍‍‍‍‍‍‍

Re: Domains in Arcade

NWEdisonTeam — Wed, 12 Aug 2020 16:12:50 GMT

That got it. Thanks you!

Re: Domains in Arcade

NWEdisonTeam — Wed, 12 Aug 2020 16:17:27 GMT

I noticed you used single quotes over the $feature,'Insta' and $Feature,'WA' vs my double quotes. Was that the issue?

Re: Domains in Arcade

KenBuja — Wed, 12 Aug 2020 16:37:13 GMT

No, they are interchangeable. Notice I had to use double quotes in the else return since the string contained a single quote.

Something like this works fine (from the Playground), but you try to be consistent

iif($feature.LASTEDITOR == "Esri", 'Yes', "No")‍‍‍

Re: Domains in Arcade

NWEdisonTeam — Fri, 14 Aug 2020 14:34:02 GMT

To Continue this, I am finding that the expanded code is not yielding the corresponding results. Any thoughts?

if (DomainName($feature,'InSta') == 'To Be Installed'){
if (DomainName($feature,'WA') == '8/10/2020 - 8/16/2020'){
return 'Priority 1 Install';
} else if (DomainName($feature,'WA') == '8/10/2020 - 8/16/2020'){
return 'Priority 2 Install';
} else if (DomainName($feature,'WA') == '8/24/2020 - 8/30/2020'){
return 'Priority 3 Install';
} else if (DomainName($feature,'WA') == '5/25/2020 - 5/31/2020'){
return 'Do Not Install'
} else {
return 'Installed';
}
}

Re: Domains in Arcade

KenBuja — Fri, 14 Aug 2020 14:57:29 GMT

One thing I notice is your first two date range if statements use the same range. What are you getting and what are you expecting? It is possible to see a snapshot of the data?

Re: Domains in Arcade

NWEdisonTeam — Fri, 14 Aug 2020 15:05:38 GMT

1. That code was wrong I mis-copied so apologies

2. I got it to work by changing the structure and just doing a bunch of else if clauses. See the screen shots below:

I was overly complicating it

Re: Domains in Arcade

AdamBakiera — Wed, 22 Dec 2021 21:13:07 GMT

I am having a similar issue. Here is my code:

var days = DateDiff(Now(), $feature["Inspected_Date"], "days");

if (days > 60 && days < 180 && $feature["Inspection_Status"] == 'Repair Needed') {
return "This was inspected between 2 and 6 months ago - Repair Needed";
}

if (days > 180 && $feature["Inspection_Status"] == 'Repair Needed') {
return "This was inspected more than 6 months ago - Repair Needed";
}

if (days < 60 && $feature["Inspection_Status"] == 'Repair Needed') {
return "This was inspected in the past 2 months - Repair Needed";
}

if (days > 60 && days < 180 && $feature["Inspection_Status"] == 'Passed') {
return "This was inspected between 2 and 6 months ago - Passed";
}

if (days > 180 && $feature["Inspection_Status"] == 'Passed') {
return "This was inspected more than 6 months ago - Passed";
}

if (days < 60 && $feature["Inspection_Status"] == 'Passed') {
return "This was inspected in the past 2 months - Passed";
}

I know for a fact the days variable and that logic works because that's the way our application is set up right now. We are just wanting to add that inspection status element.