Hi You can try this also SELECT branchname AS Branch, homebranch AS Branchcode, count( DISTINCT biblionumber) AS Records, count(itemnumber) AS Items FROM items LEFT JOIN branches ON (items.homebranch=branches.branchcode) GROUP BY branchname WITH ROLLUP LIMIT 50 Will provide records & items per branch- Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mar. 14 juil. 2020 à 03:11, Marites Chavez < marites.chavez002@deped.gov.ph> a écrit :
Good day. PLease help, How to see the total collection of every branch library in one report? We are using the 19.11 version. Thank you. Regards.
Software error:
Arguments must be MARC::Field object at /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl line 537.
For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.
Email: marites.chavez002@deped.gov.ph <katreziafiel.macawile@deped.gov.ph>
--
***This communication may contain confidential or privileged information, and is intended solely for the individual or entity to whom it is originally addressed. Any disclosure, copying, dissemination, or any action taken in reliance to it by others, other than the intended recipient, is strictly prohibited. The opinions, conclusions, and statements expressed in this message are those of the sender and may not necessarily reflect the views of the Department of Education.** * _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha