[Koha-bugs] [Bug 28029] New: Add ability to use OFFSET in SQL reports

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: joe at flo.org
        QA Contact: testopia at 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.