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 Implemented

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

May 14, 2025

Thank you for submitting the idea.
This idea was implemented by InterSystems.

Post comment

Benjamin De Boe

May 14, 2025

This feature is part of the IRIS 2025.1 release

Reply
Hide replies
Like

Admin

Vadim Aniskin

Jun 23, 2023

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

Reply
Hide replies
Like

Sean Connelly

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
Like