From fa71a092c8e1090b14c2c464f83482f47ffdcd63 Mon Sep 17 00:00:00 2001 From: David Cook Date: Wed, 6 Feb 2013 13:49:28 +1100 Subject: [PATCH] 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) --- etc/zebradb/ccl.properties | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/etc/zebradb/ccl.properties b/etc/zebradb/ccl.properties index f93de96..a5de010 100644 --- a/etc/zebradb/ccl.properties +++ b/etc/zebradb/ccl.properties @@ -867,9 +867,10 @@ lt 2=1 le 2=2 eq 2=3 ge 2=4 -ne 2=5 -phonetic 2=6 -stem 2=100 +gt 2=5 +ne 2=6 +phonetic 2=100 +stem 2=101 relevance 2=102 rk 2=102 rank relevance -- 1.7.7.4