https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17815 --- Comment #8 from David Cook <dcook@prosentient.com.au> --- (In reply to Katrin Fischer from comment #3)
Can you give us any more data?
I trust with the SQL that the dateaccessioned would be between '2011-09-01' and '2011-09-30', but what about those 9461 results? If you look at a sample of them, do they all have dateaccessioned within that range, or do they have different data?
They have different data. I verified the results with SQL, the Zebra results were clearly wrong. I was not able to verify which items actually showed up in the search.
Can you share a link to your results?
It won't help. I filed a separate bug for the dateaccessioned search not working by entering the index name in keyword search and the search option is only available from the staff side of Koha. It would be interesting tho if someone can see similar (wrong) results on a different data set.
It would be nice to see even a small selection of data to see if anything jumps out at me, but OK. I don't have time to work on this, but maybe Barton can make some headway? I'd try to reproduce the situation, and then maybe use zebra::snippet to see why I'm getting matches which don't make sense for our understanding of the query. Could be that the staff client search template isn't using st-date-normalized, or that the query is processed differently than we expect, or a bug in YAZ/Zebra.. -- You are receiving this mail because: You are watching all bug changes.