Re: [Koha] SQL report - Date issues

2017-03-08 Thread Kerrie Stevens
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

Re: [Koha] SQL report - Date issues

2017-03-08 Thread ramirouvia .
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

[Koha] SQL report - Date issues

2017-03-07 Thread Kerrie Stevens
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