http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9552 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff Assignee|gmcharlt@gmail.com |dcook@prosentient.com.au --- Comment #1 from David Cook <dcook@prosentient.com.au> --- Created attachment 15082 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15082&action=edit Bug 9552 - BIB1 Relation "Greater Than" Attribute Not Mapped Properly in CCL.Properties Currently, you can use "lt,le,eq,ge" in your CCL query to handle "lesser than, lesser or equal to, equal to, greater than or equal to" relationships. The only one missing is "gt" (Bib1 2=5). The mappings are also off "ne, phonetic, stem", but those are Bib1 attributes that Zebra doesn't support, so that's not really relevant. --- To test: Before applying patch... 1) On the OPAC or Intranet search bar, type in the following: pqf=@attr 1=32 @attr 2=5 "2009" (feel free to substitute any other number in for 2009 or any other phrase Use attribute you like which contains a number that can be compared - for instance, 31, which is pubdate) 2) Now, type in the following: acqdate,gt:2009 or ccl=acqdate,gt:2009 3) You'll notice that you get "No results found!", even though it should be the exact same query! 4) Apply patch 5) Re-try steps 1 and 2 6) Notice that your results will be identical for both the pqf and ccl queries. (Another note: This test will only work if you have items in your database that have dateaccessioned information that has been mapped to the 952$d field. If the test fails, try @attr 1=31 in step 1 and pubdate,gt in step 2) ---- This is a very simple patch that adds a correct mapping for "greater than" relationships. As far as I can tell, using the actual <, <=, >, >= signs don't actually work in search queries, so we should probably include the reference to "lt,le,gt,ge" in the Koha documentation. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9552 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #15082|0 |1 is obsolete| | --- Comment #2 from Galen Charlton <gmcharlt@gmail.com> --- Created attachment 15086 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15086&action=edit Bug 9552 - BIB1 Relation "Greater Than" Attribute Not Mapped Properly in CCL.Properties Currently, you can use "lt,le,eq,ge" in your CCL query to handle "lesser than, lesser or equal to, equal to, greater than or equal to" relationships. The only one missing is "gt" (Bib1 2=5). The mappings are also off "ne, phonetic, stem", but those are Bib1 attributes that Zebra doesn't support, so that's not really relevant. To test: [1] Before applying the patch, try the following query in the OPAC: pubdate,gt:2006 You should get "no results found". [2] After applying the patch (and note that ccl.properties will usually need to be installed in the run-time Zebra configuration directory), try the same search. This time, you could get back the titles whose publication date is after 2006. Signed-off-by: Galen Charlton <gmc@esilibrary.com> -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9552 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #15086|0 |1 is obsolete| | --- Comment #4 from Jonathan Druart <jonathan.druart@biblibre.com> --- Created attachment 15094 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15094&action=edit Bug 9552 - BIB1 Relation "Greater Than" Attribute Not Mapped Properly in CCL.Properties Currently, you can use "lt,le,eq,ge" in your CCL query to handle "lesser than, lesser or equal to, equal to, greater than or equal to" relationships. The only one missing is "gt" (Bib1 2=5). The mappings are also off "ne, phonetic, stem", but those are Bib1 attributes that Zebra doesn't support, so that's not really relevant. To test: [1] Before applying the patch, try the following query in the OPAC: pubdate,gt:2006 You should get "no results found". [2] After applying the patch (and note that ccl.properties will usually need to be installed in the run-time Zebra configuration directory), try the same search. This time, you could get back the titles whose publication date is after 2006. Signed-off-by: Galen Charlton <gmc@esilibrary.com> Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com> -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9552 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master --- Comment #5 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- This patch has been pushed to master. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9552 --- Comment #7 from David Cook <dcook@prosentient.com.au> --- It's worth pointing out that many of these Bib-1 Relation Attributes won't work for you if you're using ICU indexing. Apparently, there is due to a known bug in Zebra. For more details, consult the following link: http://lists.indexdata.dk/pipermail/zebralist/2009-April/002190.html -- You are receiving this mail because: You are watching all bug changes.