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
It's a little more hidden. You have to click on the options for a condition and select "add condition".
Does the new Map Viewer not support the classic filtering options for "adding a set" ?
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.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.