Re: [Koha] Report Help
Dear Chitralekha,
Take this example:
I have one book with 12 copies, 8copies with item type BTECHBKS and 4
copies with item type BCABKS. When i generate report it shows 12 copies for
itemtype BTECHBKS and none for BCABKS.
Is there any way of reporting so that i can get the correct report or i
would have to remove 4 copies and save it as different bib record.
*Regards!*
*Manoj Kumar Misra*
M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.)
Deputy Librarian
SRMGPC
Lucknow
Mob. No.: 09415422579
Alternate E-mail: manojmisrasrm...@gmail.com
On Thu, Apr 10, 2014 at 2:06 AM, Chitralekha [via Koha]
ml-node+s1045719n5793620...@n5.nabble.com wrote:
Please try this SQL report. This is sorted by count.
SELECT CONCAT('a
href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.biblionumber,'/a')
AS biblionumbers,
biblio.author, biblio.title,
COUNT(items.itemnumber) AS ItemCount, ccode, itype
FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
GROUP BY items.biblionumber HAVING (COUNT(*)=1)
ORDER BY ItemCount DESC
On Sat, Apr 5, 2014 at 2:01 PM, manoj382093 [via Koha] [hidden
email]http://user/SendEmail.jtp?type=nodenode=5793620i=0
wrote:
Dear Friends,
I am looking for a report which has list of titles(biblio) their number
of copies(items) by item type and collection code.
--
If you reply to this email, your message will be added to the
discussion below:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html
To unsubscribe from Koha-general, click here.
NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
--
If you reply to this email, your message will be added to the discussion
below:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793620.html
To unsubscribe from Report Help, click
herehttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5793161code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkzMTYxfC0xMDkzNzg1MDg0
.
NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
--
View this message in context:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793704.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help
Liz's report should do what you want if you change the GROUP BY to say
GROUP BY biblionumber, i.itype. (That will list, say, the 14 copies of
Book A that are type x, then the 3 copies that are type y. If you'd rather
have all the type x's list together, then all the type y's, just change the
order: GROUP BY i.itype, biblionumber).
--Katelyn.
Katelyn Browne
Middle/High School Librarian
Capital City Public Charter School
100 Peabody Street NW
Washington, DC 20011
(202) 387-0309 x1745
kbro...@ccpcs.org
http://www.ccpcs.org/library/
On Fri, Apr 11, 2014 at 3:47 AM, manoj382093 manojkumarmi...@gmail.comwrote:
Dear Chitralekha,
Take this example:
I have one book with 12 copies, 8copies with item type BTECHBKS and 4
copies with item type BCABKS. When i generate report it shows 12 copies for
itemtype BTECHBKS and none for BCABKS.
Is there any way of reporting so that i can get the correct report or i
would have to remove 4 copies and save it as different bib record.
*Regards!*
*Manoj Kumar Misra*
M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.)
Deputy Librarian
SRMGPC
Lucknow
Mob. No.: 09415422579
Alternate E-mail: manojmisrasrm...@gmail.com
On Thu, Apr 10, 2014 at 2:06 AM, Chitralekha [via Koha]
ml-node+s1045719n5793620...@n5.nabble.com wrote:
Please try this SQL report. This is sorted by count.
SELECT CONCAT('a href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=
',biblio.biblionumber,'\',biblio.biblionumber,'/a')
AS biblionumbers,
biblio.author, biblio.title,
COUNT(items.itemnumber) AS ItemCount, ccode, itype
FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
GROUP BY items.biblionumber HAVING (COUNT(*)=1)
ORDER BY ItemCount DESC
On Sat, Apr 5, 2014 at 2:01 PM, manoj382093 [via Koha] [hidden email]
http://user/SendEmail.jtp?type=nodenode=5793620i=0
wrote:
Dear Friends,
I am looking for a report which has list of titles(biblio) their number
of copies(items) by item type and collection code.
--
If you reply to this email, your message will be added to the
discussion below:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html
To unsubscribe from Koha-general, click here.
NAML
http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
--
If you reply to this email, your message will be added to the discussion
below:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793620.html
To unsubscribe from Report Help, click here
http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5793161code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkzMTYxfC0xMDkzNzg1MDg0
.
NAML
http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
--
View this message in context:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793704.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] errors, migrating from 3.10.04 to 3.14.04
I've made a a fresh install, dumped *koha_koha.authorised_values_branches* Than, imported *koha_koha.authorised_values_branches* to my koha and everything was ok. pAuthorised Values started to work :) - Koha version: 3.08.04 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/errors-migrating-from-3-10-04-to-3-14-04-tp5793596p5793897.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] irregular serial numbering
Hi, I'm having trouble in defining the numbering pattern for a serial. The serial is weekly (number icreases by one every new week, and is never reset to one), but the volume number increases at the beginning of each new second month. This means every 7, or 8, or 9 weeks (i.e., issues), depending on whether the two months contained 7, 8 or 9 weeks. Would it be possible to define such a numbering pattern with Koha? (FYI, the serial is Nature.) Many thanks and best regards, Giuseppe. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help
Thank you very much Katelyn, it worked.
*Regards!*
*Manoj Kumar Misra*
M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.)
Deputy Librarian
SRMGPC
Lucknow
Mob. No.: 09415422579
Alternate E-mail: manojmisrasrm...@gmail.com
On Fri, Apr 11, 2014 at 4:48 AM, Katelyn Browne [via Koha]
ml-node+s1045719n5793778...@n5.nabble.com wrote:
Liz's report should do what you want if you change the GROUP BY to say
GROUP BY biblionumber, i.itype. (That will list, say, the 14 copies of
Book A that are type x, then the 3 copies that are type y. If you'd rather
have all the type x's list together, then all the type y's, just change
the
order: GROUP BY i.itype, biblionumber).
--Katelyn.
Katelyn Browne
Middle/High School Librarian
Capital City Public Charter School
100 Peabody Street NW
Washington, DC 20011
(202) 387-0309 x1745
[hidden email] http://user/SendEmail.jtp?type=nodenode=5793778i=0
http://www.ccpcs.org/library/
On Fri, Apr 11, 2014 at 3:47 AM, manoj382093 [hidden
email]http://user/SendEmail.jtp?type=nodenode=5793778i=1wrote:
Dear Chitralekha,
Take this example:
I have one book with 12 copies, 8copies with item type BTECHBKS and 4
copies with item type BCABKS. When i generate report it shows 12 copies
for
itemtype BTECHBKS and none for BCABKS.
Is there any way of reporting so that i can get the correct report or i
would have to remove 4 copies and save it as different bib record.
*Regards!*
*Manoj Kumar Misra*
M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.)
Deputy Librarian
SRMGPC
Lucknow
Mob. No.: 09415422579
Alternate E-mail: [hidden
email]http://user/SendEmail.jtp?type=nodenode=5793778i=2
On Thu, Apr 10, 2014 at 2:06 AM, Chitralekha [via Koha]
[hidden email] http://user/SendEmail.jtp?type=nodenode=5793778i=3
wrote:
Please try this SQL report. This is sorted by count.
SELECT CONCAT('a href=\/cgi-bin/koha/catalogue/
detail.pl?biblionumber=
',biblio.biblionumber,'\',biblio.biblionumber,'/a')
AS biblionumbers,
biblio.author, biblio.title,
COUNT(items.itemnumber) AS ItemCount, ccode, itype
FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
GROUP BY items.biblionumber HAVING (COUNT(*)=1)
ORDER BY ItemCount DESC
On Sat, Apr 5, 2014 at 2:01 PM, manoj382093 [via Koha] [hidden
email]
http://user/SendEmail.jtp?type=nodenode=5793620i=0
wrote:
Dear Friends,
I am looking for a report which has list of titles(biblio) their
number
of copies(items) by item type and collection code.
--
If you reply to this email, your message will be added to the
discussion below:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html
To unsubscribe from Koha-general, click here.
NAML
http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
--
If you reply to this email, your message will be added to the
discussion
below:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793620.html
To unsubscribe from Report Help, click here
.
NAML
http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
--
View this message in context:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793704.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list http://koha-community.org
[hidden email] http://user/SendEmail.jtp?type=nodenode=5793778i=4
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list http://koha-community.org
[hidden email] http://user/SendEmail.jtp?type=nodenode=5793778i=5
http://lists.katipo.co.nz/mailman/listinfo/koha
--
If you reply to this email, your message will be added to the discussion
below:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793778.html
To unsubscribe from Report Help, click
herehttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5793161code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkzMTYxfC0xMDkzNzg1MDg0
.
