Hi -
Is there any way to search for the lack of specific child records - for example, a list of all customers w/o tasks?
I can search for all customers with tasks by using a join and searching to see if a manditory field is set - however there doesn't seem to be any way to reverse that. Using an expression search with "Not" does not function as expected (which would be to show all results which don't fit that criteria - ie, subtracting that set from the overall set), but instead returns "no results".
Further testing indicates that "not" is not do a true boolean search, but instead is taking the shortcut of simply negating the specified criteria.
Not (task:title is not empty)
is not the same as
task:title is empty
although Netsuite is treating it as such
Does anyone have any suggestions for how to perform such a search? It seems like a pretty useful thing to have. Whether you're seaching for tasks, transactions, or custom records, it's useful to know which customers do not have any of these attached to their record.
Thanks!
--Tim