Bug 5330 - sorting publication date search does not work
Summary: sorting publication date search does not work
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-30 19:05 UTC by Nicole C. Engard
Modified: 2012-10-26 00:51 UTC (History)
1 user (show)

See Also:
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 (142.62 KB, image/png)
2012-03-07 20:25 UTC, Nicole C. Engard
Details

Note You need to log in before you can comment on or make changes to this bug.
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.