Thanks, that helps! Elaine
On Wed, Sep 3, 2014 at 12:08 PM, Nick Clemens <n...@quecheelibrary.org> wrote: > To get the '005' data, I think you have to pull from the marcxml in > biblioitems: > > ExtractValue(marcxml,'//controlfield[@tag="005"]') > > I don't think it is accessible through any of the table directly > > > On Tue, Sep 2, 2014 at 6:39 PM, Elaine Bradtke <e...@efdss.org> wrote: > >> How do I filter records based on the MARC 005? DATE AND TIME OF LATEST >> TRANSACTION >> biblio.timestamp doesn't do it. >> >> This is what I have: >> SELECT >> >> >> biblio.biblionumber,items.barcode,biblio.author,biblio.title,biblio.timestamp,biblio.datecreated >> FROM items LEFT JOIN biblioitems on >> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on >> (biblioitems.biblionumber=biblio.biblionumber) WHERE biblio.timestamp >= >> '2014-05-01' AND biblio.timestamp <= '2014-05-30' ORDER BY >> biblio.biblionumber asc >> >> In the guided report the option I chose was Modification date / >> biblio.timestamp >> >> But after testing this I've discovered that it isn't using the date in >> the >> 005. I'm not sure where the Modification date / biblio.timestamp >> information is coming from, it's neither the creation date, nor the >> modification date, but some other date entirely. >> >> I'm trying to hunt down a batch of records modified on a certain date. >> Thanks for any help. >> >> -- >> Elaine Bradtke >> Data Wrangler >> VWML >> English Folk Dance and Song Society | http://www.efdss.org >> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY >> Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance >> and >> Song Society in London, England. If you wish to phone me personally, send >> an e-mail first. I work off site) >> -------------------------------------------------------------------------- >> Registered Company No. 297142 >> Charity Registered in England and Wales No. 305999 >> >> --------------------------------------------------------------------------- >> "Writing about music is like dancing about architecture" >> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > Nick Clemens > Quechee & Wilder Libraries > n...@quecheelibrary.org > http://www.QuecheeLibrary.org > Q (802) 295-1232 W (802) 295-6341 > -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha