From here: http://manual.koha-community.org/3.6/en/XSLTiTypes.html
leader6 = a (and one of the leader7 values below)
leader7 = a
leader7 = c
leader7 = d
leader7 = m
leader6 = t
On Tue, Apr 3, 2012 at 7:43 PM, Chris Cormack ch...@bigballofwax.co.nz
On 4 April 2012 15:19, Nicole Engard neng...@gmail.com wrote:
From here: http://manual.koha-community.org/3.6/en/XSLTiTypes.html
leader6 = a (and one of the leader7 values below)
leader7 = a
leader7 = c
leader7 = d
leader7 = m
leader6 = t
Something
I'm looking to alter this report
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Total_Collection_Size_by_Date
to give me the count of items that were in the collection on that date
- that means checking the deleted items to see what was added and
deleted on the date that's entered and
...@lists.katipo.co.nz] *On Behalf Of *Peel Lisa
*Sent:* Wednesday, October 19, 2011 3:08 PM
*To:* 'koha@lists.katipo.co.nz'
*Subject:* [Koha] report help - total amount writeoff
Hello
Report help again I am afraid!
Could anyone supply me with the SQL for a report which will show me the
amount of fines
Hello everyone,
I need a report that shows the average age of our item collections at
specific branches. I've looked at the pre-made sql reports on the
Koha-Community pages but nothing there is useful for this report and I've also
tried to make my own with no success.
I would be grateful
Thanks a bunch! This appears to work. I'll post this to the wiki in
your name so that you get credit for the work and so that others can
benefit from this.
Nicole
2011/8/17 Msgr. Marion J. Makarewicz marmak3...@att.net:
SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber,
i.barcode,
Message-
From: Nicole Engard [mailto:neng...@gmail.com]
Sent: Thursday, July 28, 2011 5:02 PM
To: Grobani, Daniel
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Report Help - Extracting XML
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href=\/cgi-bin/koha/catalogue
Daniel,
That part I knew :) it was getting it in to the query (the joining) I
was having trouble with :)
Nicole
On Wed, Jul 27, 2011 at 8:00 PM, Daniel Grobani
dgrob...@samuelmerritt.edu wrote:
Nicole,
This should give you the 520a:
extractValue(biblioitems.marcxml,
ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)?
Daniel
-Original Message-
From: Nicole Engard [mailto:neng...@gmail.com]
Sent: Thursday, July 28, 2011 4:36 AM
To: Grobani, Daniel
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Report Help - Extracting XML
Daniel,
That part I knew
Try this (I also did some light cleanup):
SELECT COUNT(statistics.datetime) AS circs,
CONCAT(' \/cgi- ',biblio.title,' ') AS Title,
CONCAT(' \http://mycatalogv/cgi-
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.title,'/a')
AS Title, CONCAT('a
stick.
Daniel
-Original Message-
From: Nicole Engard [mailto:neng...@gmail.com]
Sent: Thursday, July 28, 2011 5:02 PM
To: Grobani, Daniel
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Report Help - Extracting XML
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href
Hello all,
I need some report assistance. I want to add the summary (520a) to this report:
select count(statistics.datetime) as circs, CONCAT('a
href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.title,'/a')
AS Title, CONCAT('a
Nicole,
This should give you the 520a:
extractValue(biblioitems.marcxml,
collection/record/datafield[@tag='520'][1]/subfield[@code='a'])
Of course, you'll have to do a join on biblioitems.
-
Cheers,
Daniel Grobani
Library Technology Specialist
John A. Graziano Memorial Library
Samuel
Hi all,
I wrote this report to get all subject headings in a Koha system that
start with key phrases:
SELECT lcsh
FROM
(SELECT biblionumber,
ExtractValue(marcxml,'//datafield[@tag=610]/subfield[@code=a]')
AS lcsh FROM biblioitems)
AS subjects
WHERE lcsh
LIKE College%
OR lcsh LIKE Seminary%
GROUP
Hi Nicole,
On Fri, Jul 1, 2011 at 9:33 AM, Nicole Engard neng...@gmail.com wrote:
Hi all,
I wrote this report to get all subject headings in a Koha system that
start with key phrases:
SELECT lcsh
FROM
(SELECT biblionumber,
ExtractValue(marcxml,'//datafield[@tag=610]/subfield[@code=a]')
Unfortunately, that's just the way that ExtractValue works. From the
manual:
If multiple matches are found, the content of the first child text node of
each matching element is returned (in the order matched) as a single,
space-delimited string.
Since MARC doesn't give us any means of
On Fri, Jul 1, 2011 at 9:52 AM, Ian Walls
ian.wa...@bywatersolutions.comwrote:
Unfortunately, that's just the way that ExtractValue works. From the
manual:
If multiple matches are found, the content of the first child text node of
each matching element is returned (in the order matched) as
I wrote this report to get all subject headings in a Koha system that
start with key phrases:
You can get your headings with a Perl script.
You can also export all your biblio records in ISO2709 and then combine
various standard Linux commands to extract and select your headings.
For
On Fri, Jul 1, 2011 at 10:19 AM, Nicole Engard neng...@gmail.com wrote:
On Fri, Jul 1, 2011 at 10:09 AM, Chris Nighswonger
cnighswon...@foundations.edu wrote:
The sad thing is if it was comma or otherwise delimited we could do some
splitting foo. But spaces will inevitably appear in the
Is this run at the MySQL level or in the reports module?
* * * *
Beverly Church
LibLime Project Manager
phone: 1-888-564-2457 ext. 717
1-301-654-8088 ext. 292
email: bchu...@liblime.com
skype: beverlychurch
On Wed, May 25, 2011 at 4:23 PM, Nicole Engard neng...@gmail.com wrote:
MySQL 5.1 or greater is required. The queries should work either from the
reports module, or directly on the MySQL command line.
-Ian
2011/5/25 Church, Beverly bchu...@liblime.com
Is this run at the MySQL level or in the reports module?
* * * *
Beverly Church
LibLime Project Manager
Bev,
I wrote that gnarly marcxml-parsing query you offered below because at the
time, LLEK was running on a pre-5.1 version of MySQL and I couldn't use the
simpler ExtractValue().
I just ran cait's query that Nicole offered from the SQL Reports Library
against our LLEK report server and it
101 - 123 of 123 matches
Mail list logo