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@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@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@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@lincolncolibrarydist.org