Bug 17841

Summary: Can't use indexname "acqdate,st-date-normalized" in keyword search
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: SearchingAssignee: Galen Charlton <gmcharlt>
Status: CLOSED WORKSFORME QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low CC: fridolin.somers
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20765
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Katrin Fischer 2017-01-03 22:18:48 UTC
It is possible to search for acquisition date from the advanced search in staff. But if you try to use the index name for an 'expert search' in the keyword search field, no results will come up.

Example:
Advanced search > acquisition date: 2016-12* (or whatever works for you)
This should give correct results.

Enter acqdate,st-date-normalized: 2016-12* into the keyword search - no results will appear.

Something seems to be missing in order to make it possible to construct the same search manually.
Comment 1 Fridolin Somers 2018-05-14 14:13:45 UTC
Wildcard * is not a CCL syntax.

One must use "rt" (right truncation) :
  acqdate,rt:2016-12

You may use "ge" (greater or equal) or "le" or "gt" or "lt", with "st-date-normalized" :
  acqdate,ge,st-date-normalized:2016-12-01

Funny thing "acqdate,st-date-normalized,ge" does not work.
Comment 2 Katrin Fischer 2022-04-01 12:10:36 UTC
Frido, that took a while, but it works, I think also with ge at the end in 20.11.

Thanks!