topic Re: Alternative to First in Attribute Rules Questions

Alternative to First

ChrisGAEG — Wed, 18 Aug 2021 23:44:34 GMT

Hi there,

I have a rule where I am trying to see if a line intersects a specific polygon. I was using First, but realized the rule wouldn't flag if it went through another polygon first, then intersected my flag polygon. Is there a way to return a list and then flag if my polygon(cab_id == 'SDY-HUT') is in that list? This is the code I am using.

var cabs = FeatureSetByName($datastore, "Proposed_OLT_LCP_Boundaries_copy", ["cab_id"]) var cabsInt = Intersects(cabs, $feature) var cabSpliceInt = First(cabsInt) if (cabSpliceInt == null) return {"errorMessage": "Please edit inside a cabinet boundary"} if (cabSpliceInt.cab_id == 'SDY-HUT') return false; else return true;

Thanks!

Re: Alternative to First

JohannesLindner — Thu, 19 Aug 2021 05:36:25 GMT

var cabs = FeatureSetByName($datastore, "Proposed_OLT_LCP_Boundaries_copy", ["cab_id"]) var cabsInt = Intersects(cabs, $feature) // just check the intersected feature set if (cabsInt == null || Count(cabsInt) == 0) { return {"errorMessage": "Please edit inside a cabinet boundary"} } // filter cabsInt for your flagged polygon var sdy_hut = First(Filter(cabsInt, "cab_id = 'SDY-HUT'")) if (sdy_hut == null) { return false } return true

Re: Alternative to First

HusseinNasser2 — Fri, 20 Aug 2021 15:14:30 GMT

You can continue using first but first (no pun) you have to add an additional filter against the polygon you want. Push the query all the way to the DB.

var cabs = FeatureSetByName($datastore, "Proposed_OLT_LCP_Boundaries_copy", ["cab_id"], false) var filteredCabs = filter(cabs, "cab_id='SDY-HUT'") var cabsInt = Intersects(filteredCabs , $feature) var cabSpliceInt = First(cabsInt) if (cabSpliceInt == null) return {"errorMessage": "Please edit inside a cabinet boundary"} return true;

Re: Alternative to First

ChrisGAEG — Fri, 20 Aug 2021 16:00:58 GMT

Okay great, this makes sense. What is the syntax for using a list in this case? What is the Arcade equivalent of "IN"? I want to do something like the following -

var filteredCabs = filter(cabs, "cab_id IN ('SDY-HUT', 'ESC-C02', 'ESC-C04')")

Re: Alternative to First

HusseinNasser2 — Fri, 20 Aug 2021 16:05:56 GMT

That statement is correct and should work

p.s. it is not Arcade, it is SQL.