[Koha] Collection code

2021-06-22 Thread Carlo Dumontet
Could anyone please tell me how to create a new Collection Code? Many thanks Carlo ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Collection code

2021-06-22 Thread Magnus Enger
Den 22.06.2021 13:02, skrev Carlo Dumontet: Could anyone please tell me how to create a new Collection Code? - Go to More > Administration > Authorized values - Click on CCODE in the table - Click on the button that says "+ New authorized value for CCODE" https://koha-community.org/manual/20.1

Re: [Koha] Collection Code Totals

2013-11-19 Thread Liz Rea
Hi Kerrie, Try adding on a GROUP BY ccode, as follows: SELECT count(ccode), ccode AS collection FROM items WHERE homebranch = 'VIC' GROUP BY ccode; Cheers, Liz Rea Catalyst IT Ltd. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.n

Re: [Koha] Collection Code Totals

2013-11-19 Thread Chris Cormack
* Kerrie Stevens (kstev...@harvest.edu.au) wrote: > I am trying to run a report to give me the total number of items within each > of our collection codes (we have 5) at each branch but I can only get it show > me the results from one of them... can anyone see where I'm going wrong? > > SELECT c

[Koha] Collection Code Totals

2013-11-19 Thread Kerrie Stevens
I am trying to run a report to give me the total number of items within each of our collection codes (we have 5) at each branch but I can only get it show me the results from one of them... can anyone see where I'm going wrong? SELECT count(ccode), ccode AS collection FROM items WHERE items

Re: [Koha] Collection code & Shelving Location (thandu venkat narayana)

2012-09-27 Thread Sunil Kumar
ically in koha 3.8 (Doug Kingston) 7. Re: Zebra not updating biblios automatically in koha 3.8 (Jared Camins-Esakov) -- Message: 1 Date: Sat, 1 Sep 2012 11:32:39 +0800 (SGT) From: thandu venkat narayana To: koha@l

Re: [Koha] Collection code & Shelving Location

2012-09-01 Thread Olugbenga Adara
/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara --- On Sat, 9/1/12, thandu venkat narayana wrote: From: thandu venkat narayana Subject: [Koha] Collection code & Shelving Location To: koha@lists.katipo.co.nz Date: Saturday, September 1, 2012, 5:32 AM Dear Professionals, Good Mor

[Koha] Collection code & Shelving Location

2012-08-31 Thread thandu venkat narayana
Dear Professionals, Good Morning! I am using koha 3.8.2 on Ubuntu How can I add new collection code & new Shelving Location at adding items i.e. Tag 952 $8 and 952 $c Please give guidance to create the same. Best Regards, Venkata Narayana ___ Koha m