Bug 31158: (bug 23991 follow-up) Fix suggestion search by dates
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 1 Aug 2022 06:14:27 +0000 (08:14 +0200)
committerTomas Cohen Arazi <tomascohen@theke.io>
Tue, 16 Aug 2022 12:15:56 +0000 (09:15 -0300)
commit89f2f369a61b43d396f90d77e1bd1941330a359f
tree57122f75b79edbafbe004c0570338137b22d8e4d
parent5e29433bdc3a5ccd582ece6e2338c6e38e97c5d9
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 <katrin.fischer.83@web.de>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
suggestion/suggestion.pl