[Bug 8032] New: sort lists by call number
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 Priority: P5 - low Change sponsored?: --- Bug ID: 8032 Assignee: gmcharlt@gmail.com Summary: sort lists by call number Severity: enhancement Classification: Unclassified OS: All Reporter: melia@bywatersolutions.com Hardware: All Status: NEW Version: master Component: Virtual Shelves Product: Koha Public and private lists can currently be edited to sort by Author, Title or Year. Can a fourth option be added? We'd love to be able to sort lists by call number. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 JA <pussman@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |pussman@gmail.com --- Comment #1 from JA <pussman@gmail.com> --- Hi. It would be very helpfull if we could sort by "Date added". Another great feature it would be the "Export to CSV" option to the Lists. Thanks -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 M. de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |m.de.rooy@rijksmuseum.nl Assignee|gmcharlt@gmail.com |m.de.rooy@rijksmuseum.nl Summary|sort lists by call number |Sort lists by call number -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 M. de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #2 from M. de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to comment #1)
Another great feature it would be the "Export to CSV" option to the Lists.
I will use this report for a patch that sorts lists by call number (as in the title). Could you save your additional request on a new separate report? Thanks. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #3 from M. de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 13308 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=13308&action=edit Patch for sorting lists on callnumber Precaution: Joining the items table makes that the table is sorted on the item call number of the first item (in case there are more items). -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 M. de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #4 from M. de Rooy <m.de.rooy@rijksmuseum.nl> --- Please include following values of OPACXSLTResultsDisplay ("default" and clearing the field) when testing display of lists in OPAC. Also check display in staff client. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #5 from Melia Meggs <melia@bywatersolutions.com> --- Here is what I did to test. Staff client: 1. I edited an existing public list to sort it by call number. I can now see a call number column when I look at the list, which appears to be sorted correctly. 2. I created a new public list sorted by call number. I added 8 items to it from search results, and they appeared on the list correctly sorted by call number. 3. I edited an existing private list to sort it by call number. I can now see a call number column when I look at the list, which appears to be sorted correctly. 4. I created a new private list sorted by call number. I added 12 items to it from search results, and they appeared on the list correctly sorted by call number. OPAC (with OPACXSLTResultsDisplay set to "default"): 1. I viewed a public list that is sorted by call number, and it is correctly sorted. I am not able to see the call number of one item that is Checked Out, but it is sorted in the correct place on the list, so everything looks ok. I also viewed a public list that is sorted by title, and it still looks correct. 2. I created a new private list sorted by call number. I added 4 items to it from search results, and they appeared on the list correctly sorted by call number. I then resorted by title, and everything looks good. The only question is that when I go to Lists in the OPAC, I see four columns: List name, Contents, Type, but the fourth column is empty and has no heading. Is the fourth column (furthest to the right) supposed to tell me how the list is sorted? Right now, I have no indication that a particular list is sorted by call number or title unless I try to edit the list. But this blank fourth column looks like it's that way on master as well, so I don't think this patch made any change to that... OPAC (with OPACXSLTResultsDisplay left empty): 1. I viewed a public list, and it is sorted correctly by call number. 2. I viewed a private list, and it is sorted correctly by call number. (Now I can also see the call number of that one item that is Checked Out.) One thing I noticed here is that there are squares that appear between some words when you go to edit a list. I have attached a screenshot. (See Lists -square- Dreams -square- Editing). Not sure if this might be browser related. I am using Chrome if that matters. Overall, I think this patch works beautifully, so I am signing off! -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 Melia Meggs <melia@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #13308|0 |1 is obsolete| | --- Comment #6 from Melia Meggs <melia@bywatersolutions.com> --- Created attachment 13317 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=13317&action=edit [Signed off] Bug 8032: Sort lists by call number Precaution: Joining the items table makes that the table is sorted on the item call number of the first item (in case there are more items). Signed-off-by: Melia Meggs <melia@test.bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 Melia Meggs <melia@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #7 from Melia Meggs <melia@bywatersolutions.com> --- Created attachment 13318 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=13318&action=edit squares between some words in OPAC -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #8 from M. de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to comment #7)
Created attachment 13318 [details] squares between some words in OPAC
You found another problem! The caret.gif seems to be moved in master now. It is found now in ccsr subdir. Try: http://yourserver/opac-tmpl/ccsr/images/caret.gif So the template contains a wrong path. The alternative should be: > (>) Template contains: <img src="[% themelang %]/../images/caret.gif" width="16" height="16" alt=">" border="0" /> Thx for signoff! -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #9 from Owen Leonard <oleonard@myacpl.org> --- (In reply to comment #8)
(In reply to comment #7)
Created attachment 13318 [details] squares between some words in OPAC
You found another problem! The caret.gif seems to be moved in master now. It is found now in ccsr subdir.
There is a follow up on bug 7500 for this. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA CC| |jonathan.druart@biblibre.co | |m Patch complexity|--- |Small patch --- Comment #10 from Jonathan Druart <jonathan.druart@biblibre.com> --- QA Comment: This patch adds a new sort for lists. Add/edit a list and set the sort value to callnumber. The results (opac and intranet) are sorted by callnumber. The patch works as expected. The patch uses an existed esoteric way to pass the sort parameter to the templates (sort_$sort => 1 or author_sort => 1 if $sort eq 'author'), it would be great to standardize this stuff. It is not the goal of this patch. Marked as Passed QA. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- QA Contact| |jonathan.druart@biblibre.co | |m -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |9167 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #11 from Jonathan Druart <jonathan.druart@biblibre.com> --- Created attachment 13775 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=13775&action=edit Bug 9167: Standardize the sort field copyrightdate for lists How to reproduce the issue: Create a list at the OPAC and select the sort field 'year'. Go to the list management page at the intranet: the sort field "copyrightdate" is not selected by default. How to test this patch: Check the issue is not still present with this patch. Create several lists at the OPAC with different sort field. Check results are consistent on both interfaces. Check the selected sort field is selected on the edit page. Check there is no regression. What this patch does: - change the way to send the selected sort field to the templates - remove the select tests on the new list page (useless) - the copyrightdate sortfield is named "copyrightdate" everywhere - update your database : set virtualshelves.sortfield = 'copyrightdate' if virtualshelves.sortfield = 'year' -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #12 from M. de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to comment #11) You are in the wrong report? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #13775|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 --- Comment #13 from Jonathan Druart <jonathan.druart@biblibre.com> --- (In reply to comment #12)
(In reply to comment #11) You are in the wrong report?
Oops, yes -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8032 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master CC| |jcamins@cpbibliography.com --- Comment #14 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- This patch has been pushed to master. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org