Hi, Unfortunately, I have not received any help for generating a report on following subject and, re-described my problem.
I am looking for a report which has list of all unique titles(biblio records) in a home library AND also by collection code. When I tried for nearest relevant SQL examples given in wiki, it gives me, whole list of items along with biblios records that is not useful and I wanted to have information only on unique records (titles). Please advice. with thanks. Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. INDIA. On Tue, Nov 25, 2014 at 4:58 PM, SATISH <lis4sat...@gmail.com> wrote: > Koha 3.16.00.000 installed via packages method, on ubuntu desktop. > > On Tue, Nov 25, 2014 at 4:22 PM, vikram zadgaonkar < > vikramczadgaon...@gmail.com> wrote: > >> Ok. Let me check. I will mail you SQL query. >> Which koha version you are using? >> >> Vikram Zadgaonkar >> >> On Tue, Nov 25, 2014 at 4:20 PM, SATISH <lis4sat...@gmail.com> wrote: >> >>> The same is not available over there. >>> Many examples in the website, fetches for whole items in the library. >>> I need to have report on List of Unique titles available in the library >>> ( i.e., Records) and Total Number of books (i.e.,Items). >>> report should include list of {title,author,publisher,edition, price} >>> not just counts. >>> >>> >>> On Tue, Nov 25, 2014 at 1:40 PM, vikram zadgaonkar < >>> vikramczadgaon...@gmail.com> wrote: >>> >>>> Hi, >>>> You can try following link >>>> http://wiki.koha-community.org/wiki/SQL_Reports_Library >>>> >>>> Vikram Zadgaonkar >>>> >>>> On Tue, Nov 25, 2014 at 1:33 PM, satishamv <lis4sat...@gmail.com> >>>> wrote: >>>> >>>>> Dear Friends, >>>>> I am looking for a report which has list of all unique titles(biblio >>>>> records) in a home library AND also by collection code. >>>>> In my case, new record is created for - change in edition or change in >>>>> item >>>>> type. >>>>> >>>>> >>>>> >>>>> with thanks. >>>>> Satish MV >>>>> Librarian >>>>> Govt. Engineering College, Hassan. >>>>> Karnataka. >>>>> INDIA. >>>>> >>>>> >>>>> >>>>> -- >>>>> View this message in context: >>>>> http://koha.1045719.n5.nabble.com/Catalogue-SQL-Report-Help-tp5820185.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