CODEWITHSUNDEEP
oracle-databaseautorestoracle-ords
Greg Braswell
Greg Braswell

Reputation: 143

Ords auto REST - setting default number of rows returned by auto rest query

We're using ORDS for internal applications and find auto REST to be very handy for quick, simple applications. When we enable rest services on a table or view we only get 25 rows by default. Trying to set "misc.pagination.maxRows" in defaults.xml such as 1500 does not affect the rest enabled schema objects however.

Is there a way to reset the pagination limit for auto-REST? currently we're having to force it with the limit parameter such as: ?limit=5000

currently using version: 18.2.0.r1831332

Upvotes: 0

Views: 1353

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22457

As you've seen, the AUTO feature isn't really configurable - so if you want a higher pagination size, you can force it, or you can build your own GET handler for your SELECT * FROM service.

The maxRows parameter sets the high water mark for the size of a page tied to a query, not the default or low side.

Upvotes: 1

Related Questions