ramirou...@gmail.com]
Sent: Wednesday, March 8, 2017 10:54 PM
To: Kerrie Stevens
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] SQL report - Date issues
Try this:
SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml
FROM biblioitems
JOIN biblio
ON biblioitems.biblionumb
Try this:
SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml
FROM biblioitems
JOIN biblio
ON biblioitems.biblionumber=biblio.biblionumber
WHERE ExtractValue( marcxml, '//datafield[@tag="505"]/*' ) = "" and
biblio.copyrightdate is null and ExtractValue( marcxml,
'//datafield
I have a report that picks out items that have no contents (505) added and also
have no date entered. The problem is that the report is picking up materials
that do have dates entered in both the 260 or 264 fields, so it is not working
100% correctly.
Can anyone give me some pointers to get it
3 matches
Mail list logo