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
