Thanks, that helps! Elaine On Wed, Sep 3, 2014 at 12:08 PM, Nick Clemens <nick@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 <eb@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 Nick@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)