topic Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values? in ArcGIS Online Developers Questions

Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Tue, 28 Jan 2020 16:29:00 GMT

I successfully used https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2018/12/10/overlapping-features-in-pop-ups-quick-introduction-to-using-featuresets-with-arcade in two separate scripts to combine two surveys with the same feature layer points. I am getting the results I desire separately. So now I want to add a third piece and that is a conditional - IF A doesn't exist then return B else return A.

However I have some code and it is trying to return the entire feature class and I can't seem to pull just one field from the feature class. (see Script 3) NOTE: I am relatively new to Arcade so I may be going about this all wrong.

Here are the two scripts that are pulling the info I want:

Script 1: var intersectLayer =Intersects(FeatureSetByName($map,"BowersTransactions"), $feature)

for (var f in intersectLayer){
return f.feno2
}

Script 2: var intersectLayer =Intersects(FeatureSetByName($map,"BowersInspections"), $feature)

for (var f in intersectLayer){
return f.extinguisherno
}

Script 3: var inspfe =Intersects(FeatureSetByName($map,"BowersInspections"), $feature)
var transfe =Intersects(FeatureSetByName($map,"BowersTransactions"), $feature)

if (isEmpty(transfe))
{return inspfe;}
else {return transfe;}

Script 3 doesn't error out it tries to display all 20 or so fields. So it won't allow me to add it to a popup since it is too much information. I included the result from Script 3.

I thought briefly that FeatureSetByID might narrow this down to one field which is what i want however the little bit of reading I have done on that function seems to indicate that it uses arrays and I am just trying to pull the data from a field if it exists.

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Sun, 12 Dec 2021 03:19:39 GMT

Hi Adam Levine ,

A couple of comments and questions as to what you are doing:

The first and second expression will intersect and loop through the intersecting features and return an attribute of the first one.
Do you want to return a single result? Like the first feature in the intersect?
The third expression returns a featureset and that won't display in the pop-up. Not sure either is the IsEmpty will work in this case. I would normally use the count function to see if there are any results.

See below an example of what you can do, just returning one field based on what you described:

var result = "";
var transfe =Intersects(FeatureSetByName($map,"BowersTransactions"), $feature);
if (Count(transfe)==0) {
    // no BowersTransactions
    var inspfe =Intersects(FeatureSetByName($map,"BowersInspections"), $feature);
    if (Count(inspfe)==0){
        // BowersInspections either
        result = "No results found";
    } else {
        // just BowersInspections
        result = First(inspfe).extinguisherno;
    }
} else {
    // BowersTransactions found, don't check BowersInspections
    result = First(transfe).feno2;
}

return result;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Thu, 30 Jan 2020 15:38:43 GMT

Xander,

Thanks for your help....I tested this with a technician and it is close to what we are looking for but now I think we have to adjust for the latest transaction (based on a date field). So I will have to look at this document How to get attribute with last date modified from related table using Arcade perhaps as a guide?

Probably not this simple however can I create another variable (using some of the above code) that would be based on the Count being greater than 0?

Adam

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Thu, 30 Jan 2020 16:07:55 GMT

Hi adaml ,

The link you mentioned is a good start to get the most recent record from a related table. You mention that your requirement is more complex. If you can share more details, maybe I can give some more tips on how to do that.

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Thu, 30 Jan 2020 16:43:22 GMT

Xander,

Let me clarify - I need the last transaction extinguisher number instead of the intersect (it seems to be pulling up the first one) that is really the only change to what I am trying to do. If there isn't a transaction extinguisher number it should defer to the inspection extinguisher number. So, it is close to what I need.

I believe the article i posted wouldn't be applicable because I am not using a related table. Correct?

Adam

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Sun, 12 Dec 2021 03:19:41 GMT

Hi Adam Levine ,

Thanks for the clarification, although I still have a couple of questions. But first a note on the expression from the link you shared:

var relatedrecords = OrderBy(FeatureSetByRelationshipName($feature, "RelData"), "DateModified DES");
var cnt = Count(relatedrecords);

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

return relatedinfo;‍‍‍‍‍‍‍‍‍‍

Notice that on line 1 the data is sorted with the "OrderBy". As parameter "DateModified DES" is provided so it will order de records on the field DateModified in descending order. When you take the "First" (see line 6) it will take the most recent record according to the information stored in DateModified.

In case there are no related records you could include an else statement on line 8.

You mention that you are not using a related table. Do you have multi temporal data in the transaction table? If so, you should probably filter the layer first before sorting the data. Could you show the attribute table to see how it is structured?

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Fri, 31 Jan 2020 14:50:20 GMT

Xander,

I did a quick data export to Excel from the Survey123 Transaction Survey - so I have provided a screenshot of the fields and highlighted the date fields that I could use. I have also already filtered the transactions on 2020 - these are annual inspections however if there is any human error and they have to submit multiple transactions I would like the last extinguisher number to be used in the pop up based on the latest date. Hope that clarifies everything.

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Fri, 31 Jan 2020 16:17:21 GMT

Hi adaml ,

I' afraid that the export to Excel does not take all my doubts away. Do you have any repeats in you survey? Also the image shows the aliases created in the hosted featurelayer and the actual field names might be different. Is it possible to provide a screenshot of the attribute table of the hosted featurelayer with data in it?

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Fri, 31 Jan 2020 16:41:40 GMT

Xander,

It is tough to get a screenshot with the data only because there are so many fields - I have Notes being pulled into the Survey. I have included a screenshot with the actual field names. I also included a screenshot with the data containing the one date field that I created for this survey.

Thanks,

Adam

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Sat, 01 Feb 2020 02:19:06 GMT

Hi Adam Levine ,

Thanks for sharing. So your date field is called "adjdate", but what identifies the group of data you want to extract the latest from. Is that the Location ID (but in your screenshot that field appears to be empty)? I am assuming you have one layer and for a certain attribute of a feature you want to access the layer and all features that share that value and determine the latest date in the adjdate field and when found show a certain attribute. Is this the case. Sorry for all these questions, but based on two records it's kinda hard to know.

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Sun, 12 Dec 2021 03:19:44 GMT

Hi Adam Levine

To give you an idea of what the expression would look like:

var group_id = $feature["NameOfGroupField"];
var sql = "NameOfGroupField = '" + group_id + "'"; 
var records = OrderBy(Filter($layer, sql), "adjdate DES");
var cnt = Count(records);

var result = ""; // or fill with info when there is no data
if (cnt > 0) {
    var info = First(records);
    result = info.NameOfFieldWithInfoToShow;
}

return result;‍‍‍‍‍‍‍‍‍‍‍‍

The if statement is redundant because in the same layer you will always have at least 1 result.

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Mon, 03 Feb 2020 16:32:03 GMT

Xander,

Can I use some of the 'hidden' fields that are inherent with Survey123 for instance EditDate, and ObjectID or do I have to rely on the fields that I defined for the survey? Also, I have a filter on Location ID so that only those that pertain to the building in question are shown. So, Location ID would have to show up based on the filter if that can still be used as the group identification?

Adam

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Tue, 04 Feb 2020 06:40:47 GMT

Hi Adam Levine ,

Every field that is exposed in the layer should be available for use in the Arcade expression.

You can use the LocationID for filtering the data. I was just wondering if that was the field, since in the example records you showed the field is empty.

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Wed, 12 Feb 2020 14:41:11 GMT

Xander,

The 'group identification' would be LocationID. The screenshot that I sent you was my mistake. The LocationID wouldn't be blank on my map ever.

The code below is VERY close to what I need: (the only problem is if I submit another Transaction for that locationID then it is pulling the first one (that would be the 'first' piece of code correct?) IF I manually change the filter to an updated date range for the BowersTransactions featureset then this code does bring up the correct FE#) So, I need to figure out how to bring up the last result in the array, instead of the first.......am I understanding that correctly?

return result;

Thanks,

Adam

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Wed, 12 Feb 2020 21:27:01 GMT

Hi Adam Levine ,

In the example I posted earlier ("on Feb 1, 2020 8:33 AM"), line 3 contains and OrderBy specifying in this case that it will order the results using "adjdate DES" (order it on the field adjdate in descending order). If I do that and use the First, this will take the most recent record. In case you would change it to "adjdate ASC" and again use First, this will get the oldest record. So I think you are missing the OrderBy to assure you get the record you need to have.

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Mon, 17 Feb 2020 16:38:17 GMT

Xander,

Thanks again - I was looking at the post from Feb 1 and the code and your explanation make sense - I am just confused by the way I have things set up in this map so I am still trying to figure this out. Would I be able to get further assistance (screen share) from support or is this something that wouldn't be supported by the ESRI support call center?

Thanks,

Adam

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Mon, 17 Feb 2020 18:43:45 GMT

Hi Adam Levine ,

I am not sure if that is part of what is called support. In Colombia, the client would normally reach out to the sales executive or directly solution engineer to get some extra help with implementing these things. Do you have contact with your sales executive or solution engineer? If not, you could share the map and layer to a group and invite my ArcGIS Online user ("xbakker.spx") to that group and I could have a look if you want that and you are able to share the content with me .

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Tue, 18 Feb 2020 14:26:34 GMT

Xander,

I invited you to a group called ESRI Support in our organization and gave you access to the stuff I am working on.

Thanks again,

Adam

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

XanderBakker — Tue, 18 Feb 2020 14:57:08 GMT

Hi Adam Levine ,

Thanks for sharing the content. I received an error on the basemap not being available. Are you using a personalized basemap in the web map? If so, can you save a copy of the web map with a standard basemap? The error is causing the other layer(s) not to load and therefore I can't see any configurations (expressions) you may have applied to the layers.

If this is not the case, I will load the layers and revise the expression you have up to now and try and adapt it based on the data.

Re: Can I add a conditional statement in Arcade to display one of two FeatureSet script values?

AdamLevine — Tue, 18 Feb 2020 15:13:48 GMT

Xander,

Give it one more shot and then I will do it without the basemap if necessary.

Thanks,

Adam