[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Tomás Cohen Arazi changed: What|Removed |Added Keywords|rel_22_11_candidate | CC||tomasco...@gmail.com -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Lucas Gass changed: What|Removed |Added Status|Pushed to master|RESOLVED Resolution|--- |FIXED CC||lu...@bywatersolutions.com --- Comment #10 from Lucas Gass --- This shouldn't be needed in 22.05.x, no backport -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 --- Comment #9 from Tomás Cohen Arazi --- Pushed to master for 22.11. Nice work everyone, thanks! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Tomás Cohen Arazi changed: What|Removed |Added Status|Passed QA |Pushed to master Version(s)||22.11.00 released in|| -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Victor Grousset/tuxayo changed: What|Removed |Added CC||vic...@tuxayo.net --- Comment #8 from Victor Grousset/tuxayo --- *** Bug 31347 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Martin Renvoize changed: What|Removed |Added Status|Signed Off |Passed QA CC||martin.renvoize@ptfs-europe ||.com --- Comment #7 from Martin Renvoize --- Solid fix, works as expected.. Passing QA -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Martin Renvoize changed: What|Removed |Added Attachment #138762|0 |1 is obsolete|| --- Comment #6 from Martin Renvoize --- Created attachment 138930 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=138930=edit Bug 31158: (bug 23991 follow-up) Fix suggestion search by dates Search suggestions by date is broken, we don't remove the '_from' CGI params for the DBIC query DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'suggesteddate_from' in 'where clause' at /kohadevbox/koha/Koha/Objects.pm line 394 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 Test plan: Create some suggestions, search for them using date range (suggested date, managed date and accepted date) Signed-off-by: Katrin Fischer Signed-off-by: Martin Renvoize -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Katrin Fischer changed: What|Removed |Added Attachment #138436|0 |1 is obsolete|| --- Comment #5 from Katrin Fischer --- Created attachment 138762 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=138762=edit Bug 31158: (bug 23991 follow-up) Fix suggestion search by dates Search suggestions by date is broken, we don't remove the '_from' CGI params for the DBIC query DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'suggesteddate_from' in 'where clause' at /kohadevbox/koha/Koha/Objects.pm line 394 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 Test plan: Create some suggestions, search for them using date range (suggested date, managed date and accepted date) Signed-off-by: Katrin Fischer -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Katrin Fischer changed: What|Removed |Added Status|Needs Signoff |Signed Off Patch complexity|--- |Small patch -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Jonathan Druart changed: What|Removed |Added Attachment #138519|0 |1 is obsolete|| -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Jonathan Druart changed: What|Removed |Added Status|Signed Off |Needs Signoff --- Comment #4 from Jonathan Druart --- Rachael, were you signed off on purpose? The process you followed is not correct, please read https://wiki.koha-community.org/wiki/Sign_off_on_patches You didn't attach the correct patch to the bug report. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 --- Comment #3 from Rachael --- Created attachment 138519 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=138519=edit Bug 30879: DBRev 22.06.00.031 Signed-off-by: Tomas Cohen Arazi Signed-off-by: Rachael Laritz -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Rachael changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Jonathan Druart changed: What|Removed |Added Keywords||rel_22_11_candidate Assignee|koha-b...@lists.koha-commun |jonathan.druart+koha@gmail. |ity.org |com CC||jonathan.druart+koha@gmail. ||com -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 --- Comment #2 from Jonathan Druart --- Created attachment 138436 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=138436=edit Bug 31158: (bug 23991 follow-up) Fix suggestion search by dates Search suggestions by date is broken, we don't remove the '_from' CGI params for the DBIC query DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'suggesteddate_from' in 'where clause' at /kohadevbox/koha/Koha/Objects.pm line 394 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 Test plan: Create some suggestions, search for them using date range (suggested date, managed date and accepted date) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Jonathan Druart changed: What|Removed |Added Status|NEW |Needs Signoff -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Katrin Fischer changed: What|Removed |Added Depends on||23991 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23991 [Bug 23991] Move SearchSuggestion to Koha::Suggestions -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Katrin Fischer changed: What|Removed |Added Depends on|29229 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29229 [Bug 29229] Use Flatpickr in suggestion search sidebar filter -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 31158] Can't filter suggestions by date ranges
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31158 Katrin Fischer changed: What|Removed |Added Summary|Can't filter suggestions by |Can't filter suggestions by |suggestion date range |date ranges Depends on||29229 --- Comment #1 from Katrin Fischer --- Confirmed! It cannot work, the column in the database is suggesteddate. But this problem exists for all the data range searches in the form. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29229 [Bug 29229] Use Flatpickr in suggestion search sidebar filter -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/