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@gmail.com Reporter: nick@bywatersolutions.com QA Contact: testopia@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.