[Koha] SQL Report: List of all authority records created

[vanda koha]

Hi Jane and Stefano,

Many thanks for your help! It is exactly what I was looking for ;).

Best regards,

Vanda

2017-03-09 2:29 GMT+00:00 Jane Cothron <jcothron at lincolncolibrarydist.org>:

> Here's one that we got from ByWater:
> select authid, datecreated,
> ExtractValue( marcxml, '//datafield[@tag="100"]/*') AS Personal_Name,
> ExtractValue( marcxml, '//datafield[@tag="110"]/*') AS Corporate_Name,
> ExtractValue( marcxml, '//datafield[@tag="111"]/*') AS Conference_Name,
> ExtractValue( marcxml, '//datafield[@tag="130"]/*') AS Uniform_Title
> FROM auth_header
> WHERE date(datecreated) BETWEEN <<Created BETWEEN (yyyy-mm-dd)>> AND <<and
> (yyyy-mm-dd)>> ORDER by authid
>
> On Wed, Mar 8, 2017 at 6:17 AM, vanda koha <vandakoha at gmail.com> wrote:
>
>> Hi everybody,
>>
>> Does anyone know how to do a SQL Report in order to get a list of all the
>> authority records we have already created in a period of time? And can we
>> sort
>> it by alphabetical order?
>>
>> Many thanks.
>>
>> Vanda
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>
> --
> Jane Cothron
> Cataloger
> Lincoln County Library District
> P.O. Box 2027
> Newport, Oregon 97365
> 541-265-3066 <(541)%20265-3066> (phone & fax)
> jcothron at lincolncolibrarydist.org
>