[Koha] Koha report

2013-11-07 Thread Leslie A. Markey
Hello Koha Community, Does anyone have a report that gives a list of bib records (by title) that have no item records? Leslie Leslie A. Markey Technical Services Librarian Brooks Memorial Library 224 Main St. Brattleboro, VT 05301 (802) 254-5290 x112 http://brookslibraryvt.org/

Re: [Koha] Koha report

2013-11-07 Thread Paul A
At 05:57 AM 11/7/2013 -0500, Leslie A. Markey wrote: Hello Koha Community, Does anyone have a report that gives a list of bib records (by title) that have no item records? Simplistic, but functional: SELECT biblio.biblionumber AS BibNum, biblio.title AS Title, biblio.author AS Author, items.

Re: [Koha] Koha report

2013-11-07 Thread Owen Leonard
> Simplistic, but functional: > > SELECT biblio.biblionumber AS BibNum, biblio.title AS Title, biblio.author > AS Author, items.barcode AS Barcode > FROM biblio > RIGHT JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber > LEFT JOIN items ON biblio.biblionumber=items.biblionumber > WHE

[Koha] Koha Report Library problem

2017-03-08 Thread Przemek Kosiński
Hi. I noticed that on the website Koha reports (https://wiki.koha-community.org/wiki/SQL_Reports_Library) gone wrong formatting SQL reports. All reports now look like this: SELECT biblioclass="sy0">.title, biblioclass="sy0">.author, issuesclass="sy0"> Any chance to correct this?

[Koha] Koha Report: Subject wise count

2015-07-07 Thread venkat narayana Thandu
Dear Professionals, Request to provide the SQL report to get the total number of books (not titles) within a subject. Thanks & Best Regards, T. Venkata Narayana Hyderabad ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://l

Re: [Koha] Koha Report Library problem

2017-03-08 Thread Chris Cormack
Ah yes, someone edited it today and messed it all up. Ill roll it back Chris On 08/03/17 21:11, Przemek Kosiński wrote: > Hi. > > I noticed that on the website Koha reports > (https://wiki.koha-community.org/wiki/SQL_Reports_Library) gone wrong > formatting SQL reports. > All reports now look li

Re: [Koha] Koha Report: Subject wise count

2015-07-07 Thread Indranil Das Gupta
Hi Venkat, These two SQL reports may be of use to you. Doesn't do exactly what you have asked but close enough for you to modify them to fit your requirement http://wiki.koha-community.org/wiki/SQL_Reports_Library#Bibs_with_specific_keyword_in_subjects http://wiki.koha-community.org/wiki/SQL_Rep

[Koha] KOHA Report : Number of bib and Item based on Subject

2017-02-13 Thread book guardian
Greeting, I am looking your help for KOHA report. I need a report that can provide me total number of bib and item based on subject heading. Since i have a few branch library it will be good if i can be filter by branch also. I have go through KOHA wiki report but could not found the solution. Yo

Re: [Koha] KOHA Report : Number of bib and Item based on Subject

2017-02-23 Thread Owen Leonard
Hi Carl, Your message to the list was put in my spam folder by GMail so I didn't see it until now. (Messages originating from Nabble.com usually do). > I am looking your help for KOHA report. I need a report that can provide me > total number of bib and item based on subject heading. This report