Bug 16355

Summary: Searching for items added before or after a specific date [add item for label only]
Product: Koha Reporter: Zeno Tajoli <ztajoli>
Component: Label/patron card printingAssignee: BestBookBuddies <info>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: alexbuckley, info, mtompset, shi-yao.wang
Version: master   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14527
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
Bug 16355: Fix Searching for items added before or after a specific data

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.
Comment 6 Katrin Fischer 2023-09-09 19:50:39 UTC
I believe this has been resolved by bug 20765.

*** This bug has been marked as a duplicate of bug 20765 ***