- 53.3K All Categories
- 55.6K NetSuite Support Community
- 4.3K Ask A Guru
- 11 Ask A Guru Live
- 27 NSC Webinars
- 42 Release 2020.2
- 1.6K Account Administration
- 9.1K Accounting / ERP
- 9.5K General
- 3K CRM
- 5.8K Web Site / E-Commerce
- 4K Search / Reporting
- 39 SuiteAnalytics Workbook
- 3 NSPB (formerly PBCS)
- 15.5K SuiteCloud / Customization
- 3 Member's Corner
- 669 SuitePeople HR / US Payroll
- 4 SuitePeople HR / US Payroll - Ideas
- 118 SuitePeople HR
- SuitePeople HR - Ideas
- 294 SuitePeople US Payroll
- 760 NetSuite - Archive
Please note that on Saturday, September 25, 2021, at 10:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 180 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
The NetSuite Support Assistant is a convenient chatbot SuiteApp that provides quick responses to your basic questions directly from your NetSuite Account.
Click NetSuite Support Assistant Now Available for more details.
If you would like to receive a 2021.2 Release Preview account, please opt -in to take advantage of the Release Preview access period to prepare and become familiar with the new NetSuite capabilities. For details, see Requesting a Release Preview Account.
If you receive a Release Preview account in 2021.2, you can access it several weeks before your production account is scheduled for an upgrade to the new release of NetSuite. Notifications with details about Release Preview availability are sent to the account administrators as described in Release Preview Notifications. Release Preview availability information is also posted on the New Release portlet.
SuiteQL query with ORDER BY clause returns no data
I’ve been using SuiteQL and the NetSuite Rest Services in a custom integration project. Everything works fine with the queries except when I use the “ORDER BY” clause. When I add it to a query, it returns no data (without it, the query works perfectly)
Executing this simple query: “SELECT id,email,firstname,lastname FROM Customer” returns the corresponding items. But executing this query: “SELECT id,email,firstname,lastname FROM Customer ORDER BY id” returns nothing
I’m wondering if this is either a limitation on the Rest Web Services API or a missing permission.
Thank you very much in advance for your replies!