Forum Stats

  • 3,679,580 Users
  • 57,524 Discussions
  • 190,818 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
NetSuite Maintenance - September 25
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.
Cheers to 1️⃣0️⃣ years of #SuiteWorld! 🎉 We’re celebrating by extending the Super Saver Pass AND launching the digital On Air experience TODAY! Whether you join us in-person or digitally, we can’t wait to make even more memories with you. https://lnkd.in/dGpPpmUV
Webinar | COSTING 101: Learning the Basics of Inventory Costing webinar was a success! Please take a minute to fill out this short survey. For those who missed it - Don't worry! Here's the link to the recorded session!
NetSuite Support Assistant: A quicker way to get answers to your basic NetSuite questions
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.
Release Preview 2021.2

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

User_M3JVC
User_M3JVC Member, forum_userscommunity_users Posts: 1 Newbie
edited Sep 14, 2021 4:45PM in Ask A Guru 186.26.118.205

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!

Answers

  • Joahnna Given Uy-Oracle
    Joahnna Given Uy-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 134 Silver Badge

    Hello @User_M3JVC ,


    Welcome to NS Support Community and thank you for posting your concern here!


    For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. You can also update your profile and set your preferred username so other members can address you properly moving forward. 



    Allow our gurus to review your concern and perform their initial investigation.

    Anyone who also have insights that may help, feel free to join this thread!



    Thank you,

    Joahnna

  • Erick Dela Rosa-Oracle
    Erick Dela Rosa-Oracle Node Administrator, ORACLE_EMPLOYEE Posts: 1,019 Admin

    Hi Johann,

    Welcome to the NetSuite Support Community!

    This is a known limitation. The workaround is to add either ASC or DSC when using ORDER BY.

    Using your query as an example:

    SELECT id,email,firstname,lastname FROM Customer ORDER BY id ASC

    Hope this helps! 😊

    Kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. Thank you!


    Erick Dela Rosa-Oracle | Ask A Guru

    NetSuite Support Community Administrator

  • Erick Dela Rosa-Oracle
    Erick Dela Rosa-Oracle Node Administrator, ORACLE_EMPLOYEE Posts: 1,019 Admin

    Hi Johann,

    Did we answer your question? Please let us know.

    Thank you!

    Kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. Thank you!


    Erick Dela Rosa-Oracle | Ask A Guru

    NetSuite Support Community Administrator