[Koha-bugs] [Bug 14816] New: Item search returns no results with multiple values selected for one field

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

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

            Bug ID: 14816
           Summary: Item search returns no results with multiple values
                    selected for one field
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Searching
          Assignee: gmcharlt at gmail.com
          Reporter: kyle.m.hall at gmail.com
        QA Contact: testopia at bugs.koha-community.org

If you select multiple values from the pulldown for a give field ( e.g. home
library ), the search will never return results. I believe this issue is due to
the fact that the query is using IN but is treating the entire list of values
for the IN as a single string to be quoted, instead of a list of comma
separated string to be quoted individually.

'str' => '(homebranch IN (?))'
'args' => 'CPL,FFL,FPL,FRL,IPT,LPL,MPL,MY,PVL,RPL,SPL,TPL,UPL'

-- 
You are receiving this mail because:
You are watching all bug changes.