Re: [Koha] SQL report

Hey Igor, Try this: SELECT itemnumber, biblionumber, barcode, stocknumber, withdrawn, itemnotes_nonpublic, itype FROM items WHERE stocknumber REGEXP '^[0-9]{4}$' AND itype = "BK"; Beste Grüße, Eugen Bastron > Am 20.02.2025 um 10:11 schrieb Сычев Игорь Алексеевич : > > Hi! > > How do I find

[Koha] SQL report

Hi! How do I find only four digits at the beginning of a string? Example, there are values. 1234 2345 123456 25-1 24-11 VK-2 -123 123* At the exit, I need to get 1234 2345 regexp '^[0-9]{4}' does not give the desired result. My test: SELECT itemnumber, biblionumber, barcode, stocknumber, withd

Re: [Koha] SQL report for URL

Visit item type wise collection SQL report https://libpowertech.blogspot.com/2019/05/department-wise-number-of-books-in-your.html?m=1 On Thu, 20 Jul 2023, 2:32 pm Dr. Prajeesh Bhaskaran, wrote: > Hi > Please, can anyone help me to create a SQL report for getting the URL of > all the items based

[Koha] SQL report for URL

Hi Please, can anyone help me to create a SQL report for getting the URL of all the items based on the collections in Koha. -- With Regards Prajeesh Bhaskaran Reference Assistant (Library) Mahatma Gandhi University, Kerala, India. ___ Koha mailing list

Re: [Koha] Koha SQL report with MARC field

Hi, The metadata was moved to it's own table some time ago. You will need to add this line somewhere in the SELECT ExtractValue(biblio_metadata.metadata, '//datafield[@tag="675"]/subfield[@code="3"]') AS "Informacija" And this line between the last LEFT JOIN and the WHERE LEFT JOIN biblio_m

Re: [Koha] Koha SQL report with MARC field

Hello Tadas, I suppose your MARC field is empty, then. As far as I can tell, field 675 is not used in MARC 21 bibliographic records. https://www.loc.gov/marc/bibliographic/bd6xx.html Maybe try field 657? Or rather take a look at your MARC records and check which field contains the information y

Re: [Koha] Koha SQL report with MARC field

The report starts but does not show all the information. The column is empty Thanks for the help ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha SQL report with MARC field

Hello Tadas, does this work? SELECT i.dateaccessioned AS "Pridejimas", i.barcode AS "Barkodas", b.author AS "Autorius", b.title AS "Pavadinimas", bi.publishercode AS "Leidykla", i.copynumber AS "Inventorinis", bi.isbn AS "ISBN", i.itemnotes AS "Uzrasai", i.ityp

[Koha] Koha SQL report with MARC field

Hello, My Koha 21.05.11 version. I use this report to view the inventory. It works well. The question would be how would I go about adding a MARC field from Record e.g 675$3 Maybe someone has an idea how to add it? SELECT items.dateaccessioned AS Pridėjimas,items.barcode AS Barkodas,biblio.author

Re: [Koha] Koha Sql Report Help

Fine Paid for Library Patrons (Koha SQL Reports Queries) Koha v 18 and above https://libpowertech.blogspot.com/2019/05/fine-paid-for-library-patrons-sql.html?m=1 On Sun, 26 Jun 2022, 7:36 am Shafrizan Affendi, wrote: > Hi, > > Recently I upgraded my Koha from ver 18 to 22.05. Some of my sql repo

[Koha] Koha Sql Report Help

Hi, Recently I upgraded my Koha from ver 18 to 22.05. Some of my sql report are not working anymore. For example to show a fine collection by staff id. Here is my previous sql. SELECT @rownum:=@rownum+1 No, student.borrowernumber, student.cardnumber AS Student_ID, student.s

Re: [Koha] SQL Report of Recently Edited Records

The following will show the last 30 changed biblio records and is ready if you wish to add more conditions on other related tables. It can also be used as a coverflow datasource. SELECT b.biblionumber, i.Barcode, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, c.imagenumber AS localcover F

[Koha] SQL Report of Recently Edited Records

Hi, all! Is it possible to get a SQL report of recently edited records? I looked on the Koha wiki, but I didn't see one. Thanks, all! -- よろしくお願いします。 -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsu

[Koha] SQL report for status change within time period

Hello, Does anyone know if it's possible to write a report that would give me all of the items that have had their status change from Long Lost Overdue to Available within a specified time period? I want to be able to see when long lost overdue books have been turned in so that we can ensure that

Re: [Koha] SQL report to search for series statements and volume numbers

Hi Roger This works exactly as it is needed, and even with correct sorting! Great! I'm not really familiar with the UNION clause but this seems a great way of using it. The SQL statement may be somewhat inefficient but is very effective though. In our database with around 30'000 test records

Re: [Koha] SQL report to search for series statements and volume numbers

Hi Katrin You wrote: > if you use > > ExtractValue(metadata,'//datafield[@tag="490"]/subfield[@code="a"]') = > <> > > and there are multiple 490$a, they will appear as one space separated > string. That means, that you need to use LIKE and truncation with % to > locate the ones with the entry yo

Re: [Koha] SQL report to search for series statements and volume numbers

Hi Michael, an inefficient and quite long running SQL statement for your request might be the following: SELECT s.ser AS series, s.vol AS volume, s.biblionumber FROM ( SELECT ExtractValue(a.metadata,'//datafield[@tag="490"][1]/subfield[@code="a"]') AS ser,

Re: [Koha] SQL report to search for series statements and volume numbers

Hi Michael, if you use ExtractValue(metadata,'//datafield[@tag="490"]/subfield[@code="a"]') = <> and there are multiple 490$a, they will appear as one space separated string. That means, that you need to use LIKE and truncation with % to locate the ones with the entry you are looking for. If y

[Koha] SQL report to search for series statements and volume numbers

Hi Our library is using Debian GNU/Linux 10 and Koha 20.11. We are trying to extract the series statement (MARC 490$a) and volume numbers (MARC 490$v) from the MARCXML data. Some title data records more than one MARC 490 entry. We came up with the following SQL statement: SELECT biblionumber

Re: [Koha] SQL Report Coding need.

need someone who really > understands SQL. Forwarding to the list. > Elaine > VWML <https://vwml.org> > > > > -- Forwarded message - > From: MAMCET Library > Date: Sat, Jan 16, 2021 at 7:30 PM > Subject: Re: [Koha] SQL Report Coding need. >

[Koha] SQL Report Coding need.

Dear all good morning Please send the SQL Patrons Fine payment date wise report coding. Koha version 20.5 -- Thanking you.. Librarian, MAMCET Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105. ___ Koha mailing list

Re: [Koha] [koha] SQL Report for withdrawn books.

Hi, Thanks Katrina and Alvaro for your time and effort. Katrin's suggestion solved my problem. If you have an idea on my string on batch editing dates for withdrawn/lost items to set an earlier one I would be more than happy Thank you all Regards James On Sat, Nov 28, 2020 at 12:39 PM Katrin

Re: [Koha] [koha] SQL Report for withdrawn books.

Hi, when using the |date, use the datepicker to set the date. Koha will automatically convert it to the correct format for the database in your query. I think the issue is that items.itemlost_on is a datetime. So use DATE() to get better results and use the datepicker to enter the dates! AND DAT

Re: [Koha] [koha] SQL Report for withdrawn books.

Hi James You need to define a date format /tell mysql that you are comparing dates with DATE_FORMAT(YOURDATE, '%-%mm-%dd') so your query shall be something like: I´m not sure how will it work with the dates picklers SELECT biblio.author AS Author, biblio.title AS Title, biblioitems.publishe

[Koha] [koha] SQL Report for withdrawn books.

I have the below query which runs well without the date filter. On including the date placeholder, it gives me zero results. What am I missing? I need to be able to select a date range. Please help SELECT biblio.author AS Author, biblio.title AS Title, biblioitems.publishercode AS Publisher,biblio

[Koha] SQL report in-case of repeatable tag

Hello Please help, how to generate sql reports if there is repeatable field having 2 or more data and get the report under two different rows for the repeatable field? Example: If there are more than two URL is given and i wish to get report in two columns and rest of the data in one column only

Re: [Koha] -SQL report on total cost of books

There are a couple here that may be useful, at least for your first question. Bob https://wiki.koha-community.org/wiki/SQL_Reports_Library#Library_Books_Investment_by_Collection_Code On Mon, 9 Mar 2020 at 17:33, Yatheesh lis wrote: > Hi > > I would like to know total cost of books in my librar

[Koha] -SQL report on total cost of books

Hi I would like to know total cost of books in my library Can anyone suggest -SQL query on following details 1) total number books & total cost. 2) total number of books with out cost Thank you ___ Koha mailing list http://koha-community.org Koha@list

Re: [Koha] SQL Report - Authorities. List duplicate values based on 010$a

; <> '' > AND > ExtractValue(A.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') > = > ExtractValue(B.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') > ORDER BY A.authid; > > HTH. St

Re: [Koha] SQL Report - Authorities. List duplicate values based on 010$a

<> '' AND ExtractValue(A.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') = ExtractValue(B.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') ORDER BY A.authid; HTH. Stefano > Subject: [Koha] SQL

Re: [Koha] SQL Report - Authorities. List duplicate values based on 010$a

Hi Craig. I'm not that great at reports, but you might be able to find something in the SQL reports library that could help: https://wiki.koha-community.org/wiki/SQL_Reports_Library David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 m. +64 21 0537 847 On Sun

[Koha] SQL Report - Authorities. List duplicate values based on 010$a

Hi all, Koha 18.11 on Ubunti 16.04 May I request help for an SQL report that does the following, please: Identify and list by authid and main heading all authority records that have a tag 010$a with duplicate values? I am attempting to located all authority records that can be merged (or de-dup

Re: [Koha] SQL Report not populating

o.co.nz] On Behalf Of Barry, > Michael M > Sent: Wednesday, 13 June 2018 9:07 AM > To: koha > Subject: Re: [Koha] SQL Report not populating > > Hi Mark, > > I tried running a different saved report (made with the report wizard, to > produce a list of patrons by categorycod

Re: [Koha] SQL Report not populating

sage- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Barry, Michael M Sent: Wednesday, 13 June 2018 9:07 AM To: koha Subject: Re: [Koha] SQL Report not populating Hi Mark, I tried running a different saved report (made with the report wizard, to produce a list of patrons by ca

Re: [Koha] SQL Report not populating

-boun...@lists.katipo.co.nz] On Behalf Of Mark Alexander Sent: Wednesday, 13 June 2018 1:11 AM To: koha Subject: Re: [Koha] SQL Report not populating I tried your query with the WHERE clause slightly simplified to give a non-empty result on my test installation of 18.05: WHERE (TO_DAYS(cu

Re: [Koha] SQL report with Comma Delimited Paramater

Yes, that's the one. Thanks! On Tue, Jun 12, 2018 at 7:31 AM, Magnus Enger wrote: > On 6 June 2018 at 15:17, Barton Chittenden > wrote: > > This is not currently possible, but if you check the bywatersolutions > > github page, you can find a plugin called 'koha-plugin-reports-plus', or > > some

Re: [Koha] SQL Report not populating

I tried your query with the WHERE clause slightly simplified to give a non-empty result on my test installation of 18.05: WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= '' I was then able to download the CSV file and read it into LibreOffice Calc with no problems. So your query looks good; ma

Re: [Koha] SQL report with Comma Delimited Paramater

On 6 June 2018 at 15:17, Barton Chittenden wrote: > This is not currently possible, but if you check the bywatersolutions > github page, you can find a plugin called 'koha-plugin-reports-plus', or > something similar (on mobile, or I'd link to it). That plugin will allow > you to add a parameter t

Re: [Koha] SQL Report not populating

Hi Michael, I don't see an obvious reason why it would not work. Which version of Koha are you using? Katrin On 08.06.2018 01:12, Barry, Michael M wrote: Hi everyone, I'm having some issues downloading the results of SQL reports. Running Koha 18.05. I'm using the "overdues by homeroom" c

[Koha] SQL Report not populating

Hi everyone, I'm having some issues downloading the results of SQL reports. Running Koha 18.05. I'm using the "overdues by homeroom" code from the Koha Wiki SQL Reports library, as below: SELECT p.surname, p.firstname, c.date_due, g.attribute AS grade, (TO_DAYS(curdate())-TO_DAYS( date_due)

Re: [Koha] SQL report with Comma Delimited Paramater

This is not currently possible, but if you check the bywatersolutions github page, you can find a plugin called 'koha-plugin-reports-plus', or something similar (on mobile, or I'd link to it). That plugin will allow you to add a parameter that lets you enter a list. On Wed, Jun 6, 2018, 07:38 ksor

[Koha] SQL report with Comma Delimited Paramater

Is it possible to create a SQL report using a parameter with comma delimited ids? Specifically I would like to be able to select random, non-contiguous items. The following sql statement works when called directly from mysql: *select * from items where barcode in (3456,2346);* However, when I cr

Re: [Koha] SQL report for list of authorities with occurrences

Dear Andreas, THANK YOU! It works perfectly for me! All best, Caterina De : Andreas Roussos Envoyé : mercredi 30 mai 2018 19:18:11 À : Caterina Sansone Cc : koha@lists.katipo.co.nz Objet : Re: [Koha] SQL report for list of authorities with occurrences Dear

Re: [Koha] SQL report for list of authorities with occurrences

Dear Caterina, Try pasting the following SQL into a Koha report, it should give you the number of occurrences per authority. Please bear in mind that I made the following assumptions: (a) your Topical Subject authorities go in UNIMARC field 606 of your biblios (b) you have no more than 5 subjects

Re: [Koha] SQL report for list of authorities with occurrences

ndreas Roussos Envoyé : mercredi 30 mai 2018 11:35:19 À : Caterina Sansone Cc : koha@lists.katipo.co.nz Objet : Re: [Koha] SQL report for list of authorities with occurrences Dear Caterina, When you say "clean the indexes", do you mean finding _unused_ subject authority records and rem

Re: [Koha] SQL report for list of authorities with occurrences

Dear Caterina, When you say "clean the indexes", do you mean finding _unused_ subject authority records and removing them? If the answer is "yes", have a look at the following thread: https://lists.katipo.co.nz/pipermail/koha/2017-November/049404.html On the other hand, if your intention is to co

[Koha] SQL report for list of authorities with occurrences

Dear all, I have been wandering the web in the last days but couldn't find a solution to my problem : I have a SQL report to obtain a list of authorities (subject : 250a and subfields), but in order to clean the indexes I would like to create a SQL report to obtain a list of authorities with

Re: [Koha] SQL report

> Give privilege to reports by user types? If you mean by this that you'd like to limit some users' access to reports based on their patron category, it's not possible. I'd love to see a feature like that added (perhaps with permissions settings instead). -- Owen -- Web Developer Athens Count

[Koha] SQL report

how I can Give privilege to reports by user types? *Rodrigo Jose Aleman* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL Report: List of all authority records created

Hi Jane and Stefano, Many thanks for your help! It is exactly what I was looking for ;). Best regards, Vanda 2017-03-09 2:29 GMT+00:00 Jane Cothron : > Here's one that we got from ByWater: > select authid, datecreated, > ExtractValue( marcxml, '//datafield[@tag="100"]/*') AS Personal_Name, > E

Re: [Koha] SQL Report: List of all authority records created

Hi, Vanda, look at https://wiki.koha-community.org/wiki/SQL_Reports_Library#Authorities_records_added.2Fdeleted_in_time_frame or try this (from March 1 to now): SELECT `authid`, authtypec

Re: [Koha] SQL report - Date issues

ramirou...@gmail.com] Sent: Wednesday, March 8, 2017 10:54 PM To: Kerrie Stevens Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] SQL report - Date issues Try this: SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml FROM biblioitems JOIN biblio ON biblioitems.biblionumb

[Koha] SQL Report: List of all authority records created

Hi everybody, Does anyone know how to do a SQL Report in order to get a list of all the authority records we have already created in a period of time? And can we sort it by alphabetical order? Many thanks. Vanda ___ Koha mailing list http://koha-commu

Re: [Koha] SQL report - Date issues

Try this: SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml FROM biblioitems JOIN biblio ON biblioitems.biblionumber=biblio.biblionumber WHERE ExtractValue( marcxml, '//datafield[@tag="505"]/*' ) = "" and biblio.copyrightdate is null and ExtractValue( marcxml, '//datafield

[Koha] SQL report - Date issues

I have a report that picks out items that have no contents (505) added and also have no date entered. The problem is that the report is picking up materials that do have dates entered in both the 260 or 264 fields, so it is not working 100% correctly. Can anyone give me some pointers to get it

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

FRED HUTCH / CURES START HERE > fredhutch.org<http://www.fredhutch.org/> > > > > > Date: Wed, 1 Mar 2017 10:16:06 + > > From: vanda koha mailto:vandak...@gmail.com>> > > To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > > Subjec

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

fredhutch.org<http://www.fredhutch.org/> Date: Wed, 1 Mar 2017 10:16:06 + From: vanda koha mailto:vandak...@gmail.com>> To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: [Koha] SQL report for holds waiting for pickup longer tha

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

Hi, In the Koha interface, you can go to Circulation -> Holds awaiting pickup and have a look at the "Hold(s) over" tab. This should show you the information you are wanting. Cheers, Liz Rea Catalyst IT On 01/03/17 23:16, vanda koha wrote: > Hi everybody, > > I would like to run a report that w

[Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

Hi everybody, I would like to run a report that would show me all the users, their e-mail adresses, titles and barcodes of items whose holds have been waiting for pickup longer than the ReservesMaxPickupDelay number of days (in our case 7 days). Can anyone please help me with the SQL Report? It w

Re: [Koha] SQL Report-Circulation-- Help

Hi Pandu Rangaswamy, hope this sql helps your requirements - SELECT DISTINCT b.biblionumber, b.title, b.author, t.publishercode AS p

Re: [Koha] SQL Report-Circulation-- Help

Dear All, Currently i am using Koha version 3.12.10.000. and i am having two branch libraries. I am looking in SQL report to generate the books details with the following details. 1. Title of the book 2. Author 3. Publisher 4. Place of Publication and year 5. Name of the vendor 6. Invoice No and

Re: [Koha] SQL Report-Circulation-- Help

Hi Jonathan, I did a mistake with WHERE Coditions, like; p.categorycode=<> INSTEAD OF borrowers.categorycode (http://schema.koha-community.org/16_05/tables/old_issues.html ) and this was throwing error : Unknown column 'p.categorycode' in 'where clause' Now, I have corrected my query with the sy

Re: [Koha] SQL Report-Circulation-- Help

What is the error you get? Please answer to the list. On Wed, 22 Feb 2017 at 12:12 SATISH wrote: > thank you Jonathan for correcting sql syntax. > but after corrections,it is still showing error! > > with thanks > satish > > On 22 February 2017 at 15:57, Jonathan Druart < > jonathan.dru...@bugs

Re: [Koha] SQL Report-Circulation-- Help

Hello Satish, To add conditions to a SQL query you just need to separate them with the "AND" keyword, do not repeat "WHERE". So it's: SELECT fields FROM TABLE WHERE condition_a AND condition_b AND condition_c Regards, Jonathan On Wed, 22 Feb 2017 at 11:05 SATISH wrote: > Hi, > > With Ko

[Koha] SQL Report-Circulation-- Help

Hi, With Koha 16.5/Package Installation/ Ubuntu 14.04 Desktop / I looking for Borrower's complete transactions report between "date range" and "by patron category" and "by itemtype". I reason for the report is: to keep the record in hard copy for entire semester's transactions. I am trying follo

Re: [Koha] SQL report help

Kerrie, Are you just wanting count of items per collection code at a set branch? And no other information displayed? If so, try SELECT items.ccode, count(items.itemnumber) FROM items WHERE items.homebranch=<> GROUP BY items.ccode That should get you what you are you looking for, if I'm understan

[Koha] SQL report help

I'm trying to get a report to show the number of items in each collection code according to the branch selected. I've looked in the reports library but can't find anything that is exactly right. I've tried to mix'n'match bits from a few reports but I keep getting an error message about syntax.

Re: [Koha] SQL Report help

Thanks so much, was exactly what I needed. Final solution: SELECT p.cardnumber, p.surname, p.firstname, DATE_FORMAT(c.issuedate, "%m/%d/%Y") AS Issue_Date, DATE_FORMAT(c.date_due, "%m/%d/%Y") AS Due_Date, h.attribute AS teacher, (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue', b.title,

Re: [Koha] SQL Report help

Jeremy, You can join biblioitems to biblio using biblionumber. Add this right before your WHERE clause: LEFT JOIN biblioitems bi ON (b.biblionumber = bi.biblionumber) Once you've done that, you can add b.biblionumber, ExtractValue(bi.marcxml,'//datafield[@tag="020"]/subfield[@code="c"]') AS hea

[Koha] SQL Report help

Sure there’s a simple solution, not very good with SQL… This query works great: SELECT p.cardnumber, p.surname, p.firstname, DATE_FORMAT(c.issuedate, "%m/%d/%Y") AS Issue_Date, DATE_FORMAT(c.date_due, "%m/%d/%Y") AS Due_Date, h.attribute AS teacher, (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'da

Re: [Koha] SQL report: Digests in message preferences

(General reminder to add things like this to the wiki) Cheers, Liz :) On 02/04/15 05:37, Chad Roseburg wrote: > Thanks Jonathan! Exactly what I was looking for. > > On Wed, Apr 1, 2015 at 1:31 AM, Jonathan Druart < > jonathan.dru...@biblibre.com> wrote: > >> Hello Chad, >> >> It's stored in the b

Re: [Koha] SQL report: Digests in message preferences

Thanks Jonathan! Exactly what I was looking for. On Wed, Apr 1, 2015 at 1:31 AM, Jonathan Druart < jonathan.dru...@biblibre.com> wrote: > Hello Chad, > > It's stored in the borrower_message_preferences.wants_digest column. > So the following query should return what you want: > > select distinct

Re: [Koha] SQL report: Digests in message preferences

Hello Chad, It's stored in the borrower_message_preferences.wants_digest column. So the following query should return what you want: > select distinct borrowernumber from borrower_message_preferences where > wants_digest=1; Regards, Jonathan 2015-04-01 1:11 GMT+02:00 Chad Roseburg : > Does anyo

[Koha] SQL report: Digests in message preferences

Does anyone have a report showing barcodes of patrons who do not have the "Digests only?" option enabled. I see the transport types but am not sure how the digest option is stored. Thank you! -- Chad Roseburg Automation Dept. North Central Regional Library __

Re: [Koha] sql report for bibliographic records with more than one subject

So I researched on this for the past few days, scouring the internet, only to find partly the answer in mysql-xml documentation (http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html), I came up with the following: SELECT ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') AS T

[Koha] sql report for bibliographic records with more than one subject

Hi all! Im trying to make a report that will have in one column all subjects of the bibliographic record separated by a 'semicolon', so it can be saved as csv file. I'm trying the following: SELECT ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') AS TITLE, ExtractValue(marcxml,

Re: [Koha] SQL Report help please

Hi Ann, Have you checked the ready-made reports in KOHA Wiki (SQL Reports Library)? http://wiki.koha-community.org/wiki/SQL_Reports_Library Regards, On Wed, Sep 3, 2014 at 9:06 AM, library wrote: > Ata marie > > Could someone help please. I am trying to produce reading statistics based > on

[Koha] SQL Report help please

Ata marie Could someone help please. I am trying to produce reading statistics based on patron additional attributes (classes, year levels, ethnicities). Could anyone give me pointers to how to reference borrower attributes and which field holds the issues statistics. Thanks naku noa Ann Murphy

[Koha] SQL Report..

Good day! I would like to make an SQL report that can provide me the follow information: Barcode (952$p) Title(245$a) Remainder of the Title(245$b) Author(245$c) Target Audience Note((521$a) Reading Level(526$c) Call Number Prefix(942$k) Is there anyone can help me with my dilemma.

[Koha] sql report for books of different languages

Dear All I need sql report for list of books of different languages. Do anyone have this type of report? -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. ___ Koha mailing list http://koha-community.or

Re: [Koha] SQL report 650 a

We are using following sql report, change your barcode range and try SELECT items.barcode, biblio.author, CONCAT(biblio.title, ", ",IF( LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE(' LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.ma

Re: [Koha] SQL report 650 a

On 03/01/14 23:31, Holger Meissner wrote: yoonus para wrote: Dear all, How to create a SQL report using field 650 a with barcode and title,Please help me to create this report. Thanks Yoonus Did you find a solution? I thought it might be interesting, but I also can't figure it out. When I

Re: [Koha] SQL report 650 a

yoonus para wrote: > Dear all, > > How to create a SQL report using field 650 a with barcode and title,Please > help me to create this report. > > Thanks > Yoonus Did you find a solution? I thought it might be interesting, but I also can't figure it out. When I run SELECT * FROM marc_subfield_s

[Koha] SQL report 650 a

Dear all, How to create a SQL report using field 650 a with barcode and title,Please help me to create this report. Thanks Yoonus ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Sql report for list of items according to shelving location

Hi Godfrey, you do not specify fields you are interested in. Only some fields from the items table? Or some fields from the bilio table too? Anyway, maybe you can start trying select * from items order by cn_sort or select * from biblio b, items i where b.biblionumber=i.biblionumber order by i.

Re: [Koha] Sql report for list of items according to shelving location

Halo friends, I need technical help in sql, Am at zero level hence I need your help from scratch. Always grateful. Godfrey Quoting Saira Asghar : Hello Everyone I need a report for list of items according to shelving location. If anyone has this kind of sql report then please send me or he

Re: [Koha] Sql report for list of items according to shelving location

Dear Mr. Paul. A Thank you so much for sharing this report. This is absolutely according to my need. Thanks again On Fri, Nov 1, 2013 at 8:28 PM, Paul A wrote: > At 06:54 PM 11/1/2013 +0500, Saira Asghar wrote: > >> Hello Everyone >> >> I need a report for list of items according to shelving l

Re: [Koha] Sql report for list of items according to shelving location

At 06:54 PM 11/1/2013 +0500, Saira Asghar wrote: Hello Everyone I need a report for list of items according to shelving location. If anyone has this kind of sql report then please send me or help me in generating this. You might try: SELECT biblio.author,biblio.title,biblio.copyrightdate,item

[Koha] Sql report for list of items according to shelving location

Hello Everyone I need a report for list of items according to shelving location. If anyone has this kind of sql report then please send me or help me in generating this. I shall be very thankful for your kind help. Waiting for reply -- *Regards* Saira Asghar Librarian Namal College, 30-Kilome

[Koha] SQL Report Update

* Report edited so that it now works :-) Non Circulating Items Developer: Nicole C. Engard, ByWater Solutions Module: Circulation Purpose: List items that have never circulated Status: Complete SELECT b.title, b.author, i.barcode, i.itemcallnumber FROM items i LEFT JOIN biblio b USING (biblionumb

[Koha] SQL Report generation for fines - payment, writeoff

Hi It seems while updating the fine payment , itemnumber becomes null in accountlines table. please help how to calculate fines paid and writeoff amount for a range of date through sql reports module. -- Best wishes ऋचा Richa Srivastava ___ Koha maili

Re: [Koha] sql report 952 z (non-public note)

: Re: [Koha] sql report 952 z (non-public note) Chris, We use the non-public note to hold our information about the actual physical floor/row/bay/shelf information of the boxes in our archives (so we call it "location" in our query) and to print out call slips. We use a sql state

Re: [Koha] sql report 952 z (non-public note)

On 13 September 2011 01:20, Linda Culberson wrote: > Chris, > We use the non-public note to hold our information about the actual physical > floor/row/bay/shelf information of the boxes in our archives (so we call it > "location" in our query)  and to print out call slips. We use a sql > statement

Re: [Koha] sql report 952 z (non-public note)

Chris, We use the non-public note to hold our information about the actual physical floor/row/bay/shelf information of the boxes in our archives (so we call it "location" in our query) and to print out call slips. We use a sql statement that includes; ExtractValue(more_subfields_xml, '/colle

[Koha] sql report 952 z (non-public note)

Hi, We are using item level 952 (? or is it 942 ?) subfield z; non-public note, to store information on certain temporary collections that are loaned to us from other libraries for 3 months or so. I need an SQL report to search 952 (942?) subfield z non-public note across the database and fin

[Koha] SQL report library: not able to edit

I joined in wiki: Koha SQL Report Library, but I am not able to add a new report by editing the page. I need any more privileges to edit the page? Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: www.vimalkumar.org Blog: http://vimalkumar.oksociety.in