https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43623
Bug ID: 43623
Summary: Pagination of JSON Report Exports
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Reports
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
Target Milestone: ---
To avoid the risk of downloading too many rows when exporting a report as JSON,
I wanted to try paginating the results by adding a limit and a variable offset
(a parameter passed in the URL) to the report.
But OFFSET doesn’t seem to be supported in SQL, which surprises me because it
isn’t listed among the filtered keywords specified in the community wiki
(create, update, etc.).
Example:
select itemnumber from items
LIMIT 50 OFFSET 100
gives me : You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'LIMIT 0, 50' at line 2
Is it a bug ? a missing feature?
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
