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/
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.
> 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
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?
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
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
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
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
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
9 matches
Mail list logo