topic Re: Issue on Getting Count of Intersect in Arccade Attribute Rule in Attribute Rules Questions

Issue on Getting Count of Intersect in Arccade Attribute Rule

MarcoMob — Mon, 03 Apr 2023 22:43:56 GMT

Having two feature classes in SDE geodatabase like

- EGDB.North.Parcels

- EGDB.North.ProjectsInvest

I am trying to get the total count of Intersection between EGDB.North.Projects in EGDB.North.ProjectsInvest using Attribute rules like this

var intersects = Intersects(FeatureSetByName($datastore, "EGDB.North.Parcels"), Geometry($feature)); return Count(intersects) ;

but I am getting this error

002717: Invalid Arcade expression

var intersects = Intersects(FeatureSetByName($datastore, "EGDB.North.Parcels"), Geometry($feature)); if(Count(intersects)>0){ return Count(intersects); } else{ return 0; }

Re: Issue on Getting Count of Intersect in Arccade Attribute Rule

TedHoward2 — Mon, 03 Apr 2023 23:08:07 GMT

Using reserved function names as the name of a variable is a bad idea. Try using "var inter =" instead.

Also, you do not need to use fully qualified names for FeatureSetByName. Just use "Parcels".

Re: Issue on Getting Count of Intersect in Arccade Attribute Rule

MarcoMob — Mon, 03 Apr 2023 23:26:29 GMT

Thanks for reply Ted but nothing changed!

var inters = Intersects(FeatureSetByName($datastore, "Parcels"), Geometry($feature)); return Count(inters) ;

still getting same error message

Re: Issue on Getting Count of Intersect in Arccade Attribute Rule

TedHoward2 — Mon, 03 Apr 2023 23:46:05 GMT

That looks valid.

You could try exporting those features classes to FGDB or MGDB to see if the problem is specific to SDE.

Re: Issue on Getting Count of Intersect in Arccade Attribute Rule

MarcoMob — Tue, 04 Apr 2023 03:59:25 GMT

Well, this is weird!

As you recommended I copied both

- EGDB.North.Parcels

- EGDB.North.ProjectsInvest

into a local FGDB and this is working now

var inters = Intersects(FeatureSetByName($datastore, "Parcels"), Geometry($feature)); return Count(inters)

So, why this is happening in SDE? how can I fix this? Is there any solution for this? Thanks

Re: Issue on Getting Count of Intersect in Arccade Attribute Rule

TedHoward2 — Tue, 04 Apr 2023 16:28:22 GMT

I believe this is the same issue found here

https://community.esri.com/t5/attribute-rules-questions/attribute-rule-not-working-anymore-in-3-1/td-p/1271804

I recommend contacting Tech support for a way forward