InterSystems Ideas

We love hearing from our users. Tell us what you want to see next and upvote ideas from the community.
* Bugs and troubleshooting should as usual go through InterSystems support.

Status Planned or In Progress

Categories InterSystems IRIS

Created by Dmitry Maslennikov

Created on Jul 27, 2022

LIMIT OFFSET support for IRIS SQL

LIMIT OFFSET feature is widely used by other databases. And it is a real pain at the moment to achieve something similar on IRIS SQL. Django ORM for instance requires this for pagination, and there is no way to make it some other way

ADMIN RESPONSE

Nov 18, 2022

Thank you for submitting the idea. The status has been changed to "planned".
This is not a commitment; plans are subject to change. Stay tuned!

Post comment

Admin

Vadim Aniskin

Reply
| Jun 23, 2023

@Dmitry Maslennikov, you have a comment on your idea. Please answer to help your idea to be promoted.

0 reply Hide replies

Sean Connelly

Reply
| Apr 4, 2023

If you need a LIMIT OFFSET then you might be trying to solve pagination, if you need to solve pagination then you could take a look at %Library.ScrollableResultSet. This provides pagination and it caches the results, so its very efficient.

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic.cls?LIBRARY=%25SYS&CLASSNAME=%25Library.ScrollableResultSet

1 reply Hide replies