When using the MARC export tool at /tools/export.pl you have the option to filter the records by accession date. This feature is not currently functioning. Instead of filtering, it simply grabs all records regardless of accession date. <oleonard>: I think I'm reproducing your bug SJeffery, given how long this export download is taking <oleonard>: Yup, got all records. <oleonard>: SJeffery: master
Created attachment 18045 [details] dates in the marc aren't in the date range either This is still an issue. I ran the export for Jan 1 2013 to today and I got results like this one: mysql> select datecreated from biblio where biblionumber=753; +-------------+ | datecreated | +-------------+ | 2012-09-21 | +-------------+ Which is obviously not right. The MARC is attached in the image
Created attachment 18631 [details] [review] Bug 9300 - filtering export.pl by accession date does not work Small typo in query construction, fixed. To test: 1) Try filtering a MARC export using "Start date" 2) Notice the lack of filtering 3) Apply patch 4) Try export again, records are filtered by
Created attachment 18632 [details] [review] Bug 9300 - filtering export.pl by accession date does not work Small typo in query construction, fixed. To test: 1) Try filtering a MARC export using "Start date" 2) Notice the lack of filtering 3) Apply patch 4) Try export again, records are filtered by dateaccessioned
Patch tested with a sandbox, by Cedric Vita <cedric.vita@dracenie.com>
Created attachment 18698 [details] [review] Bug 9300 - filtering export.pl by accession date does not work Small typo in query construction, fixed. To test: 1) Try filtering a MARC export using "Start date" 2) Notice the lack of filtering 3) Apply patch 4) Try export again, records are filtered by dateaccessioned Signed-off-by: Cedric Vita <cedric.vita@dracenie.com>
Typo fix. Marked as Passed QA.
Created attachment 18731 [details] [review] Bug 9300 - filtering export.pl by accession date does not work Small typo in query construction, fixed. To test: 1) Try filtering a MARC export using "Start date" 2) Notice the lack of filtering 3) Apply patch 4) Try export again, records are filtered by dateaccessioned Signed-off-by: Cedric Vita <cedric.vita@dracenie.com> Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Pushed to master. Thanks, Jesse!
This patch has been pushed to 3.12.x, will be in 3.12.1. Thanks Jesee!
Pushed to 3.10.x, will be in 3.10.7