Bug 19269 - Advanced Editor - Rancor - Add ability to search batches by lccn and pubdate
Summary: Advanced Editor - Rancor - Add ability to search batches by lccn and pubdate
Status: Patch doesn't apply
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Cori Lynn Arnold
QA Contact: Testopia
URL:
Keywords:
Depends on: 18823
Blocks: 19270
  Show dependency treegraph
 
Reported: 2017-09-07 10:16 UTC by Nick Clemens
Modified: 2020-09-10 13:06 UTC (History)
4 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 19269 - database changes (1.90 KB, patch)
2017-09-07 10:34 UTC, Nick Clemens
Details | Diff | Splinter Review
Bug 19269: Rancor - Add LCCN, pubdate to indexing (3.61 KB, patch)
2017-09-07 10:34 UTC, Nick Clemens
Details | Diff | Splinter Review
Bug 19269 - database changes (1.90 KB, patch)
2018-08-16 12:30 UTC, Nick Clemens
Details | Diff | Splinter Review
Bug 19269: Rancor - Add LCCN, pubdate to indexing (4.24 KB, patch)
2018-08-16 12:30 UTC, Nick Clemens
Details | Diff | Splinter Review
Bug 19269: Rancor - Add LCCN, pubdate to indexing (4.39 KB, patch)
2018-10-22 19:57 UTC, Cori Lynn Arnold
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Nick Clemens 2017-09-07 10:16:29 UTC
This patchset add two columns to import biblios to allow for searching on these values, it should allow for future use in matching and expanded display to give more record feedback
Comment 1 Nick Clemens 2017-09-07 10:34:31 UTC
Created attachment 66927 [details] [review]
Bug 19269 - database changes
Comment 2 Nick Clemens 2017-09-07 10:34:33 UTC
Created attachment 66928 [details] [review]
Bug 19269: Rancor - Add LCCN, pubdate to indexing

Also, fix control number updating for updated records
Comment 3 Katrin Fischer 2017-09-20 21:55:35 UTC
Hi Nick,
can you please add a test plan for the second patch?

> Also, fix control number updating for updated records
Comment 4 Nick Clemens 2018-08-16 12:30:51 UTC
Created attachment 77910 [details] [review]
Bug 19269 - database changes
Comment 5 Nick Clemens 2018-08-16 12:30:54 UTC
Created attachment 77911 [details] [review]
Bug 19269: Rancor - Add LCCN, pubdate to indexing

This patch filsl the two new columns in the import_biblios table:
lccn, pubdate
It also fixes update of ocntrol number in the import_biblios table

To test:
1 - Apply and update database
2 - Import some records
3 - Check the import table to see new columns are populated correctly
4 - check control number is correct in table too
5 - Open advanced cataloging editor
6 - Set your batch as searchable (settings->import batches)
7 - You should now be able to search batches for lccn or pubdate or
control number
8 - Verify records are found as expected and can be saved to catalog or
batch
Comment 6 Cori Lynn Arnold 2018-10-12 16:17:51 UTC
Will need to be rebased with depends on bugs.
Comment 7 Cori Lynn Arnold 2018-10-22 19:57:38 UTC
Created attachment 80989 [details] [review]
Bug 19269: Rancor - Add LCCN, pubdate to indexing

This patch fills the two new columns in the import_biblios table:
lccn, pubdate
It also fixes update of ocntrol number in the import_biblios table

Because 010 fields can have leading and trailing whitespace, added trim
before INSERT into import_biblios table. -cori lynn

To test:
1 - Apply and update database
2 - Import some records
3 - Check the import table to see new columns are populated correctly
4 - check control number is correct in table too
5 - Open advanced cataloging editor
6 - Set your batch as searchable (settings->import batches)
7 - You should now be able to search batches for lccn or pubdate or
control number
8 - Verify records are found as expected and can be saved to catalog or
batch