Bug 36499

Summary: Add last checkout date column to the item search results
Product: Koha Reporter: Laura Escamilla <Laura.escamilla>
Component: SearchingAssignee: Laura Escamilla <Laura.escamilla>
Status: RESOLVED FIXED QA Contact: Emily Lamancusa (emlam) <emily.lamancusa>
Severity: enhancement    
Priority: P5 - low CC: caroline.cyr-la-rose, emily.lamancusa, fridolin.somers, m.de.rooy, mspinney
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Caroline Cyr La Rose Documentation submission: https://gitlab.com/koha-community/koha-manual/-/merge_requests/898
Text to go in the release notes:
Version(s) released in:
24.05.00
Circulation function:
Attachments: Bug 36499: Added datelastborrowed column to item search results
Bug 36499: Added datelastborrowed column to item search results
Bug 36499: Added datelastborrowed column to item search results

Description Laura Escamilla 2024-04-03 02:04:11 UTC
When doing an item search some libraries would find it useful if there was a column showing the date last borrowed.
Comment 1 Laura Escamilla 2024-04-04 13:34:15 UTC
Created attachment 164423 [details] [review]
Bug 36499: Added datelastborrowed column to item search results

Test plan:
1. Apply patch
2. Checkout an item to a patron
3. Perform an item search and either search as is, or add a “Last checkout date:” of today’s date for a more refined search.
    1. Notice that there is now a date last borrowed column by the date due column
    2. Export the table into a CSV and notice that there is also a date last borrowed column there
4. Sign off and have an amazing day :D
Comment 2 ByWater Sandboxes 2024-04-04 15:17:21 UTC
Created attachment 164428 [details] [review]
Bug 36499: Added datelastborrowed column to item search results

Test plan:
1. Apply patch
2. Checkout an item to a patron
3. Perform an item search and either search as is, or add a “Last checkout date:” of today’s date for a more refined search.
    1. Notice that there is now a date last borrowed column by the date due column
    2. Export the table into a CSV and notice that there is also a date last borrowed column there
4. Sign off and have an amazing day :D

Signed-off-by: Michelle Spinney <mspinney@clamsnet.org>
Comment 3 Marcel de Rooy 2024-04-12 08:55:14 UTC
(In reply to Laura Escamilla from comment #0)
> When doing an item search some libraries would find it useful if there was a
> column showing the date last borrowed.

Sounds like an enh to me ?
Comment 4 Laura Escamilla 2024-04-12 10:08:50 UTC
(In reply to Marcel de Rooy from comment #3)

> Sounds like an enh to me ?

Yes - thank you for updating the status, Marcel!
Comment 5 Emily Lamancusa (emlam) 2024-04-17 20:15:43 UTC
Created attachment 165033 [details] [review]
Bug 36499: Added datelastborrowed column to item search results

Test plan:
1. Apply patch
2. Checkout an item to a patron
3. Perform an item search and either search as is, or add a “Last checkout date:” of today’s date for a more refined search.
    1. Notice that there is now a date last borrowed column by the date due column
    2. Export the table into a CSV and notice that there is also a date last borrowed column there
4. Sign off and have an amazing day :D

Signed-off-by: Michelle Spinney <mspinney@clamsnet.org>
Signed-off-by: Emily Lamancusa <emily.lamancusa@montgomerycountymd.gov>
Comment 6 Katrin Fischer 2024-04-29 07:10:55 UTC
I am really hesitant about adding more columns to the item search results without having column configuration. I have decided to push this one, because we already have a search option for 'last checkout date' so this adds consistency between search and results. But I might hold off to add more.
Comment 7 Katrin Fischer 2024-04-29 07:44:05 UTC
Pushed for 24.05!

Well done everyone, thank you!
Comment 8 Fridolin Somers 2024-05-24 09:41:33 UTC
Not backported to 23.11.x