[Koha] Error in report

[Alvaro Cornejo]

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 at 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 at deped.gov.ph <katreziafiel.macawile at 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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>