Koha 3.16.00.000 installed via packages method, on ubuntu desktop. On Tue, Nov 25, 2014 at 4:22 PM, vikram zadgaonkar < [email protected]> 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 <[email protected]> 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 < >> [email protected]> 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 <[email protected]> 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 >>>> [email protected] >>>> http://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>> >>> >> >> >> -- >> >> >> >> > -- _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha

