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 <jcoth...@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 <vandak...@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) > jcoth...@lincolncolibrarydist.org > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
