[Koha-bugs] [Bug 14277] Search index 'lex' does not honor MARC indicator "ind1"

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

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

Barton Chittenden <barton at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #46002|0                           |1
        is obsolete|                            |

--- Comment #4 from Barton Chittenden <barton at bywatersolutions.com> ---
Created attachment 46005
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=46005&action=edit
Test data

Query for test data:

select
        biblionumber,
        title,
        ExtractValue( marcxml,
'//datafield[@tag=521][@ind1=0]/subfield[@code="a"]' ) as 'Reading grade
level',
        ExtractValue( marcxml,
'//datafield[@tag=521][@ind1=1]/subfield[@code="a"]' ) as 'Interest age level',
        ExtractValue( marcxml,
'//datafield[@tag=521][@ind1=2]/subfield[@code="a"]' ) as 'Interest grade
level',
        ExtractValue( marcxml,
'//datafield[@tag=521][@ind1=8]/subfield[@code="a"]' ) as 'Lexile number'
from
        biblioitems
        inner join biblio using (biblionumber)
where
        biblionumber in ( 86147 , 88090 , 89886 , 90198 , 90669 , 221316 ,
221317 , 221318 , 221319 , 221320 )


+--------------+--------------------------+---------------------+--------------------+----------------------+----------------+
| biblionumber | title                    | Reading grade level | Interest age
level | Interest grade level | Lexile number  |
+--------------+--------------------------+---------------------+--------------------+----------------------+----------------+
|        86147 | Laura Ingalls Wilder     | 5.0 4. 6.1          | 7-11.        
     | 5-8 2-6.             | Lexile 780 780 |
|        88090 | Poppleton forever        | 1.                  | 4-7.         
     | P-3.                 | Lexile 410 410 |
|        89886 | The music of dolphins    | 6.                  | 11-13.       
     | 5-9.                 | 560            |
|        90198 | Worth                    | 4.5.                | 9-12.        
     | 4-7.                 | T 830          |
|        90669 | Monday with a mad genius | 3.8.                | 6-9.         
     | 1-4.                 | 590 590        |
|       221316 | Persian cats /           | 0.5.                | 4-8.         
     | K-3 0-2.             | 580            |
|       221317 | Maine coon cats /        | 0.5.                | 4-8.         
     | K-3 0-2.             | 600            |
|       221318 | Calico cats /            | 0.5.                | 4-8.         
     | K-3 0-2.             | 510            |
|       221319 | Scottish fold cats /     | 0.5.                | 4-8.         
     | K-3 0-2.             | 550            |
|       221320 | Siamese cats /           | 0.5.                | 4-8.         
     | K-3 0-2.             | 480            |
+--------------+--------------------------+---------------------+--------------------+----------------------+----------------+

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