[Koha-bugs] [Bug 15302] New: Use of LIMIT in reports breaks pagination

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15302

            Bug ID: 15302
           Summary: Use of LIMIT in reports breaks pagination
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: gmcharlt at gmail.com
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

When creating a SQL report if you add a LIMIT ### statement the results are
correctly returned, however, pagination links at the top of the page alter only
the starting point of results and all results are displayed on one page.

To clarify:
Create a report with over 100 results and specify LIMIT 100
You will see the first 100 results for the report on the first page with link
to 5 pages at the top
Clicking on page 2 will take you to a new page displaying results 21-100 on a
single page

Note:
Many libraries use limit to specifically make all results appear on one page.  
Suggested resolution would be to remove pagination when LIMIT is present in
report

-- 
You are receiving this mail because:
You are watching all bug changes.