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,
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
Satish,
On Sat, Feb 28, 2015 at 10:10 AM, SATISH lis4sat...@gmail.com 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
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
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
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.
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).
Hello,
On Sat, Jan 24, 2015 at 1:17 PM, SATISH lis4sat...@gmail.com 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
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 duplicate
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
: Kerrie Stevens kstev...@harvest.edu.au
Subject: Re: [Koha] Catalogue - SQL Report Help (Paul A)
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(biblionumber) LEFT JOIN
: Kerrie Stevens kstev...@harvest.edu.au
Subject: Re: [Koha] Catalogue - SQL Report Help (Paul A)
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(biblionumber) LEFT JOIN items i
(biblionumber) LEFT JOIN 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 kstev...@harvest.edu.au
Subject: Re: [Koha] Catalogue - SQL Report Help (Paul
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 lis4sat...@gmail.com wrote:
Hi,
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
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 pau...@navalmarinearchive.com
wrote:
At 12:09 AM 12/11/2014 +0530, SATISH wrote:
[snip] how to achieve for the same tables,
for each collection ( as
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?
Kerrie, to select by homebranch, you just need to add a branch parameter,
i.homebranch=choose branch|branches
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
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
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
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.
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 lis4sat...@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
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
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 lis4sat...@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
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, SATISH
26 matches
Mail list logo