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
Nicole, We have a report on our system that looks for 490 tags with the 1
indicator first.
Here's the SQL statement:
select b.biblionumber, b.title, b.author from biblio b join biblioitems i
using (biblionumber) where i.marcxml like '%datafield tag=490 ind1=1%'
Maybe work with that statement
Nicole Engard schreef op di 15-10-2013 om 12:20 [-0500]:
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
3 matches
Mail list logo