Bug 38946

Summary: Add serial enumeration to inventory table
Product: Koha Reporter: Benjamin Daeuber <bdaeuber>
Component: Staff interfaceAssignee: David Cook <dcook>
Status: Signed Off --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: dcook, gmcharlt, lucas, ludovic.julien
Version: 24.05   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40702
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Bug 38946: Add enumchron to inventory table
Bug 38946: Add enumchron to inventory table
Default sort of callnumber

Description Benjamin Daeuber 2025-01-22 15:34:18 UTC
It would be helpful to add serial enumeration to the outputted inventory table. If you are inventorying a series of items with the same title, but different issue number or years, there's currently no easy way of distinguishing them in the output.
Comment 1 Katrin Fischer 2025-01-22 16:22:02 UTC
+1 :)
Comment 2 David Cook 2025-08-26 06:54:03 UTC
I've had a library asking for this as well. 

The table is already pretty crowded, but it does look doable.
Comment 3 David Cook 2025-08-26 07:04:57 UTC
Created attachment 185786 [details] [review]
Bug 38946: Add enumchron to inventory table

This patch adds "Serial enumeration / chronology" to the inventory table
output.

Test plan:
0. Apply the patch
1. Go to http://localhost:8081/cgi-bin/koha/tools/inventory.pl
2. Click "Submit"
3. Note that a "Serial enumeration / chronology" column appears in
the results
4. For the top result, go into the bib record and then add a "Serial enumeration /
chronology" to the item in question
5. Re-run the inventory
6. Note that the "Serial enumeration / chronology" now has a value in iy
7. Click "Columns" and hide the column
8. Try again using the CSV export and note that the new column appears again
Comment 4 Lin Wei 2025-09-04 14:27:24 UTC
Created attachment 186160 [details] [review]
Bug 38946: Add enumchron to inventory table

This patch adds "Serial enumeration / chronology" to the inventory table
output.

Test plan:
0. Apply the patch
1. Go to http://localhost:8081/cgi-bin/koha/tools/inventory.pl
2. Click "Submit"
3. Note that a "Serial enumeration / chronology" column appears in
the results
4. For the top result, go into the bib record and then add a "Serial enumeration /
chronology" to the item in question
5. Re-run the inventory
6. Note that the "Serial enumeration / chronology" now has a value in iy
7. Click "Columns" and hide the column
8. Try again using the CSV export and note that the new column appears again

Signed-off-by: Ludovic Julien <ludovic.julien@inLibro.com>
Comment 5 Lucas Gass (lukeg) 2025-10-24 14:18:29 UTC
This now sorts by default on the serial enumeration column:

            inventorydt = $("#inventoryt").kohaTable({
                "pagingType": 'full_numbers',
                "bKohaColumnsUseNames": true,
                [% IF uploadedbarcodesflag %]
                    // sort on callnumber
                    "order": [[ 2, "asc" ]],
                [% ELSE %]
                    // first column contains checkboxes
                    "columnDefs": [
                        { "orderable": false, "searchable":  false, "targets": [ 0 ] }
                    ],
                    // 3rd column is callnumber
                    "order": [[ 2, "asc" ]],
                [% END %]
Comment 6 David Cook 2025-10-27 00:54:23 UTC
(In reply to Lucas Gass (lukeg) from comment #5)
> This now sorts by default on the serial enumeration column:
> 
>             inventorydt = $("#inventoryt").kohaTable({
>                 "pagingType": 'full_numbers',
>                 "bKohaColumnsUseNames": true,
>                 [% IF uploadedbarcodesflag %]
>                     // sort on callnumber
>                     "order": [[ 2, "asc" ]],
>                 [% ELSE %]
>                     // first column contains checkboxes
>                     "columnDefs": [
>                         { "orderable": false, "searchable":  false,
> "targets": [ 0 ] }
>                     ],
>                     // 3rd column is callnumber
>                     "order": [[ 2, "asc" ]],
>                 [% END %]

Could you provide a bit more information?

For me, that doesn't appear to be true. It still sorts on callnumber, because callnumber is still the 3rd column with serial enumeration coming after it.

I'll attach a screenshot.
Comment 7 David Cook 2025-10-27 00:55:55 UTC
Created attachment 188453 [details]
Default sort of callnumber
Comment 8 David Cook 2025-10-27 00:58:17 UTC
Going to reset to "Signed Off" since it looks good to me, but happy for you to provide some more info to put it back to Failed QA. Maybe I'm looking on the wrong screen.

I was just following the test plan and it looks good to me?