[Koha] Report Help
Chitralekha
chitralekhachitale at gmail.com
Thu Apr 10 21:06:23 NZST 2014
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] <
ml-node+s1045719n5793161h33 at n5.nabble.com> 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<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3047918&code=Y2hpdHJhbGVraGFjaGl0YWxlQGdtYWlsLmNvbXwzMDQ3OTE4fDE5NDY2MzM0MjE=>
> .
> NAML<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=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-tp5793161p5793620.html
Sent from the Koha-general mailing list archive at Nabble.com.
More information about the Koha
mailing list