Bug 30411 - Add separate shelving location column to holds queue
Summary: Add separate shelving location column to holds queue
Status: Needs documenting
Alias: None
Product: Koha
Classification: Unclassified
Component: Hold requests (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Lucas Gass (lukeg)
QA Contact: Matt Blenkinsop
URL:
Keywords:
: 33889 (view as bug list)
Depends on:
Blocks:
 
Reported: 2022-03-30 15:58 UTC by Sara Brown
Modified: 2024-11-18 17:56 UTC (History)
9 users (show)

See Also:
Change sponsored?: ---
Patch complexity: Trivial patch
Documentation contact:
Documentation submission:
Text to go in the release notes:
Adds shelving location as its own column in the holds queue. This makes it easier to sort the holds queue by shelving location.
Version(s) released in:
24.11.00
Circulation function:


Attachments
Bug 30411: Put shelving location into its own column in holds queue (4.34 KB, patch)
2022-03-30 22:15 UTC, Lucas Gass (lukeg)
Details | Diff | Splinter Review
Bug 30411: Put shelving location into its own column in holds queue (4.60 KB, patch)
2024-06-27 20:06 UTC, Lucas Gass (lukeg)
Details | Diff | Splinter Review
Bug 30411: Put shelving location into its own column in holds queue (4.59 KB, patch)
2024-06-28 12:56 UTC, Lucas Gass (lukeg)
Details | Diff | Splinter Review
Bug 30411: Put shelving location into its own column in holds queue (4.67 KB, patch)
2024-06-28 13:41 UTC, Owen Leonard
Details | Diff | Splinter Review
Bug 30411: Put shelving location into its own column in holds queue (4.74 KB, patch)
2024-06-28 14:20 UTC, Matt Blenkinsop
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Sara Brown 2022-03-30 15:58:16 UTC
It would be useful, especially with Bug 29015, for shelving location to be its own column in the Holds Queue. This would allow for more flexibility in how libraries view and sort their queues, especially if it's configurable in Table settings.
Comment 1 Lucas Gass (lukeg) 2022-03-30 22:15:30 UTC
Created attachment 132659 [details] [review]
Bug 30411: Put shelving location into its own column in holds queue

To test:
1. Put some items on hold, make some bib level holds and some item level holds. Make sure that some of the holds have different shelving locations.
2. Build the holds queue. In KTD: perl /kohadevbox/koha/misc/cronjobs/holds/build_holds_queue.pl
3. Notice that the shelving location is in the same column as itemcallnumber
4. Apply patch and restart_all
5. Reload the holds queue and notice that shelving location now has it's own column.
6. Make sure you can sort by shelving location correctly.
7. Re-run the holds queue and apply the filter for shelving location. Make sure all your holds of that shelving location are shown.
8. While in the holds queue try usiong the 'Shelving location' filter on the left side of the page, make sure it works right.
9. Go to Admin > Table settings. Try hiding the shelving location column and reload the holds queue to make sure it is properly hidden.
10. Try hiding some other columns via Table settings to make sure all columns are still properly being hid.
Comment 2 Rachael 2022-06-30 18:32:33 UTC
patch does not apply
Comment 3 Juliet Heltibridle 2023-06-08 14:45:54 UTC
*** Bug 33889 has been marked as a duplicate of this bug. ***
Comment 4 Lucas Gass (lukeg) 2024-06-27 20:06:23 UTC
Created attachment 168217 [details] [review]
Bug 30411: Put shelving location into its own column in holds queue

To test:
1. Put some items on hold, make some bib level holds and some item level holds. Make sure that some of the holds have different shelving locations.
2. Build the holds queue. In KTD: perl /kohadevbox/koha/misc/cronjobs/holds/build_holds_queue.pl
3. Notice that the shelving location is in the same column as itemcallnumber
4. Apply patch and restart_all
5. Reload the holds queue and notice that shelving location now has it's own column.
6. Make sure you can sort by shelving location correctly.
7. Re-run the holds queue and apply the filter for shelving location. Make sure all your holds of that shelving location are shown.
8. While in the holds queue try usiong the 'Shelving location' filter on the left side of the page, make sure it works right.
9. Go to Admin > Table settings. Try hiding the shelving location column and reload the holds queue to make sure it is properly hidden.
10. Try hiding some other columns via Table settings to make sure all columns are still properly being hid.
Comment 5 Owen Leonard 2024-06-27 21:37:04 UTC
In my test the wrong column is getting hidden. It looks like the "columnname: location" in columns_settings.yml is out of sequence?
Comment 6 Lucas Gass (lukeg) 2024-06-28 12:56:20 UTC
Created attachment 168235 [details] [review]
Bug 30411: Put shelving location into its own column in holds queue

To test:
1. Put some items on hold, make some bib level holds and some item level holds. Make sure that some of the holds have different shelving locations.
2. Build the holds queue. In KTD: perl /kohadevbox/koha/misc/cronjobs/holds/build_holds_queue.pl
3. Notice that the shelving location is in the same column as itemcallnumber
4. Apply patch and restart_all
5. Reload the holds queue and notice that shelving location now has it's own column.
6. Make sure you can sort by shelving location correctly.
7. Re-run the holds queue and apply the filter for shelving location. Make sure all your holds of that shelving location are shown.
8. While in the holds queue try usiong the 'Shelving location' filter on the left side of the page, make sure it works right.
9. Go to Admin > Table settings. Try hiding the shelving location column and reload the holds queue to make sure it is properly hidden.
10. Try hiding some other columns via Table settings to make sure all columns are still properly being hid.
Comment 7 Lucas Gass (lukeg) 2024-06-28 12:57:14 UTC
(In reply to Owen Leonard from comment #5)
> In my test the wrong column is getting hidden. It looks like the
> "columnname: location" in columns_settings.yml is out of sequence?

Oops, thanks for testing. Revised and reset to NSO.
Comment 8 Owen Leonard 2024-06-28 13:41:10 UTC
Created attachment 168238 [details] [review]
Bug 30411: Put shelving location into its own column in holds queue

To test:
1. Put some items on hold, make some bib level holds and some item
   level holds. Make sure that some of the holds have different shelving
   locations.
2. Build the holds queue. In KTD: perl
   /kohadevbox/koha/misc/cronjobs/holds/build_holds_queue.pl
3. Notice that the shelving location is in the same column as
   itemcallnumber
4. Apply patch and restart_all
5. Reload the holds queue and notice that shelving location now has it's
   own column.
6. Make sure you can sort by shelving location correctly.
7. Re-run the holds queue and apply the filter for shelving location.
   Make sure all your holds of that shelving location are shown.
8. While in the holds queue try usiong the 'Shelving location' filter on
   the left side of the page, make sure it works right.
9. Go to Admin > Table settings. Try hiding the shelving location column
   and reload the holds queue to make sure it is properly hidden.
10. Try hiding some other columns via Table settings to make sure all
    columns are still properly being hid.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Comment 9 Matt Blenkinsop 2024-06-28 14:20:21 UTC
Created attachment 168244 [details] [review]
Bug 30411: Put shelving location into its own column in holds queue

To test:
1. Put some items on hold, make some bib level holds and some item
   level holds. Make sure that some of the holds have different shelving
   locations.
2. Build the holds queue. In KTD: perl
   /kohadevbox/koha/misc/cronjobs/holds/build_holds_queue.pl
3. Notice that the shelving location is in the same column as
   itemcallnumber
4. Apply patch and restart_all
5. Reload the holds queue and notice that shelving location now has it's
   own column.
6. Make sure you can sort by shelving location correctly.
7. Re-run the holds queue and apply the filter for shelving location.
   Make sure all your holds of that shelving location are shown.
8. While in the holds queue try usiong the 'Shelving location' filter on
   the left side of the page, make sure it works right.
9. Go to Admin > Table settings. Try hiding the shelving location column
   and reload the holds queue to make sure it is properly hidden.
10. Try hiding some other columns via Table settings to make sure all
    columns are still properly being hid.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Comment 10 Katrin Fischer 2024-07-01 16:51:55 UTC
Hm sequence... I don't think we have a real standard there. I would have probably put the location after the Home library, instead of having the collection between, but not a blocker for me.
Comment 11 Katrin Fischer 2024-07-01 16:58:08 UTC
Pushed for 24.11!

Well done everyone, thank you!
Comment 12 Lucas Gass (lukeg) 2024-07-01 17:01:56 UTC
(In reply to Katrin Fischer from comment #10)
> Hm sequence... I don't think we have a real standard there. I would have
> probably put the location after the Home library, instead of having the
> collection between, but not a blocker for me.

I'm happy to file a follow-up if you would like to follow a more standard sequence.
Comment 13 Katrin Fischer 2024-07-01 17:05:46 UTC
I think orienting ourselves at the items/holdings table might be an idea. Maybe if we can get one more vote for this to be one way or the other :) (and just heading out for the day too)