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 <lis4satish@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 < vikramczadgaonkar@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 <lis4satish@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 < vikramczadgaonkar@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 <lis4satish@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
--
--
--