[Bug 21984] New: Unable to load second page of results for reports with reused parameters
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Bug ID: 21984 Summary: Unable to load second page of results for reports with reused parameters Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org 1 - To recreate: Create a report like: SELECT <<cat>>,<<dog>>,<<cat>> FROM items 2 - Run the report, enter 'CATS' and 'DOGS' 3 - Get results LIKE "CAT | DOG | CAT" 4 - Try to go to page 2 5 - FAIL! (last column is blank) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |9634 Assignee|koha-bugs@lists.koha-commun |nick@bywatersolutions.com |ity.org | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9634 [Bug 9634] Allow for parameters re-use on SQL reports -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 --- Comment #1 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 83051 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83051&action=edit Bug 21984: Pass param_name in ppagination URL To test: 1 - Create a report like: SELECT <<cat>>,<<dog>>,<<cat>> FROM items 2 - Run the report, enter 'CATS' and 'DOGS' 3 - Get results LIKE "CAT | DOG | CAT" 4 - Try to go to page 2 5 - FAIL! (last column is blank) 6 - Apply patch 7 - Run the repot, enter 'CATS' and 'DOGS' 8 - Verify first page looks right 9 - Go to page 2 10 - Results are correct! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |claire_gravely@hotmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 ByWater Sandboxes <bws.sandboxes@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #83051|0 |1 is obsolete| | --- Comment #2 from ByWater Sandboxes <bws.sandboxes@gmail.com> --- Created attachment 83057 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83057&action=edit Bug 21984: Pass param_name in ppagination URL To test: 1 - Create a report like: SELECT <<cat>>,<<dog>>,<<cat>> FROM items 2 - Run the report, enter 'CATS' and 'DOGS' 3 - Get results LIKE "CAT | DOG | CAT" 4 - Try to go to page 2 5 - FAIL! (last column is blank) 6 - Apply patch 7 - Run the repot, enter 'CATS' and 'DOGS' 8 - Verify first page looks right 9 - Go to page 2 10 - Results are correct! Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #83057|0 |1 is obsolete| | --- Comment #3 from Lucas Gass <lucas@bywatersolutions.com> --- Created attachment 83060 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83060&action=edit Bug 21984: Pass param_name in ppagination URL To test: 1 - Create a report like: SELECT <<cat>>,<<dog>>,<<cat>> FROM items 2 - Run the report, enter 'CATS' and 'DOGS' 3 - Get results LIKE "CAT | DOG | CAT" 4 - Try to go to page 2 5 - FAIL! (last column is blank) 6 - Apply patch 7 - Run the repot, enter 'CATS' and 'DOGS' 8 - Verify first page looks right 9 - Go to page 2 10 - Results are correct! Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> Signed-off-by: “Lucas Gass” <lucas@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #83060|0 |1 is obsolete| | --- Comment #4 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 83140 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83140&action=edit Bug 21984: Pass param_name in pagination URL To test: 1 - Create a report like: SELECT <<cat>>,<<dog>>,<<cat>> FROM items 2 - Run the report, enter 'CATS' and 'DOGS' 3 - Get results LIKE "CAT | DOG | CAT" 4 - Try to go to page 2 5 - FAIL! (last column is blank) 6 - Apply patch 7 - Run the repot, enter 'CATS' and 'DOGS' 8 - Verify first page looks right 9 - Go to page 2 10 - Results are correct! Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> Signed-off-by: “Lucas Gass” <lucas@bywatersolutions.com> Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |rel_18_11_candidate CC| |jonathan.druart@bugs.koha-c | |ommunity.org -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master --- Comment #5 from Nick Clemens <nick@bywatersolutions.com> --- Awesome work all! Pushed ot master for 19.05 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|rel_18_11_candidate | CC| |martin.renvoize@ptfs-europe | |.com Status|Pushed to Master |Pushed to Stable --- Comment #6 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Pushed to 18.11.x for 18.11.01 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lucas@bywatersolutions.com --- Comment #7 from Lucas Gass <lucas@bywatersolutions.com> --- backported to 18.05 for 18.05.08 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21984 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|Pushed to Stable |RESOLVED CC| |fridolin.somers@biblibre.co | |m --- Comment #8 from Fridolin SOMERS <fridolin.somers@biblibre.com> --- Depends on Bug 9634 not in 17.11.x -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org