[Koha] Error in report

[vikram zadgaonkar]

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 at 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 at 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 at 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 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
>>>
>>
> ------------------------------
> *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.*