Bug 16355 - Searching for items added before or after a specific date [add item for label only]
Summary: Searching for items added before or after a specific date [add item for label...
Status: In Discussion
Alias: None
Product: Koha
Classification: Unclassified
Component: Label/patron card printing (show other bugs)
Version: master
Hardware: All All
: P5 - low normal (vote)
Assignee: BestBookBuddies
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-04-26 15:40 UTC by Zeno Tajoli
Modified: 2022-03-31 14:09 UTC (History)
4 users (show)

See Also:
Change sponsored?: Sponsored
Patch complexity: Medium patch
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 16355 - Fix Searching for items added before or after a specific data (920 bytes, patch)
2017-04-01 09:22 UTC, BestBookBuddies
Details | Diff | Splinter Review
Bug 16355: Fix Searching for items added before or after a specific data (1.43 KB, patch)
2018-09-07 02:44 UTC, Mark Tompsett
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Zeno Tajoli 2016-04-26 15:40:29 UTC
Hi,
when I am adding a new batch for labeling
with ../labels/label-item-search.pl
and searching on or after a specific date,

I don't retreive any data. I'm using MARC21
If I use advance search from ../catalogue/search.pl with index
<option value="acqdate,st-date-normalized">Acquisition date (yyyy-mm-dd)</option>
I find same records.
Comment 1 BestBookBuddies 2017-04-01 09:22:56 UTC
Created attachment 61767 [details] [review]
Bug 16355 - Fix Searching for items added before or after a specific data

As specified searching for items added before or after a specific data is not working in Koha 16.x while using MARC-21 format.

After applying this patch desired result is generated.
Comment 2 BestBookBuddies 2017-04-01 09:25:20 UTC
As specified "Searching for items added before or after a specific date" is not working in Koha 16.x while using MARC-21.

After applying this patch, desired result is generated.
Comment 3 Alex Buckley 2017-04-17 06:55:48 UTC
This patch does not apply successfully 

Bug 16355 - Searching for items added before or after a specific date [add item for label only]

61767 - Bug 16355 - Fix Searching for items added before or after a specific data

Apply? [(y)es, (n)o, (i)nteractive] y
Traceback (most recent call last):
  File "/usr/local/bin/git-bz", line 2630, in <module>
    do_apply(*args)
  File "/usr/local/bin/git-bz", line 1755, in do_apply
    users = bug.server.get_xmlrpc_proxy().User.get({ 'names': [patch.attacher] })['users']
  File "/usr/lib/python2.7/xmlrpclib.py", line 1233, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1591, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.7/xmlrpclib.py", line 1273, in request
    return self.single_request(host, handler, request_body, verbose)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1321, in single_request
    response.msg,
xmlrpclib.ProtocolError: <ProtocolError for bugs.koha-community.org/xmlrpc.cgi: 404 Not Found>
Comment 4 Mark Tompsett 2018-09-07 02:44:25 UTC
Created attachment 78497 [details] [review]
Bug 16355: Fix Searching for items added before or after a specific data

As specified searching for items added before or after a specific data
is not working in Koha 16.x while using MARC-21 format.

After applying this patch desired result is generated.
Comment 5 Mark Tompsett 2018-09-07 02:49:51 UTC
(In reply to Alex Buckley from comment #3)
> This patch does not apply successfully 

Because it was a diff, not a patch.
If you downloaded it and then did a:
    patch -p1 < downloaded.diff
Plus a few commands to create the patch with the correct author,
and attempt to maintain comments, it would git bz apply.
I've git bz-ified it.

However, I'm moving this to "In Discussion", because of my reading:
relation.relation
This pattern specifies how a CQL relation is mapped to RPN. The pattern is name of relation operator. Since = is used as separator between CQL pattern and RPN, CQL relations including = cannot be used directly. To avoid a conflict, the names ge, eq, le, must be used for CQL operators, greater-than-or-equal, equal, less-than-or-equal respectively. The RPN pattern is supposed to include a relation attribute.
(https://software.indexdata.com/yaz/doc/tools.html#ccl.syntax)

I do not know if this is the correct solution, and I think someone more versed in CCL and the inner query workings of Koha is better suited to say yay or nay to this.