Connect Web Services equivalent to "TOP n rows", like Oracle's "WHERE ROWNUM < n" ?
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 2014Code 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.
0