Is there a LIMIT in runSuiteQL.query? eg, LIMIT 5
# suitescript
e
Is there a LIMIT in runSuiteQL.query? eg, LIMIT 5
s
I know these two methods work: SELECT TOP 5 or WHERE ROWNUM <= 5
e
THANKS!
j
The limitation which this is that you can’t combine ORDER and TOP unless you do a nested query (that is ordered) and do the TOP in the outer query.