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.
SuiteScript - query.runSuiteQLPaged() problem
Hello!
I stumbled across a strange problem while using the method runSuiteQLPaged(). When I have an "ORDER BY" clause in my SQL, I get data ONLY in the last page. All previous pages do not return data.
When I do not use an "ORDER BY" clause everything is fine and data is returned in all pages.
Have for example this simple SQL:
If I run this code everything is fine. I get the desired results in the FOR loop.
However when I uncomment the row with the "ORDER BY" clause and rerun the exact same code, no data is returned for each page.
Tagged:
0