Bug 5330

Summary: sorting publication date search does not work
Product: Koha Reporter: Nicole C. Engard <nengard>
Component: SearchingAssignee: Galen Charlton <gmcharlt>
Status: CLOSED INVALID QA Contact: Bugs List <koha-bugs>
Severity: normal    
Priority: P5 - low CC: katrin.fischer
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: search results not sorted right

Description Nicole C. Engard 2010-10-30 19:05:43 UTC
I was looking up Indian cooking books and we catalog all our international cook
books by 641.59 and the country name, in this case India. So, I found an Indian
cook book, clicked on the call number which did an automatic call number search
and listed all our Indian cook books in that call number. I tried to rank the
results by pubdate, newest first and was booted back to the search screen with the following URL:

/cgi-bin/koha/catalogue/search.pl?q%3Dccl=callnum%3A641.59+INDIA&sort_by=pubdate_dsc 

Doing an advanced search in the staff client for call number sorted by publication date works just fine though - with the following URL:  

/cgi-bin/koha/catalogue/search.pl?idx=callnum&q=641.59+INDIA&op=and&idx=kw&op=and&idx=kw&sort_by=pubdate_dsc
Comment 1 Nicole C. Engard 2012-03-07 20:24:39 UTC
I have tested today on 3.6.4 and I still find that sorting by publication date is not showing correct results. See attached.
Comment 2 Nicole C. Engard 2012-03-07 20:25:28 UTC
Created attachment 8063 [details]
search results not sorted right
Comment 3 Katrin Fischer 2012-03-08 08:40:53 UTC
Hi Nicole, I think the sorting uses the normalized publication year in 008, pos 07-10 - Date 1. Have you checked if the values there make sense of the sorting? Perhaps the date is not filled?
Comment 4 Nicole C. Engard 2012-03-11 19:56:41 UTC
Katrin you are right and I was wrong about the staff being sorted right - it's not.