[Koha-bugs] [Bug 17832] New: arl (accelerated reading level) and ard (? -- Title point value) searches do not return results

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17832

            Bug ID: 17832
           Summary: arl (accelerated reading level) and ard (? -- Title
                    point value) searches do not return results
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Searching
          Assignee: gmcharlt at gmail.com
          Reporter: barton at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

Prepending "arl:" or "ard:" to search terms should use the "ard" or "arl"
indexes.

arl should index 526$c, and ard should index 526$d.

Here are some values for 526$c, taken from the koha database backing
http://catalog.bywatersolutions.com/.

select biblionumber, title,  ExtractValue( marcxml,
'//datafield[@tag=526]/subfield[@code="c"]' ) as 'arl' from biblioitems inner
join biblio using (biblionumber) where ExtractValue( marcxml,
'//datafield[@tag=526]/subfield[@code="c"]' ) != '' limit 10;                   
+--------------+-----------------------------------------------+-----------------+
| biblionumber | title                                         | arl           
 |
+--------------+-----------------------------------------------+-----------------+
|        33556 | Boy, were we wrong about dinosaurs! /         | 5.0           
 |
|        37781 | Who really discovered America? :              | 100           
 |
|        39460 | Mummies in the morning /                      | 2.7 grade
level |
|        45646 | Endymion Spring /                             | 6.3           
 |
|        47364 | The year we disappeared :                     | 5.7           
 |
|        48039 | There was an old lady who swallowed Fly Guy / | 1.6           
 |
|        48041 | Ants /                                        | 1.5 1.0       
 |
|        48042 | The Arabian horse /                           | 3.5 4.9       
 |
|        48043 | Athena /                                      | 4.4 4.4       
 |
|        48044 | Aunts /                                       | 1.3 0.9       
 |
+--------------+-----------------------------------------------+-----------------+
10 rows in set (5.19 sec)

... so a search of "arl: 2.7 grade level" *should* return results for at least
"Mummies in the morning /"

Instead
http://catalog.bywatersolutions.com/cgi-bin/koha/opac-search.pl?idx=&q=arl%3A+2.7+grade+level&branch_group_limit=

returns no results.

Likewise for ard

select biblionumber, title,  ExtractValue( marcxml,
'//datafield[@tag=526]/subfield[@code="d"]' ) as 'ard' from biblioitems inner
join biblio using (biblionumber) where ExtractValue( marcxml,
'//datafield[@tag=526]/subfield[@code="d"]' ) != '' limit 10
+--------------+-----------------------------------------------+----------+
| biblionumber | title                                         | ard      |
+--------------+-----------------------------------------------+----------+
|        33556 | Boy, were we wrong about dinosaurs! /         | 0.5      |
|        37781 | Who really discovered America? :              | 2000     |
|        39460 | Mummies in the morning /                      | 1.0 pts. |
|        45646 | Endymion Spring /                             | 13.      |
|        47364 | The year we disappeared :                     | 13       |
|        48039 | There was an old lady who swallowed Fly Guy / | 0.5      |
|        48041 | Ants /                                        | 1 0.5    |
|        48042 | The Arabian horse /                           | 3 0.5    |
|        48043 | Athena /                                      | 3 0.5    |
|        48044 | Aunts /                                       | 1 0.5    |
+--------------+-----------------------------------------------+----------+

A search for "ard: 1.0 pts" should return "Mummies in the morning /"

But
http://catalog.bywatersolutions.com/cgi-bin/koha/opac-search.pl?idx=&q=ard%3A+1.0+pts&branch_group_limit=

Does not.

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