Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
"sublist doesn't contain [something]" search
That's the best subject I could come up with. Couple examples to explain what I've been trying to do.
1. show all customers who do NOT have an address with Address Label = "Main"
2. show all customers who own a certain product but NOT another product
I've struggled to do this type of work in a single search. If I say "show all addresses where label != main," I just get all the other addresses (yes, that's obvious). And if a customer has only one address and it is "main," the customer is excluded from the results. I want the opposite. I only want to include customers in my results where they DO NOT have "main."
0