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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
"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