[Koha] Catalogue - SQL Report Help

[SATISH]

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 at 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 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
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>
>
>
> --
>
>
>
>


--