https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28029 Bug ID: 28029 Summary: Add ability to use OFFSET in SQL reports Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: joe@flo.org QA Contact: testopia@bugs.koha-community.org As far as I can tell, you can't use offset [# to offset] or the abbreviated limit [# to offset], [# to limit] shorthand to offset your results in Koha's SQL reports. These features are available in MySQL and Mariadb, so it would be nice if you could use one of them on the front end. Here are two simple examples that don't work: select borrowernumber from borrowers limit 10, 10 select borrowernumber from borrowers limit 10 offset 10 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.