[Koha-devel] Can we do away with items.onloan?

[Katrin Fischer]

Hi Manos,

it's an item field, so it's added for every item in 952/955.

As the complete items information is added on time of indexing, I think 
what Barton suggests is already the case?

Katrin


On 20.05.2018 00:06, Manos PETRIDIS wrote:
> Surely, an item's checkout date and/or date due do not belong to the 
> bibliographic marcxml field. What if we have more than one copies of a 
> certain book for example?
>
> MP
>
> Στις Παρ, 18 Μαΐ 2018 στις 9:26 μμ ο χρήστης Barton Chittenden 
> <barton at bywatersolutions.com <mailto:barton at bywatersolutions.com>> έγραψε:
>
>     One of my first trouble-shooting experiences with Koha involved a
>     report of search results where an item was showing as 'available',
>     but the detail showed it checked out to a patron. Some helpful
>     bywaterian pointed me to items.onloan, and issues.date_due, and
>     showed me that they didn't match. A database update and a zebra
>     re-index later, and the problem was solved.
>
>     We've never figured out the circumstances under which these get
>     out of sync... we always find out about it after the fact. I'm
>     sure that we could find everywhere that they're written, and put
>     the writes to the items table and the issues table into a single
>     transaction... but wouldn't it be better to simply add the due
>     date to the marcxml record from the issues table at the time of
>     indexing and remove the possibility of error entirely?
>
>     It's a paper-cut of a problem, but it's always bothered me.
>
>     --Barton
>     _______________________________________________
>     Koha-devel mailing list
>     Koha-devel at lists.koha-community.org
>     <mailto:Koha-devel at lists.koha-community.org>
>     http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>     website : http://www.koha-community.org/
>     git : http://git.koha-community.org/
>     bugs : http://bugs.koha-community.org/
>
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20180520/37451065/attachment.html>