Bug 17841 - Can't use indexname "acqdate,st-date-normalized" in keyword search
Summary: Can't use indexname "acqdate,st-date-normalized" in keyword search
Status: CLOSED WORKSFORME
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low minor (vote)
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-03 22:18 UTC by Katrin Fischer
Modified: 2022-12-12 21:24 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

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