I think you will find the data required in items.itemnotes_nonpublic so
your WHERE clause might be:
WHERE items.itemnotes_nonpublic LIKE '%Added to LA%'
Use the LIKE comparison in case there is anything else in the notes.
On 03/06/2020 05:53, Ketan Kulkarni wrote:
You will have to use the fu
You will have to use the function ExtractValue() for extracting the public
note. Once you do that, just download the CSV and sort that column in a
spreadsheet application. Should do the trick.
On Wed, Jun 3, 2020 at 10:18 AM Kerrie Stevens
wrote:
> Hi All,
>
> I want to be able to run a report t
Hi Kerrie,
You haven't joined the Items table. So:
JOIN items ON (biblio_metadata.biblionumber = items.biblionumber)
HTH,
Bob
Calyx
On 12/06/18 08:43, Kerrie Stevens wrote:
I have the following report which almost does what I need but I can't quite get
it there.
I want to be able get a list o
Hi Kerrie,
Both sql's formats are working for me with
Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL
Thanks to Pedro and Mark.
1)
---
SELECT CONCAT('',biblio.biblionumber,'')
AS biblionumbers, items.barcode
,items.itemcallnumber,biblioitems.is
This is awesome, Nick.
I'm bookmarking this for future reference, thanks a lot!
On 13 December 2017 at 15:27, Nick Clemens
wrote:
> This is a quite unfinished stub, but it aims to allow for letting you input
> a list into a report:
> https://github.com/bywatersolutions/koha-reports-plus
>
> On M
This is a quite unfinished stub, but it aims to allow for letting you input
a list into a report:
https://github.com/bywatersolutions/koha-reports-plus
On Mon, Dec 11, 2017 at 8:20 PM DHD.KOHA wrote:
> what version of KOHA ?
>
>
>
> On 11/12/2017 02:18 πμ, Kerrie Stevens wrote:
> > Is there a wa
what version of KOHA ?
On 11/12/2017 02:18 πμ, Kerrie Stevens wrote:
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 m
Excerpts from Pedro Amorim's message of 2017-12-11 14:18:08 -0100:
> This should work:
>
> Select title, author, i.itemcallnumber from biblio b
> Left join biblioitems bi on b.biblionumber=bi.biblionumber
> Left join items i on bi.biblionumber=i.biblionumber
> where i.barcode IN ("BARCODE1", "BARC
Hello Kerrie,
This should work:
Select title, author, i.itemcallnumber from biblio b
Left join biblioitems bi on b.biblionumber=bi.biblionumber
Left join items i on bi.biblionumber=i.biblionumber
where i.barcode IN ("BARCODE1", "BARCODE2", "BARCODE3");
GL,
Pedro Amorim
On 11 December 2017 at 0
And Barcodes can be searched with wild cards '%' or '_'
eg: 45% results in
45, 451,452,453..459, 4500
this would help you to some extent.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo
Hi Kerrie,
I can only find single barcode search that you could find it in SQL
Library..here..
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Barcode_Search_Report
And somebody could help you in enhancing this sql for multiple barcode
search.
Regards
Satish
Librarian
Govt. Engineerin
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
Hi Kerry,
you are right, I think this one should be better:
SELECT
i.itemnumber,
i.biblionumber,
b.title,
b.author,
i.itemcallnumber,
i.barcode,
i.homebranch
FROM
items i
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
WHERE homebranch = "QLD"
AND i.biblionumber not in (select distinct i2.
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
Subjec
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
Kerrie,
Just to be sure that I'm understanding you here ... you wan to list the
item if it's held at 'QLD', but *not* if it's held at 'QLD' but also held
at another branch?
I think this will work:
SELECT
items.itemnumber,
biblio.title,
biblio.author,
items.itemcallnumber,
ite
Hi--
I believe that Nicole Engard wrote the following report for me. It
seems to work.
SELECT biblio.biblionumber, biblio.title, biblio.author
FROM biblioitems
JOIN biblio ON ( biblioitems.biblionumber = biblio.biblionumber )
WHERE ExtractValue( marcxml, '//datafield[@tag="942"]/subfield[@code
:-P
El mié., 10 ago. 2016 a las 10:56, Jonathan Druart (<
jonathan.dru...@bugs.koha-community.org>) escribió:
> Erk indeed! Thanks Barton.
>
> I have the habit of looking at 995 for items ;)
>
> 2016-08-10 14:32 GMT+01:00 Barton Chittenden >:
> > Jonathan's use of ExtractValue is correct, but it
Erk indeed! Thanks Barton.
I have the habit of looking at 995 for items ;)
2016-08-10 14:32 GMT+01:00 Barton Chittenden :
> Jonathan's use of ExtractValue is correct, but item data isn't stored in
> biblioitems.marcxml -- as a matter of fact, it's not stored in marc at
> all... it's *always* gene
Jonathan's use of ExtractValue is correct, but item data isn't stored in
biblioitems.marcxml -- as a matter of fact, it's not stored in marc at
all... it's *always* generated on the fly.
You can query against items.itype instead.
--Barton
On Tue, Aug 9, 2016 at 4:18 AM, Jonathan Druart <
jonatha
Hi Kerrie,
I'd say that the following query returns what you want:
SELECT biblioitems.biblionumber, marcxml from biblioitems where
ExtractValue( marcxml, '//datafield[@tag="942"]/subfield[@code="c"]' )
= "";
Regards,
Jonathan
2016-08-09 7:36 GMT+01:00 Kerrie Stevens :
> Hi Everyone,
>
> I'm tryi
21 matches
Mail list logo
