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.