[Koha] Error in report

[Marites Chavez]

Thanks a lot.
Sincerely yours,
*MARITES K. CHAVEZ*
Division Librarian
Learning Resource Management and Development

Department of Education
City Schools Division of Dasmariñas

Phone: (046) 432-9355 <(046)%20432%209355>, 432-9384 loc. 202
Email: marites.chavez002 at deped.gov.ph <katreziafiel.macawile at deped.gov.ph>


On Tue, Jul 14, 2020 at 8:52 PM vikram zadgaonkar <
vikramczadgaonkar at gmail.com> wrote:

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

-- 

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