[Koha] Report connecting bibliographic records and holdings

Dear Sirs, we need a report that allows us to connect the information in a bibliographic record with the number of copies associated with it. We use the following syntax as a base, but we're missing a total number of copies per title: SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="10

Re: [Koha] Report generation

Warning: what I don't know about SQL queries would fill a book, but I've adapted one that works for us. SELECT biblionumber, ExtractValue(`metadata`,'//datafield[@tag="521"]/*') FROM `biblio_metadata` WHERE ExtractValue(`metadata`,'count(//datafield[@tag="521"])>0') If that works you could also d

Re: [Koha] Report generation

Hope this helps, Barbara -- Barbara Johnson Technical Services Manager Bedford Public Library 2424 Forest Ridge Drive, Bedford, TX 76021-4667 Office: 817-952-2360 | Fax: 817-952-2396 | barbara.john...@bedfordtx.gov From: Koha on behalf of zen zenitram Sent

Re: [Koha] Report generation

We need cataloging report thats shows Tag 521 or Tag 526. On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni wrote: > What kind of report are you trying to generate ? > You can get many here > https://wiki.koha-community.org/wiki/SQL_Reports_Library > > Ketan > > On Tue, Mar 28, 2023 at 9:47 AM zen

[Koha] Report generation

Hello Any one know how to create report in sql, of your collection that has Tag 521 and 526 in your output. Thank you! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koh

[Koha] Report help needed

Forwarding this to the list. Joel's suggestion fixed the problems. Elaine VWML <https://vwml.org> -- Forwarded message - From: Coehoorn, Joel Date: Tue, May 10, 2022 at 11:20 AM Subject: Re: [Koha] Report help needed To: Elaine Bradtke It could just be my email

Re: [Koha] Report help needed

Hi Elaine, I guess there is a space missing before FROM in ...main_headingFROM `auth_header`... And also a colon after GENRE/FORM) Else you can try your SQL by parts and start by the basics. Something like SELECT authid, datecreated, authtypecode, concat(ExtractValue(`marcxml`,'//datafield[@tag

[Koha] Report help needed

I imported the following report from Mana, but it doesn't work as is. I tried changing `marcxml` to `metadata` but it still didn't work. The error message (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at

[Koha] report to show the listing of titles entered by each Librarian

Good morning, This report allows you to view the number of items entered for each Librarian. SELECT concat(p.firstname, ' ', p.surname) AS Operador, concat(a.action, ' ', a.info) AS Ação, count(a.timestamp) AS Quantidade FROM action_logs a LEFT JOIN borrowers p ON (a.user=p.borrowernumber) WHERE a

Re: [Koha] Report help needed

r AS sub3 that is not needed. > I was able to get the report to run on my system after taking out the , > Lisette > -Original Message- > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Elaine > Bradtke > Sent: Tuesday, January 5, 2021 11:10 AM > To: koha

Re: [Koha] Report help needed

Subject: [Koha] Report help needed I'm trying to find records lacking 300 fields. The following keeps failing. Any help would be appreciated. Thanks! SELECT CONCAT('',biblionumber,'') AS bibnumber FROM (SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag=&q

Re: [Koha] Report help needed

Hi Elaine, I notice that you compare to >= so it will include other subfields bigger than... . Can you try changing this to read just =? Katrin On 05.01.21 20:10, Elaine Bradtke wrote: I'm trying to find records lacking 300 fields. The following keeps failing. Any help would be appreciated. T

[Koha] Report help needed

I'm trying to find records lacking 300 fields. The following keeps failing. Any help would be appreciated. Thanks! SELECT CONCAT('',biblionumber,'') AS bibnumber FROM (SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="a"]') AS suba, ExtractValue(metadata,'//data

Re: [Koha] report behaves differently if run from intranet or the outside [SOLVED]

Hi Alvaro, the number of rows that can be requested via the JSON web service by default is configurable with the SvcMaxReportRows system preference. But it looks like you also found a workaround! Hope this helps, Katrin On 11.07.20 18:38, Alvaro Cornejo wrote: Hi I found the solution: Place

Re: [Koha] report behaves differently if run from intranet or the outside [SOLVED]

Hi I found the solution: Place a "LIMIT XXX" at the end of the report. It seems that there is a hard limit for public reports that gets overridden if a LIMIT statement is placed on the query. Regards, Alvaro |

Re: [Koha] report behaves differently if run from intranet or the outside

Hi It seems to be a problem with the public setup of the report. Hard limit somewhere in the code? I changed almost all my reports to public to test and in all cases, I get no more than the first 10 records. I initially thought something crashed on the process but json files are completed, not c

[Koha] report behaves differently if run from intranet or the outside

Hi I´ve been working with a report to get records stats and found a strange behaviour. The exactly same report provides different data if run it from the report interface in koha than calling it from the outside (public link) either from a perl script or from a browser (tested on ie / chrome) Th

Re: [Koha] Report help needed

I do not know about the speed and I'm not an expert either. The beauty of the reports is that we can borrow them from others, save them and change them as needed, right? It is the same as the former query 'ExtractValue(marcxml' changing to ExtractValue(metadata'. All of the reports in the reports

Re: [Koha] Report help needed

Excerpts from Michael Sutherland's message of 2020-05-27 16:59:50 -0400: > CASE SUBSTR(metadata,282,2) I tried this myself, and it does seem to work. But I worry that the 282 value might not be correct in the future, should the XML format of the metadata change even slightly. In particular, the

Re: [Koha] Report help needed

Thank you. I'm unfamiliar with that particular bug and will check it out for our records. Best, Michael _ *Michael J. Sutherland* University Libraries Virginia Tech sudrl...@vt.edu | 540.231.9669 <+15402319669> On Wed, May 27, 2020 at 7:05 PM Elaine Bradt

Re: [Koha] Report help needed

Not condescending at all, the things I don't know about reports would fill a book. Interesting report you have there by the way. The purpose for mine is to double check the position 06 against the 942 $c because there is a bug 19419 that seems to cause trouble with the 008 if the Leader 06 is not s

Re: [Koha] Report help needed

Elaine, Maybe this would be helpful for those codes - https://www.loc.gov/marc/bibliographic/bdleader.html And, to break it down for those that do not know and are interested, (at the risk of condescending, which is not my intention, please, please, I hope you do not take it that way) in the exp

Re: [Koha] Report help needed

Yes, I think I've got it now. Thanks for your help. The hard part was figuring out where to find the itemtype in the bib record. SELECT biblio.biblionumber, SUBSTRING(ExtractValue(metadata,'//leader'),7,1) AS "Position06" FROM biblio LEFT JOIN biblio_metadata USING (biblionumber) WHERE ExtractVal

Re: [Koha] Report help needed

Hi Elaine, The biblioitems.marcxml field has been moved to biblio_metadata.metadata. Does this query work as you want: SELECT CONCAT('',b.biblionumber,'') AS biblionumber FROM biblio b LEFT JOIN biblioitems bi ON b.biblionumber= bi.biblionumber LEFT JOIN biblio_metadata bm ON b.biblionumber=bm.b

[Koha] Report help needed

What I'd like it to do - give a list of biblio numbers for records with a particular itemtype, and the information found in the Leader *06 - Type of record *field. I found the following in the reports library as something that could be modified to fit my needs. But it doesn't work I get the follo

Re: [Koha] Report schema questions re: mapping biblio.copyrightdate

Thank you Henry, I'll try that workaround! Regards, Jason -- Message: 1 Date: Wed, 6 May 2020 07:45:09 + From: "BOLSHAW, Henry" To: "koha@lists.katipo.co.nz" Subject: Re: [Koha] Report sch

Re: [Koha] Report schema questions re: mapping biblio.copyrightdate

te: Tue, 5 May 2020 15:55:38 + From: Jason Vasche mailto:jvas...@roundrocktexas.gov>> To: "koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>" mailto:koha@lists.katipo.co.nz>> Subject: [Koha] Report schema questions re: mapping biblio.copyrightdate

[Koha] Report schema questions re: mapping biblio.copyrightdate

Greetings Koha community, I recently ran a report that included biblio.copyrightdate as a display, but many of the records - including those with correct 008 and 264 _1 fields in the bib record - showed up in my report with no copyright date displayed. Upon further digging, I found that the d

Re: [Koha] Report help needed - lost items

Very late to the party, but maybe this could provide a clue. The following throws an error, but I believe the basic idea of finding records where the lowest itemlost value isn't zero is on the right track: WHERE itype = <> GROUP BY biblionumber HAVING MIN(itemlost) > 0 I suspect SQL is sensitive

Re: [Koha] Report help needed - lost items

Mark, that still didn't do the trick, but thanks! Caroline, this is much closer to what I need. But still not quite right. It's messy because I've altered a report that I found in the report library rather inelegantly. What I really need is a list of titles and biblio numbers of biblios where the

Re: [Koha] Report help needed - lost items

Hello Elaine, from what I understand, you want bibliographic information on lost items? I'd need to know exactly the purpose of the report to help you more as there are things in there I don't understand (like why select barcode, when afterwards you group by biblionumber, or why the title is t

Re: [Koha] Report help needed - lost items

Excerpts from Elaine Bradtke's message of 2019-08-23 11:32:44 -0700: > I've got the following adapted from one in the reports library. But I need > to limit it by item type, or not return everything that doesn't have an > item record attached. We've got lots of components in our catalogue that > d

[Koha] Report help needed - lost items

I've got the following adapted from one in the reports library. But I need to limit it by item type, or not return everything that doesn't have an item record attached. We've got lots of components in our catalogue that don't have items and it's returning all of them: SELECT CONCAT(

Re: [Koha] Report

Hi Victor, did you see the Reports Library page for Circulation reports on the wiki? https://wiki.koha-community.org/wiki/SQL_Reports_Circulation Maybe one of those already gets close to what you need. Hope this helps, Katrin On 10.07.19 14:13, Victor Barroso Oliveira wrote: Good Morning, I

[Koha] Report

Good Morning, I need a report that shows all the loans made, refined by library and date. Would anyone have the SQL of this report to send? Thank you, Victor ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.

Re: [Koha] Report for items held by 2 out of 3 branches

Hi, All -- Think the version below should do what we're looking for. (Thank you, Barton!) All best, Cab Vinton SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, i.homebranch, i.itemcallnumber FROM items i LEFT JOIN biblioitems m USING (biblioit

Re: [Koha] Report for items held by 2 out of 3 branches

Good point, I removed that logic. SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, i.homebranch, i.itemcallnumber FROM items i LEFT JOIN biblioitems m USING (biblioitemnumber) LEFT JOIN biblio b ON i.biblionumber = b.biblionumber WHERE i.

Re: [Koha] Report for items held by 2 out of 3 branches

Unless I'm missing the thread somehow, I don't think that will work as the prior conditions for all 3 branches are still present in the WHERE statement. If we eliminate those, then we still need to include the acquisition date condition somehow. Thanks, Cab On Fri, Feb 22, 2019 at 11:11 AM Bar

Re: [Koha] Report for items held by 2 out of 3 branches

you could add count(distinct homebranch) > 1 to your HAVING statement On Fri, Feb 22, 2019 at 9:03 AM Cab Vinton wrote: > Hi, All -- > > We have a report (see below) that generates a random list of items > held by all 3 of our branches & purchased within the past 30 days. > > To generate more

[Koha] Report for items held by 2 out of 3 branches

Hi, All -- We have a report (see below) that generates a random list of items held by all 3 of our branches & purchased within the past 30 days. To generate more titles we'd like to loosen the criteria by specifying that the titles should be held by just 2 of the 3 branches. I know how I'd appro

Re: [Koha] Report Checked out and Checked in report with school class and section

Thank you so much MAMSET LIBRARY. It works well. Great work. On Fri, Feb 8, 2019 at 9:14 AM MAMCET Library wrote: > Report form Checked out > Report SQL: > > SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, > DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date, > p.cardnumber

[Koha] Report Checked out and Checked in report with school class and section

Dear All, I am running Koha 17.11.04.000 in Ubuntu at CBSE school. I have created new field Student class and section in Additional attributes and identifiers. Every day we are taking circulation report "Date wise list of Checked out Books" and also Checked in books. Is it possible to include stu

Re: [Koha] REPORT 100 AND 700 MARC TAG

Or like this, which might (or might not!) be more efficient since it only resorts to ExtractValue if the author is NULL: SELECT IF(b.author IS NULL, ExtractValue(m.metadata, '//datafield[@tag="700"]/subfield[@code="a"]'), b.author ) FROM biblio b

Re: [Koha] REPORT 100 AND 700 MARC TAG

Hi Hans, I'm no SQL expert either, but I usually use CONCAT_WS to have the 100 and 700 authors appear in the same column. Also, check your mappings in Administration > Koha to MARC mapping. You may be able to use biblio.author instead of ExtractValue for the 100 field. So something like SE

[Koha] REPORT 100 AND 700 MARC TAG

Hello everyone, I would like to have a report of only fields 100 and 700 in a single column. I'm a student and I do not understand much about sql, but I've managed to get a 100 report through ExtractValue syntax queries (marcxml, xpath). But I do not know how to get one of the fields 100, 700 in a

Re: [Koha] Report help

Thanks so much Caroline. Perhaps I should look at the statistics wizards more often! Kind regards David Hughes Systems Librarian Dublin Business School 13-14 Aungier St. Dublin 2 Ireland 00 353 1 417 8744 david.hug...@dbs.ie *http://library.dbs.ie * On 3 Aug

Re: [Koha] Report help

Hi David, Did you try with the statistics wizards? If you go in Reports > Statistics wizards > Patrons and then choose your first attribute "CC" as a row and "CD" as a column, it should give you a table with all the different combinations and the count of patrons with that combination. Carol

[Koha] Report help

Hi, I want to create a report that gives a grand total of records with various combinations of two different patron attributes. I have two different borrower_attributes.code values "CC" and "CD" and I want to output the grand totals of records with all permutations of borrower_attributes.attribut

Re: [Koha] Report help needed

Yes, that did the trick! Thanks This is the revised report: SELECT DISTINCT biblionumber, heading FROM ( SELECT biblionumber, ExtractValue(metadata, '//datafield[@tag="100"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="100"]/subf

Re: [Koha] Report help needed

On Fri, Jul 13, 2018 at 10:06:56AM -0700, Elaine Bradtke wrote: > This report finds Authors not linked to authorities. But it only lists > their names (some of them are quite prolific, and sometimes it's only one > biblio that needs checking). > How can I make the following give the biblio number

[Koha] Report help needed

This report finds Authors not linked to authorities. But it only lists their names (some of them are quite prolific, and sometimes it's only one biblio that needs checking). How can I make the following give the biblio number as well as the name? SELECT DISTINCT heading FROM ( SELECT ExtractValu

Re: [Koha] Report for holds count by bib record & branch

Do you need the item type just so you can tell AV from print, etc? If so, you might be able to get it via an ExtractValue: ExtractValue(biblioitems.marcxml, '//datafield[@tag=“942"]/subfield[@code=“c"]')) AS “item type” It would be different for 17.05 and newer, which may require some fiddling.

Re: [Koha] Report for holds count by bib record & branch

Hi, all -- Did some more testing & it appears that Item Type information is not available when holds are placed for the Next Available item. Can't think of an easy work-around as it's entirely possible to have items attached to the same bib with different item types. Cheers, Cab Vinton Plaistow

[Koha] Report for holds count by bib record & branch

Hi, All -- I'm trying to create a report that will give me hold counts broken down by bib record and the patron's branch. I believe what I have is pretty close, but some of the output omits the item type information. This is what I have: SELECT count(borrowers.branchcode) AS Holds, borrowers.br

Re: [Koha] Report help

Hi Mutasem, Can you clarify what you mean by "number of search book in koha"? I can think of a few different interpretations, including: 1) number of times someone searched the OPAC for a book 2) number of books that be retrieved by a search #1 cannot be answered with a report, as far as I know,

[Koha] Report help

Hi, any one can help me, i need report to count number of search book in koha. thank, Mutasem -- -- Disclaimer: This message and its attachment, if any, are confidential and may contain legally privileged information. If you are not the intended recipient, pleas

Re: [Koha] Report help

Yes, sorry, I had done this before for other reports and now forgot to return to it. That did the trick!! Thank you! Katharina On Wed, Feb 21, 2018 at 6:16 PM, Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Hello Katharina, > > Do you see the "Update SQL" button on the repor

Re: [Koha] Report help

Hello Katharina, Do you see the "Update SQL" button on the report list? Did you try it? It is supposed to update the query with the new table structure. Regards, Jonathan On Wed, 21 Feb 2018 at 13:24 Katharina Penner wrote: > We use 17.05, and so I have tried to substitute "marcxml" with > "bi

Re: [Koha] Report help

We use 17.05, and so I have tried to substitute "marcxml" with "biblio_metadata", like recommended at the Wiki page: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC. But I keep getting the following error message: The following error was encountered: The database returned the f

[Koha] Report help

Dear all, I need to create a report to extract all metadata on all authors. I want to have each aspect - surname, name (or initials), dates, expansion of initials, other possible fields - appear in a separate field/column, in a delimited way. We're using UniMarc so these would be fields 700 a, b,

Re: [Koha] Report Error (Patrons w/ Items Issued Today)

Hi Ashok, I notice that there is some whitespace in the wiki entry for this report. Please make sure that the first word of your SQL report is SELECT with no spaces or similar before it. That might fix your problem. I corrected the entry in the wiki. Katrin On 25.08.2017 13:02, Ashok Franc

[Koha] Report Error (Patrons w/ Items Issued Today)

*Dear All, * *When I ran the this report (*Patrons w/ Items Issued Today), I am getting the following error. *The following error was encountered:* The database returned the following error: No SELECT Please check the log for further details. Can anyone you please help me to fix this problem? R

Re: [Koha] Report error (SQL )

Yes , i AM using 17.05 Thanks El 3 ago. 2017 5:25 PM, "John Sterbenz" escribió: > Hello Luis, > > There was a big change in the way MARC data is handled in 17.05. marcxml > is no longer in the biblioitems table--it is now biblio_metadata.metadata > > If you're running 17.05, this would be a gre

Re: [Koha] Report error (SQL )

Hello Luis, There was a big change in the way MARC data is handled in 17.05. marcxml is no longer in the biblioitems table--it is now biblio_metadata.metadata If you're running 17.05, this would be a great place to start looking to update your query. If you're not on 17.05, I'm afraid I don't h

Re: [Koha] Report error (SQL )

Hi Luis, where does it say the field is obsolete? Katrin On 03.08.2017 22:16, Luis Moises Rojas wrote: Hello everybody. We have an sql senteces to extract SUBTITLE (ExtractValue(biblioitems.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]') AS "Subtitulo) but now it say this field is ob

[Koha] Report error (SQL )

Hello everybody. We have an sql senteces to extract SUBTITLE (ExtractValue(biblioitems.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]') AS "Subtitulo) but now it say this field is obsolete. Where is the subttile? Thanks -- *Luis Moisés Rojas P.*

[Koha] Report Generation

Hello everyone, Please, can anyone help me with dB query code to generate a report from my koha database from October last year till date with full list of bibliography entries. Thanks George Eromosele Systems Librarian Sent from Samsung Mobile. ___ K

Re: [Koha] Report

> We found one option: (Tools, warning, Herramientas/Recibos (in spanish)), I think you're in the right place. I would think "Issue slip" (ISSUESLIP) or "Issue Quick Slip" (ISSUEQSLIP) would be the notices you might choose. After configuring them, you would trigger the print by opening the patron

[Koha] Report

Hello everybody, We are trying to borrow books, our only problem is to print a sheet with data to give it to the user as a note, where we could print: Title, ISBN, etc. Where is the option to create that report? We found one option: (Tools, warning, Herramientas/Recibos (in spanish)), We type

Re: [Koha] Report for checkin item by particular staff login

Hi Sahadeo, Use the "Log Viewer" under "Tools". Filter by circulation. Hth, -idg On May 3, 2017 2:40 PM, "Sahadeo Taware" wrote: > Dear Friends > > I required the detailed report which shows that checkout or checkin item > and from which login it is checkout or checkin > > -- > Sahadeo D. Tawar

[Koha] Report for checkin item by particular staff login

Dear Friends I required the detailed report which shows that checkout or checkin item and from which login it is checkout or checkin -- Sahadeo D. Taware Librarian, M.L.I.Sc., NET Thakur College of Science and Commerce Thakur Village, Kandivli(E), Mumbai 400101 Mob. No 9324912816 Office 28870627

Re: [Koha] Koha Report Library problem

Ah yes, someone edited it today and messed it all up. Ill roll it back Chris On 08/03/17 21:11, Przemek Kosiński wrote: > Hi. > > I noticed that on the website Koha reports > (https://wiki.koha-community.org/wiki/SQL_Reports_Library) gone wrong > formatting SQL reports. > All reports now look li

[Koha] Koha Report Library problem

Hi. I noticed that on the website Koha reports (https://wiki.koha-community.org/wiki/SQL_Reports_Library) gone wrong formatting SQL reports. All reports now look like this: SELECT biblioclass="sy0">.title, biblioclass="sy0">.author, issuesclass="sy0"> Any chance to correct this?

Re: [Koha] KOHA Report : Number of bib and Item based on Subject

Hi Carl, Your message to the list was put in my spam folder by GMail so I didn't see it until now. (Messages originating from Nabble.com usually do). > I am looking your help for KOHA report. I need a report that can provide me > total number of bib and item based on subject hea

[Koha] KOHA Report : Number of bib and Item based on Subject

Greeting, I am looking your help for KOHA report. I need a report that can provide me total number of bib and item based on subject heading. Since i have a few branch library it will be good if i can be filter by branch also. I have go through KOHA wiki report but could not found the solution

Re: [Koha] Report for bibs with multiple items with item details

8:45 AM To: Michael May Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Report for bibs with multiple items with item details On Mon, Dec 19, 2016 at 1:25 PM, Michael May mailto:m...@dubuque.lib.ia.us>> wrote: I apologize. I've figured out how to add biblionumbers to a report of all i

Re: [Koha] Report for bibs with multiple items with item details

On Mon, Dec 19, 2016 at 1:25 PM, Michael May wrote: > I apologize. I've figured out how to add biblionumbers to a report of all > items, and then how to identify and isolate duplicates in the downloaded > spreadsheet. This pretty much does what I want. Thanks for listening. :) > -Mike > No need

Re: [Koha] Report for bibs with multiple items with item details

'koha@lists.katipo.co.nz' Subject: Report for bibs with multiple items with item details Hi all, I need to weed DVDs that have multiple copies, so I'm trying to find a downloadable Koha report that shows all bibs with multiple items which includes details about all of those

[Koha] Report for bibs with multiple items with item details

Hi all, I need to weed DVDs that have multiple copies, so I'm trying to find a downloadable Koha report that shows all bibs with multiple items which includes details about all of those items, like barcodes, call numbers, and loan statuses. I see reports at https://wiki.koha-communit

[Koha] Report of staff login reg.

Hi, Could anyone help me out with an SQL query for getting staff record creation/modification statistics along with date of creation and barcode of items? With kind regards, Arun Kishore, B.L.  College Librarian (UGC) Sanatana Dharma College Sanathanapuram (PO) Alappuzha Keralam -  688003 .

Re: [Koha] Report question

he ' with a backslash. Very >> > frustrating! >> > >> > I guess I could use an OR, but I don't know how many values would be >> > passed each time. I guess I'll need to write a custom cgi script which >> > outputs some JSON for what I wa

Re: [Koha] Report question

gt; passed each time. I guess I'll need to write a custom cgi script which > outputs some JSON for what I want. > > Cheers, Stephen > > -Original Message- > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Francois > Charbonnier > Sent: 21 April 2

Re: [Koha] Report question

> > outputs some JSON for what I want. > > > > Cheers, Stephen > > > > -Original Message- > > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of > Francois > > Charbonnier > > Sent: 21 April 2016 17:14 > > To: koha@lis

Re: [Koha] Report question

] On Behalf Of Francois > Charbonnier > Sent: 21 April 2016 17:14 > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Report question > > Hi Stephen, > > I don't see any workaround but right now, it can't work. > > Let's say the <> value is : 34,35,3

Re: [Koha] Report question

x27;ll need to write a custom cgi script which outputs some JSON for what I want. Cheers, Stephen -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Francois Charbonnier Sent: 21 April 2016 17:14 To: koha@lists.katipo.co.nz Subject: Re: [Koha] Repor

Re: [Koha] Report question

If you are comfortable with Perl, what I do quite often is create in the folder koha\intranet\cgi-bin\test the MyReport.pl that points a template MyReport.tt in koha\htdocs\intranet-tmpl\prog\en\modules\test. This way you can create an input form however you like. MyReport.pl would execute the SQL

Re: [Koha] Report question

Hi Stephen, I don't see any workaround but right now, it can't work. Let's say the <> value is : 34,35,36 With the IN operator, you have to get the query this way : IN(34,35,36) but with the <>, you'll get IN('34,35,36') instead. The query will look for the expression '34,35,36' which is not

[Koha] Report question

Hi All - I want to set up a SQL report that can take a variable number of the same value. My SQL looks like: select biblionumber, concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan is null,'Available',onloan) onloan from items,authorised_values,branches where biblionumber in (<

Re: [Koha] Report includes renewals?

Heather, Thank you. Now I know where to look next time. -- Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library cgda...@uintah.utah.gov (435) 789-0091 ext.261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary On Wed, Mar 9, 2016 at 7:21 AM, Heather Br

Re: [Koha] Report includes renewals?

It does -- see in the WHERE clause: WHERE s.type IN ('issue','renew') -Heather Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org "The illiterate of the 21st century will not be those who cannot read and write, but those who cannot lea

[Koha] Report includes renewals?

Dear Colleagues, I need to know whether or not the "Circulation numbers in a time frame for all itemtypes, per branch" report found at includes renewals. Will someone plea

[Koha] Report help: count of certain subfield values

Hi all, I've been pondering how to do this report, but haven't found a good solution: I'd like to have a list of all subfield values for certain subfield from biblioitems, and have counts of the field contents. For example: SELECT count(*), ExtractValue(marcxml, '//datafield[@tag=<>]/su

Re: [Koha] Report help

Hi, Try this: SELECT biblio.title, biblio.author, items.itemcallnumber, lcsh FROM (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]') AS lcsh FROM biblioitems) AS subjects JOIN biblio USING(biblionumber) JOIN items USING(biblionumber) WHERE lcsh LIKE "%KEYWO

[Koha] Report help

This must be simple to fix but I'm not fluent enough in Koha-speak to crack the problem. Would anyone be able to help amend this SQL report, so that the results show the title, author and call number for each entry, instead of a hyperlinked biblionumber? All suggestions gratefully received! Li

Re: [Koha] Report help needed

At 09:00 AM 9/28/2015 -0400, Barton Chittenden wrote: Elaine, This query should do what you're looking for: select biblionumber, from biblioitems where ExtractValue( marcxml, '//datafield[@tag=942]/subfield[@code="c"]' ) = ''; Depending on the number of bibs, this could take quite a while to r

Re: [Koha] Report help needed

Elaine, This query should do what you're looking for: select biblionumber, from biblioitems where ExtractValue( marcxml, '//datafield[@tag=942]/subfield[@code="c"]' ) = ''; Depending on the number of bibs, this could take quite a while to run -- I would try it after hours. Alternatively, if you

[Koha] Report help needed

We have one record in the catalogue that is missing a 942 $c. but I can't find it. I'm looking for a 942$c that is empty. If I could get the biblio number of the problem record, I could fix it. Thanks in advance -- Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org

Re: [Koha] Report for titles with all copies checked out

Thank you so much! This is perfect. Caitlin On Sun, Aug 23, 2015 at 4:36 PM, Josef Moravec wrote: > Hello Caitlin, > > I've just tried to write an SQL which meets your needs and I think > something like this should work for you: > > select b.biblionumber, b.title, b.author, SUM(IF(i.onloan is

Re: [Koha] Report for titles with all copies checked out

Good Morning We have setup overdue notices and slips but unable to send emails. Email is working when creating a new patron account. Please help On Sun, Aug 23, 2015, 5:12 PM Caitlin Kleinpaste wrote: > I've seen the report that gives you all checked out books, but I then have > to go through e

Re: [Koha] Report for titles with all copies checked out

Hello Caitlin, I've just tried to write an SQL which meets your needs and I think something like this should work for you: select b.biblionumber, b.title, b.author, SUM(IF(i.onloan is null, 1, 0)) as available FROM biblio b JOIN items i ON b.biblionumber = i.biblionumber GROUP BY b.biblionumber H

  1   2   3   >