How do I write a filter statement in arcade in field maps for grouped fields?
Assignment IS NOT NULL AND Service_Finished_Date IS NOT NULL AND Mapped IS NULL
OR
Sales Department IS NULL AND Office IS NULL
Solved! Go to Solution.
It's a little more hidden. You have to click on the options for a condition and select "add condition".
var asgn = $feature['assignment']
var sfdt = $feature['service_finished_date']
var m = $feature['mapped']
var dept = $feature['sales_department']
var o = $feature['office']
if (
(!IsEmpty(asgn) && !IsEmpty(sfdt) && IsEmpty(m))
||
(IsEmpty(dept) && IsEmpty(o))
) {
// do something here
}
This isn't specific to Field Maps, but if you wanted to replicate that SQL filter in Arcade, it could look like the expression above.
Does the new Map Viewer not support the classic filtering options for "adding a set" ?
It's a little more hidden. You have to click on the options for a condition and select "add condition".