Alternative to First

ChrisGAEG

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! 

HusseinNasser2

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;