You can try following query: ---------------------- select branchname,count(items.barcode) as Count from items left join branches on (items.holdingbranch= branches.branchcode) group by holdingbranch ------------------------ On Tue, 14 Jul, 2020, 3:38 PM Marites Chavez, < marites.chavez002@deped.gov.ph> wrote:
I mean the total collection of all library holdings of homebranch as in 43 school libraries,
On Tue, Jul 14, 2020, 4:33 PM vikram zadgaonkar < vikramczadgaonkar@gmail.com> wrote:
Hello, Do you want total count of collection library branch wise ?
On Tue, 14 Jul, 2020, 1:41 PM Marites Chavez, < marites.chavez002@deped.gov.ph> wrote:
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
------------------------------ *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.*