[Koha-bugs] [Bug 9552] BIB1 Relation "Greater Than" Attribute Not Mapped Properly in CCL.Properties

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9552

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |Needs Signoff
           Assignee|gmcharlt at gmail.com          |dcook at prosentient.com.au

--- Comment #1 from David Cook <dcook at 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.