Hi, Vanda, look at https://wiki.koha-community.org/wiki/SQL_Reports_Library#Authorities_records... <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