15 Oct
2013
15 Oct
'13
7:20 p.m.
Hi all, Anyone know if there is a way to query a marc field based on the indicator value. I have this report (which works): select b.title, b.author, ExtractValue(m.marcxml,'//datafield[@tag="521"]/subfield[@code>="a"]') AS lexile from biblio b left join biblioitems m using (biblionumber) where ExtractValue(m.marcxml,'//datafield[@tag="521"]/subfield[@code>="a"]') between <<Lexile between>> and <<and>> But I want to only query 521s that have a 8# in the indicators. My report will find all of the below: 521 2# - TARGET AUDIENCE NOTE Target audience note 4-8. 521 0# - TARGET AUDIENCE NOTE Target audience note 8.8. 521 8# - TARGET AUDIENCE NOTE Target audience note 1150 But I only want the last one. Nicole