In process items with edited lib search issues

[Elaine Hardy]

When an in process status item is edited to change the owning and circ library, searches scoped for the new library fail to retrieve the bib record.

Workflow:

Item cataloged for branch A and is in process.

Searching for title/author/keyword for consortium, system, or branch A retrieves bib record.

Item library edited to Branch B, still in process status.

Searching for title/author/keyword for consortium or system retrieves bib record. Searches scoped to Branch B get notice no record exists for the search. However, searching scoped to Branch A retrieves the record. Item count on bib record in search list for Branch A search:

12/16 @Consortium
0/1 @System
0/0 @System-BranchA

Checking the item in so status is available, resolves the issue.

It looks like that a search index isn't updating for in process items?

This can negatively impact patrons and staffs when trying to place holds on new items still in process.

[Mike Rylander (mrylander)]

Thanks for the detailed report, Elaine! I happened to look over at my bug email right as this popped up and took a quick look.

The cause of this that we're trying to be as economical as possible when updating the state information for a copy, and didn't anticipate someone both changing a field on a copy /and/ moving it from one call number object to another on the same bib at the same time (in the same database transaction). When you change the owning lib on a call number, that is effectively what happens if there is a conflicting target call number.

The solution is relatively straight forward, but I don't have enough time to test all possible inputs well enough for a pullrequest this afternoon. I'll post the branch here for others to test, though.

[Mike Rylander (mrylander)]

I've pushed the above-promised branch to:

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/miker/lp-2020705-copy_plus_cn_change_makes_no_vis_update

[Elaine Hardy (ehardy)]

This doesn't happen often but we have had reports of it 3 times lately (with vendor cataloged items) With the last report, we were able to pin down what it was.

I will see if Chris can get this on one of our test servers.

Thanks for the explanation and quick response!

[Elaine Hardy (ehardy)]

Chris applied it to our next server.

Searches for the title in the edited library are now findable (Woo hoo!). However, it still also retrieves with a search scoped to the original library with copy count for that library 0/0.

[Christine Morgan (cmorgan-z)]

Confirmed based on comments.