[Koha] Report help needed - modification date

[Elaine Bradtke]

Thanks, that helps!
Elaine



On Wed, Sep 3, 2014 at 12:08 PM, Nick Clemens <nick at 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 at 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 at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>
> --
> Nick Clemens
> Quechee & Wilder Libraries
> Nick at 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)