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.
Karna
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 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 c
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,
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 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 Uniq
Koha 3.16.00.000 installed via packages method, on ubuntu desktop.
On Tue, Nov 25, 2014 at 4:22 PM, vikram zadgaonkar <
vikramczadgaon...@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,
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 gi
More information may help.
"all unique titles(biblio records)"
Unique how? different ISBN? (do they all have ISBN?) Different title?
Same title different edition? Only one item record?
Exactly what information would you like to display in the report?
List of biblio numbers?
Sorted by collection
Hi,
I would like to have report for the entire library collections as indicated
below:
--
Biblio| Biblio Record (title) | Author | edition | publisher | ISBN
| Holdings ( no. of copies)
Number
coun
You have discovered one of the quirks of the system. For biblios with
multiple items it will produce the same information (title, etc.) for each
item. I don't know how to work around that. Maybe someone else does?
Elaine
On Wed, Dec 10, 2014 at 5:12 AM, SATISH wrote:
> Hi,
>
> I would like to
I find the guided reports wizard, frankly, to be very unhelpful, especially
since I work with 50 branch locations in our consortia. I usually write my
own custom reports, as a result, for much more granular control.
To get this kind of data you gave as an example, you have to query and join
three
Hi Heather Braum,
The result is amazing.
Thank you very very much, for the SQL and for your explain, this is what I
was looking for.
Here, I have one more related query, how to achieve for the same tables,
for each collection ( as per collection code).
Because, at various time intervals, library i
At 12:09 AM 12/11/2014 +0530, SATISH wrote:
[snip] how to achieve for the same tables,
for each collection ( as per collection code).
Because, at various time intervals, library inspection team here is most
interested in
knowing how many unique titles and counts as a whole library and also by
co
Thank you both Heather and Paul, for helping me on sql report,
This will help many librarians here.
On Thu, Dec 11, 2014 at 12:43 AM, Paul A
wrote:
> At 12:09 AM 12/11/2014 +0530, SATISH wrote:
>
>> [snip] how to achieve for the same tables,
>> for each collection ( as per collection code).
>> B
Hello,
Previously I received sql help from Heather Braum, regarding generating
unique records, that was a big help. Now, I am looking for generating sql
report, that is.
Background:
I am using 2 kind of item types - (1) book and (2) book bank. ( both are
used to catalogue only books) "Book"- is
Hi Paul,
Your sql code for unique records by collection code works only if one item
type ="book" present by default. I have added one more item type called
="book bank", and added few records to it, and tried to run the query,
fetched with duplicate records. When I search, from where these duplica
Hello,
On Sat, Jan 24, 2015 at 1:17 PM, SATISH wrote:
> can you please help me how to alter this code, so that , It could fetch
> only non-repeatable/unique records ( by collection code -or- merging all
> collections codes) only including item types =book and =book bank.
You have answered your
Hello
Good Morning.
We maintain two item types for books as Books (BK) and Book Bank (BB) just
to accommodate circulation rules/policies. Reason, regular students gets
only 2 books from regular stock and reserved students get 2 additional
books from Book Bank along with regular stock (BK).
And
At 11:00 AM 2/26/2015 +0530, SATISH wrote:
[snip]
And am looking for help for generating unique records (biblio) after
merging both BK and BB. I am trying with following sql, but throwing
errors. Can you please help me over here.
--
Thank you Paul, I made corrections, but the purpose is not solved.
By using "OR" it populates duplicate record.
By maintaining only one kind of item type, I can not make varied
circulation policies (but can generate unique records report for books),
and in this case, for the same user I have to pr
Hi,
I found one solution, but it is not through Koha.
I exported unique records generated by both the item type BB and BK and put
it in a single excel file and applied conditional formating and applied
filter ( to ISBN column, since it is unique) by colour and found the
duplicate biblionumber/tit
At 10:10 AM 2/28/2015 +0530, SATISH wrote:
Hi,
I found one solution, but it is not through Koha.
I exported unique records generated by both the item type BB and BK and
put it in a single excel file and applied conditional formating and
applied filter ( to ISBN column, since it is unique) by co
Satish,
On Sat, Feb 28, 2015 at 10:10 AM, SATISH wrote:
> I found one solution, but it is not through Koha. I exported unique
> records generated by both the item type BB and BK and put
> it in a single excel file and applied conditional formating and applied
> filter ( to ISBN column, since it
Thank you very much Paul, Nick and Indranil,
for your patience reading of my previous posts and valuable and detailed
explanations with examples. I got complete solutions in the context which
I was looking for.. from your answers. Just to accommodate searching within
item type in advanced search,
Hi Paul & Heather,
The report you developed for Satish below is very helpful, but I'd like to
tweak it a little differently - I've tried every variation I can think of with
no luck (I don't have very much SQL experience)... how can I get it to select
by branch, rather than collection code?
SE
Kerrie, to select by homebranch, you just need to add a branch parameter,
i.homebranch=<>
So the statement will now look like
SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement,
t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT
JOIN
biblioitems t USING(bi
items i USING(biblionumber)
GROUP BY b.biblionumber ORDER BY Copies ASC
Regards
Matthew.
--
>
> Message: 4
> Date: Thu, 11 Dec 2014 01:19:06 +
> From: Kerrie Stevens
> Subject: Re: [Koha] Catalogue - SQL Report Help (Paul A)
>
> SELECT DISTINC
ionumber)
> GROUP BY b.biblionumber ORDER BY Copies ASC
>
>
> Regards
>
> Matthew.
>
>
> --
>
>> Message: 4
>> Date: Thu, 11 Dec 2014 01:19:06 +
>> From: Kerrie Stevens
>> Subject: Re: [Koha] Catalogue - SQL Report
>',b.title,'')
AS "Item Title", b.author, t.editionstatement, t.publishercode,
t.isbn, count(i.itemnumber) AS "Copies" FROM biblio b LEFT JOIN
biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber)
GROUP BY b.biblionumber ORDER BY Copies ASC
Regards
28 matches
Mail list logo