You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Connect Web Services equivalent to "TOP n rows", like Oracle's "WHERE ROWNUM < n" ?

Received Response
15
Views
5
Comments
edited Jun 8, 2022 12:01PM in General Technical Discussions 5 comments

Content

Is there a Connect Web Services equivalent to "TOP n rows", like Oracle's "WHERE ROWNUM < n" ?

I need to download more than 10k incidents in one method, but QueryCSV only allows 10k at a time. So I want to run a foreach loop that gets 0-10k in the first loop, 10-20k in the second loop, etc. etc. How is this possible?

Thanks in advance for your help...

Version

February 2014

Code Snippet

             Something like this for a few loops:
SELECT * FROM INCIDENTS WHERE ROWNUM < 10000
SELECT * FROM INCIDENTS WHERE ROWNUM > 10000 AND ROWNUM < 20000
SELECT * FROM INCIDENTS WHERE ROWNUM > 20000 AND ROWNUM < 30000
etc.
 
        

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!