Re: [Koha] Report help needed - modification date

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

[Koha] Report help needed - modification date

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