Hi, Vanda, look at https://wiki.koha-community.org/wiki/SQL_Reports_Library#Authorities_records_added.2Fdeleted_in_time_frame <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Authorities_records_added.2Fdeleted_in_time_frame> or try this (from March 1 to now):
SELECT `authid`, authtypecode, concat( ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), -- PERSO ExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), -- CORPO ExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), -- MEETI ExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), -- UNIF ExtractValue(`marcxml`,'//datafield[@tag="150"]/*') -- TOPIC ) sort FROM `auth_header` WHERE datecreated BETWEEN '2017-03-01' AND NOW() ORDER BY `authtypecode`, sort Stefano > 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
