[Koha] Catalogue - SQL Report Help

[SATISH]

Koha 3.16.00.000 installed via packages method, on ubuntu desktop.

On Tue, Nov 25, 2014 at 4:22 PM, vikram zadgaonkar <
vikramczadgaonkar at 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 at 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 at 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 at 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 at lists.katipo.co.nz
>>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>>>
>>>
>>>
>>
>>
>> --
>>
>>
>>
>>
>


--