[Koha] SQL help please

Hi All, I want to be able to run a report that pulls out bib number, title, author & barcode for resources that have "Added to LA" in the 'x-non-public note' field of the item record. That last bit is the bit I'm not sure how to do...? Thank you for any assistanc

[Koha] SQL help?

ance would be greatly appreciated. Thank you and have a great day wherever you may be! Kerrie Stevens AALIA(CP), MAppSci(LibMgt), BBus(Info&LibMgt) Director of Library Services, Alphacrucis College Librarian - Melbourne Campus HDR Liaison Librarian

Re: [Koha] SQL help

We have version 18.11.11 and I’ve looked through the reports library but can’t see anything that looks similar to be tweaked into what I need. Thank you, Kerrie Stevens From: Michael Sutherland Sent: Thursday, 12 December 2019 12:59 AM To: Kerrie Stevens Cc: joel.coeho...@york.edu; koha

Re: [Koha] SQL help

‘Unsuccessful’ would be a search where no search results were returned. ‘Successful’ would be searches that retrieved results Thanks, Kerrie Stevens From: Coehoorn, Joel Sent: Wednesday, 11 December 2019 3:54 PM To: Kerrie Stevens Subject: Re: [Koha] SQL help Define "unsuccessful&quo

[Koha] SQL help

? Thank you, Kerrie Stevens Alphacrucis College Melbourne, Australia ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Help with a report query

ND type IN ('issue', 'renew') GROUP BY month, type ORDER BY month(datetime) Thanks so much for your help! And thanks Carlos for a handy report. SQL is not my strong-point... Kerrie Stevens  AALIA(CP), MAppSci(LibMgt), BBus(Info&LibMgt) Librarian – Melbour

Re: [Koha] Koha - display of Periodicals(serials) search result in Koha

Hi Krishna, We have the same issue. To get around it, once you get to the journal page we use Ctrl F then type the keyword again and it is highlighted on the page and shows which specific issue it is in. Not perfect, but workable. If there is a better way, I'd love to use it too. K

[Koha] SQL help please

ata JOIN biblio ON ( biblio_metadata.biblionumber = biblio.biblionumber ) WHERE items.ccode=<> ORDER BY biblio.title ASC It works if I remove the WHERE line, but then I can't select which collection. Thanks for any help you may provide! Kerrie Stevens AALIA(CP), MAppSci(LibMgt),

[Koha] SQL help please

Is there a way to write an SQL report where you can input a number of item barcodes (as you do when using batch modify or delete) that results in a table showing title, author, call number etc...? Thanks for any help you may provide! Kerrie Stevens AALIA(CP), MAppSc(Lib&InfoMgt)(CSU),

[Koha] List refinement/sorting

within a list? Kerrie Stevens Harvest Bible College ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL help please

Thanks Katrin – I think that has worked! Thank you for your help. Kerrie Stevens From: Katrin [mailto:katrin.fischer...@web.de] Sent: Thursday, April 13, 2017 8:36 AM To: Kerrie Stevens Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] SQL help please Hi Kerry, you are right, I think this one

Re: [Koha] SQL help please

Hi Katrin, Again, this is giving me everything at QLD, not items ONLY held at QLD… I’m sure there must be a way to do it… Thanks, Kerrie Stevens From: Katrin Fischer [mailto:katrin.fischer...@web.de] Sent: Wednesday, April 12, 2017 5:27 PM To: Kerrie Stevens Cc: koha@lists.katipo.co.nz

Re: [Koha] SQL help please

items WHERE items.homebranch != 'QLD' ) ORDER BY items.itemcallnu' at line 10 Kerrie Stevens From: Barton Chittenden [mailto:bar...@bywatersolutions.com] Sent: Wednesday, April 12, 2017 4:59 PM To: Kerrie Stevens Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] SQL help please Kerr

[Koha] SQL help please

umber, items.barcode FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE items.homebranch='QLD' ORDER BY items.itemcallnumber Thanks for your help, Kerrie Stevens Harevst Bible College ___ Koha mailing list http://koha-com

Re: [Koha] SQL report - Date issues

biblio.copyrightdate is null and ExtractValue( marcxml, '//datafield[@tag="260"]/*' ) = "" and ExtractValue( marcxml, '//datafield[@tag="264"]/*' ) = "" ORDER BY biblio.copyrightdate desc Kerrie Stevens From: ramirouvia . [mailto:

[Koha] SQL report - Date issues

sults that come back includes bibs with date entries in the 260 and 264 fields - why would they be selected as having nothing in the date field, when they clearly do? Eg: both formats: '1958' or '[19--]' might appear in the fields Thanks for any help you may provide... Kerrie

[Koha] SQL help request

How would I insert another column in the results table of this report to show the biblio number as well? I keep getting syntax errors with everything I try. SELECT barcode, itemcallnumber FROM items WHERE datelastseen < CAST(<> AS DATETIME) AND homebranch = <> AND itemnumber NOT IN (SEL

[Koha] SQL help please

Hi Everyone, I'm trying to get a report to identify which bib records in my Koha do not have anything in the 942 $c Koha Item Type marc field. I tried to tweak a report from the report library, but it doesn't appear to work correctly as some of the results do have things in the 942$c field. Can

Re: [Koha] Suggestion Challenge

ormal library location. Hope this helps, Kerrie Stevens Harvest Bible College Message: 6 Date: Thu, 7 Apr 2016 19:01:32 -0400 From: "Bruce A. Metcalf" To: Koha Subject: [Koha] Suggestion Challenge Message-ID: <5706e6cc.5020...@augustansociety.net> Content-Type: text/plain; charset

[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] Catalogue - SQL Report Help (Paul A)

much for your sharing of this report. Kerrie Stevens Harvest Bible College Melbourne, Australia ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report help

- can anyone help me with this? SELECT concat(b.surname,', ',b.firstname) AS name, count(s.borrowernumber) AS checkouts FROM statistics s LEFT JOIN borrowers b USING (borrowernumber) WHERE s.datetime BETWEEN <> AND <> GROUP BY s.borrowernumber ORDER BY count(s.borrowernumbe

[Koha] ISBN report

I've searched through the reports site but can't find anything that sounds like it will do what I want. It's a simple report, but I just can't work it out... any help would be very much appreciated. I need a report to list every ISBN in my collection - a simple but very long results list. Does

[Koha] Collection Code Totals

WHERE items.homebranch='VIC' ORDER BY items.dateaccessioned DESC I have looked through the Reports Library but can't find anything to do this. I've tried to adapt others but without any luck. Any help is much appreciated. Thank you, Kerrie Stevens ___

[Koha] Different call numbers, same item

Hello there, I'm hoping someone can help me - I need to run a report to find item records that have multiple items at different call numbers... Eg: one branch will have a title at a certain call number, and after merging records, there is now a second holding at another branch, but at a differ