topic Re: Arcade "Count" issues in ArcGIS Online Questions

Arcade "Count" issues

Anonymous User — Tue, 01 Jun 2021 11:51:51 GMT

I'm using the below code, attempting to filter a related table for inspections to show a message in the pop-up

var gid = $feature.globalid
console(gid)
var signcount = filter(FeatureSetByName($map,'Sign_Information', ['*']),'parentglobalid = gid')
console(signcount)
var x = typeof(signcount)
console(x)
var sign = count(signcount)
console("sign = "+sign)

var p = ""
when(sign > 1, p = "There are "+sign+" sign surveys on this asset",
sign == 1, p = "There is 1 sign survey on this asset",
p = "There are no sign surveys recorded for this asset")
return p

This just fails and errors in the expression builder.

Further interrogation in Pro gives

I have consoled out the type of the signcount to rule out issues there.

What's the inevitably very obvious thing I'm missing?

Thanks

Re: Arcade "Count" issues

JayantaPoddar — Tue, 01 Jun 2021 14:05:36 GMT

Filter()

TypeOf()

Count()

Console()

When()

*in Proper Case. Does it work?

Re: Arcade "Count" issues

Anonymous User — Tue, 01 Jun 2021 14:23:30 GMT

Arcade is supposed to remove the case dependency, but also, no unfortunately not.

Re: Arcade "Count" issues

JayantaPoddar — Tue, 01 Jun 2021 14:54:57 GMT

Could you add the Boolean (includeGeometry?) to FeatureSetByName() function?

I understand it's optional. But still want to tick off that option as the probable cause of the problem.

Re: Arcade "Count" issues

Anonymous User — Tue, 01 Jun 2021 15:24:30 GMT

Unfortunately that doesn't work either.

As the error says, it's getting past the FeatureSetByName (I also tried ID) before the error, it's specifically the count that fails.

There is an issue with the feature set getting created by the filter. I've just tried the script out without the filter and it works fine

Re: Arcade "Count" issues

KenBuja — Tue, 01 Jun 2021 15:56:29 GMT

Your filter clause is failing due to incorrect syntax. "gid" is a string variable, not the actual value for parentglobalid. Use this syntax

var signcount = filter(FeatureSetByName($map,'Sign_Information', ['*']),"parentglobalid = '" + gid + "'");

Re: Arcade "Count" issues

Anonymous User — Wed, 02 Jun 2021 08:11:39 GMT

It's not even as complicated as that.
var signcount = filter(FeatureSetByName($map,'Sign_Information', ['*']),'parentglobalid = @gid') to declare it as an arcade variable

Re: Arcade "Count" issues

KenBuja — Tue, 01 Jun 2021 19:54:09 GMT

That's a more concise syntax I didn't know about. Is your script working now?

Re: Arcade "Count" issues

Anonymous User — Wed, 02 Jun 2021 08:09:30 GMT

Nor did I, annoyingly it wasn't even hidden in the depths of some obscure guide, it's on the guide for anything that has an SQL string query in the function reference.

To a degree, it's working in the expressions builder but not in the actual pop-ups.

Re: Arcade "Count" issues

Anonymous User — Wed, 02 Jun 2021 08:13:16 GMT

See below, but looks like I've sorted one problem at least.

The filter wasn't working properly as I hadn't done the SQL query correctly, needed an "@" before "gid" to set it as an arcade variable.

Still not working in the actual pop-up, but it is working in the expression builder.