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!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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
Saved search for multiple custom objects on customer
I have customers that have a 1 to many relationship with custom objects. Those custom objects have their own attributes.
In the most simple of forms - what I need to be able to do is have a saved search look at the end date of every object attached to a customer and if ALL objects belonging to that customer have an end date - return the customer in the search results.
The issue is a search that says "End Date : is not empty" will return customers if they have multiple objects and only one has an end date.
Any thoughts would be appreciated.
0