topic Re: Looking for a source which lists Arcade limitations across products? in ArcGIS Online Questions

Looking for a source which lists Arcade limitations across products?

Thomas_Z1 — Fri, 10 Dec 2021 20:22:42 GMT

I have an attribute expression using in a popup which is shown in a ArcGIS web map but not in a web app or in collector.

var relatedData = FeatureSetByName($datastore,"RelatedData")
var filteredRelatedData = Filter(relatedData, Concatenate("id=", $feature.id))
var orderedFilteredRelatedData = OrderBy(filteredRelatedData, 'date DESC')
var newest = First(orderedFilteredRelatedData)

if (IsEmpty(newest)) {
    "n/a"
}
else {
    var installDate = newest.date
    newest.name + " (" + Text(installDate, "Y-MM-DD HH:mm:ss") + ")"
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I have already resigned to the fact that this does not work in ArcGIS Collector. And now it seems that this is also not working in a web app. This is really frustrating.

However, I am looking for a web page or document which lists Arcade limitations across all ESRI products. Any idea where I do find something like that?

PS. I do know that above Arcade expression is not performant.

Re: Looking for a source which lists Arcade limitations across products?

Joshua-Young — Tue, 09 Jul 2019 19:29:52 GMT

The ArcGIS Arcade version matrix page on at the ArcGIS for Developers website states which Esri products support which version of ArcGIS Arcade. ArcGIS Online is not on the list but it should always support the latest version of ArcGIS Arcade.

Version Matrix | ArcGIS for Developers

On the ArcGIS Arcade function reference page when you click on a function it will tell you at what version of ArcGIS Arcade the function was introduced.

Arcade Function Reference | ArcGIS for Developers

It would be nice if the function reference page would just let you filter functions by version number to make it easier to see what you have to work with.

I hope this helps.

Re: Looking for a source which lists Arcade limitations across products?

MichaelVolz — Tue, 09 Jul 2019 20:22:56 GMT

Have you tried Arcade on other types of fields such as text or numeric fields? Maybe there is a limitation at this time with date/time fields.

Re: Looking for a source which lists Arcade limitations across products?

XanderBakker — Fri, 10 Dec 2021 20:22:45 GMT

Hi moosetraveller ,

What error are you seeing when you test the Arcade expression in the configuration window?

I would probably make some minor adjustments:

var relatedData = FeatureSetByName($datastore,"RelatedData");
var filteredRelatedData = Filter(relatedData, Concatenate("id=", $feature.id));
var orderedFilteredRelatedData = OrderBy(filteredRelatedData, "date DESC");
var newest = First(orderedFilteredRelatedData);

var result = "";
if (IsEmpty(newest)) {
    result = "n/a";
} else {
    var installDate = newest.date;
    result = newest.name + " (" + Text(installDate, "Y-MM-DD HH:mm:ss") + ")";
}
return result;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Are you sure that the data is related like this and not through an GlobalID? Because that would make the the query different. Also you can include some Console statements to see where the code fails.

Re: Looking for a source which lists Arcade limitations across products?

Thomas_Z1 — Tue, 09 Jul 2019 20:43:19 GMT

Hi Xander Bakker‌,

Thank you very much but the script works great on ArcGIS Online in a web map, returns no error in the configuration window and values are correctly shown in the popups. (I modified and anonymized this script for this forum.)

The problem is, that when creating a map app using MapApp Builder, the expression is not evaluated and blank fields are shown.

Re: Looking for a source which lists Arcade limitations across products?

XanderBakker — Tue, 09 Jul 2019 20:49:32 GMT

Hi moosetraveller ,

You mention "MapApp Builder", are you referring to the Web AppBuilder (WAB)? Where are you seeing the blank fields? In Collector (using iOS or Android?) or in the web app?

Re: Looking for a source which lists Arcade limitations across products?

Thomas_Z1 — Tue, 09 Jul 2019 20:51:45 GMT

Thank you Joshua Young‌, that helps already a lot!

It answers my question.

I found the following source but my understanding is that the web app we use runs with ArcGIS JS 3.29 aka newest version:

https://developers.arcgis.com/arcade/guide/faq/#why-doesnt-my-expression-work-in-my-web-app-but-it-does-in-arcgis-online

I have analyzed the source code of the web (map) app by using a developer console. It seems to be ArcGIS JS 3.29. Therefore, Arcade 1.7 should be supported according to the matrix. But it's actually not... or I miss something.

Re: Looking for a source which lists Arcade limitations across products?

Thomas_Z1 — Tue, 09 Jul 2019 20:59:42 GMT

Hi Xander Bakker‌,

Yes, I am referring to the Web AppBuilder.

Product	Arcade Script works?
Web Map (Viewer)	Yes
Web App (created with Web AppBuilder)	No
Collector App	No
Collector App (Early Access)	No

Re: Looking for a source which lists Arcade limitations across products?

Thomas_Z1 — Fri, 10 Dec 2021 20:22:48 GMT

Thank you Michael. It works as well with a simple count in a web map but not in Collector or a web app.

var relatedData = FeatureSetByName($datastore,"RelatedData")
var filteredRelatedData = Filter(relatedData, Concatenate("id=", $feature.id))
return Count(filteredRelatedData)‍‍‍‍‍‍‍‍‍‍‍‍

Re: Looking for a source which lists Arcade limitations across products?

XanderBakker — Wed, 10 Jul 2019 12:34:18 GMT

Hi Thomas Zuberbuehler ,

Are you using the WAB Dev edition or the standard one provided in ArcGIS Online?

I have used Arcade (FeatureSetBy, Filter, Intersects, Buffer, etc) and it all works as expected in the WAB of ArcGIS Online:

See also the description on how I created this provided here:

https://community.esri.com/docs/DOC-12773-using-featuresetby-functions-in-arcade-to-drill-down-to-other-layers-and-tables

I you have WAB Dev edition, have a look at the version and see if there are any updates.

Re: Looking for a source which lists Arcade limitations across products?

Thomas_Z1 — Wed, 10 Jul 2019 15:13:33 GMT

Thank you Xander Bakker‌!

It is working and I found out why it did not work.

The problem was a change in the related table's name.

Since I have never reloaded the web viewer (since all popup changes were applied immediately) it did still work. I assume that the web viewer looks once the ID up using the layer's name and works with that ID afterwards. I guess this was the reason why it did not affect the web viewer.

I have marked Joshua Young's answer as the correct answer since he answers my question about a list of Arcade limitations/versions. But you definitively helped me more to fix the underlying problem! Thank you very much!

PS. I don't understand why there is no debug information. Do you know by chance if there is an option to have Arcade debug information in a web developer console when using a web app?

Re: Looking for a source which lists Arcade limitations across products?

XanderBakker — Wed, 10 Jul 2019 15:17:30 GMT

Hi moosetraveller ,

Glad to hear it is working. It's OK to mark Joshua's answer as the correct one.

For "debug information" I would probably use "Console" statements in the Arcade expression to track what is happening at certain points of the expression.

Re: Looking for a source which lists Arcade limitations across products?

Thomas_Z1 — Wed, 10 Jul 2019 16:17:55 GMT

Thank you for your hint with the Console function!

I did not know that it also prints to a JavaScript console.

It's not really documented: https://developers.arcgis.com/arcade/function-reference/data_functions/#console

Re: Looking for a source which lists Arcade limitations across products?

XanderBakker — Wed, 10 Jul 2019 18:48:19 GMT

Hi moosetraveller ,

That is good to know. Thanks for sharing!