Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
"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."