http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14277
Barton Chittenden <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #46002|0 |1 is obsolete| | --- Comment #4 from Barton Chittenden <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
