Bug 27663 - statistics table should have some way to include items.permanent_location
Summary: statistics table should have some way to include items.permanent_location
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-09 15:04 UTC by George Williams (NEKLS)
Modified: 2023-06-16 14:07 UTC (History)
7 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description George Williams (NEKLS) 2021-02-09 15:04:07 UTC
statistics.location currently uses items.location at the time an item is checked out.

This means that for a library using the CART and PROC locations, accurate data about an item's permanent location at the time of check-out can only be gathered through a report linking to the item record.

It would be more efficient for items that are using the PROC and CART locations if the statistics table also included the item's permanent location or if there were a system preference that allowed users to specify whether they want statisitcs.location to use an item's items.location or items.permanent_location at the time of check-out.
Comment 1 Christopher Brannon 2021-02-10 17:38:21 UTC
+1
Comment 2 Barbara Johnson 2021-02-10 20:50:35 UTC
Agreed.
Comment 3 Andrew Fuerste-Henry 2022-08-09 15:15:07 UTC
If we're recording it in statistics we should add it to pseudonymized transactions, too.
Comment 4 Rebecca Coert 2022-08-09 15:30:48 UTC
Agreed!
Comment 5 Katrin Fischer 2023-01-23 22:25:21 UTC
Would a switch/change to use permanent_location be enough or are both locations needed?
Comment 6 George Williams (NEKLS) 2023-01-23 22:29:32 UTC
items.permanent_location is not populated at libraries where the cart-to-shelf function is not used, so I think it would be best as a system preference, giving the library the choice of which one to use.  That being said, if both were populated in statistics, that would cover the issue equally well.
Comment 7 Christopher Brannon 2023-05-25 18:00:18 UTC
(In reply to George Williams (NEKLS) from comment #6)
> items.permanent_location is not populated at libraries where the
> cart-to-shelf function is not used, so I think it would be best as a system
> preference, giving the library the choice of which one to use.  That being
> said, if both were populated in statistics, that would cover the issue
> equally well.

+1
Comment 8 Christopher Brannon 2023-05-25 18:00:32 UTC
(In reply to George Williams (NEKLS) from comment #6)
> items.permanent_location is not populated at libraries where the
> cart-to-shelf function is not used, so I think it would be best as a system
> preference, giving the library the choice of which one to use.  That being
> said, if both were populated in statistics, that would cover the issue
> equally well.

+1
Comment 9 Sally 2023-06-16 14:07:07 UTC
+1

Adding items.permanent_location to statistics would resolve this problem.