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.
why is there a limit in SuiteQL return results?
From the documentation there seems to be two ways of ruining a SuiteQL query.
- SuiteQL.run()
- query.runSuiteQL(options)
As stated in the documentation both functions return the same results (https://suiteanswers.custhelp.com/app/answers/detail/a_id/91308).
There is a limit difference of 100'000 results when using SuiteQL.run() (when SuiteAnalytics is disabled, see previous documentation link) and 5'000 results when using query.runSuiteQL(options) (see https://suiteanswers.custhelp.com/app/answers/detail/a_id/91311).
My question is why is there a limit difference between both methods?
Tagged:
0