Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Searching with the OR operator
How do I perform searches with an operator other than a simple AND?
Most of our searches contain a mix of both NetSuite and custom fields with an OR somewhere in the mix. Here is a typical customer search that we can perform through the NetSuite UI:
Inactive = false AND
isPerson = false AND //in the UI it isIndividual not isPerson
custentity_dc_active = false AND
(custentity_dc2 = true OR
custentity_dc = true)
But how can I perform this search pragmatically? I've not been able to find out how to do this through either SuiteScript or SuiteTalk. This is basic search functionality. Right now I'm having to pull data out through ODBC and perform SQL statements outside of NetSuite. Of course ODBC is read-only and I need the ability to write back data to NetSuite.