Re: [Koha] Help needed with SQL report

2017-10-09 Thread Elaine Bradtke
ike dancing about architecture" >>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >>>> >>>> On Thu, Oct 5, 2017 at 3:16 PM, Holger Meissner < >>>> holger.meiss...@hs-gesundheit.de> wrote: >>>> >>>> &

Re: [Koha] Help needed with SQL report

2017-10-09 Thread Elaine Bradtke
--- >>>> --- >>>> "Writing about music is like dancing about architecture" >>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >>>> >>>> On Thu, Oct 5, 2017 at 3:16 PM, Holger Meissner <

Re: [Koha] Help needed with SQL report

2017-10-09 Thread Jonathan Druart
laine, >>> > >>> > how about this: >>> > >>> > SELECT >>> > biblioitems.biblionumber, >>> > biblio.title, >>> > ExtractValue(biblioitems.marcxml, >>> '//datafield[@tag="260"]/subfie

Re: [Koha] Help needed with SQL report

2017-10-09 Thread Elaine Bradtke
lio.title, >> > ExtractValue(biblioitems.marcxml, '//datafield[@tag="260"]/ >> subfield[@code="c"]') >> > AS text >> > FROM items >> > LEFT JOIN biblioitems on (items.biblioitemnumber= >> > biblioitems.biblioitemnumber) >> >

Re: [Koha] Help needed with SQL report

2017-10-05 Thread Jonathan Druart
"]') > > AS text > > FROM items > > LEFT JOIN biblioitems on (items.biblioitemnumber= > > biblioitems.biblioitemnumber) > > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) > > WHERE > > items.biblionumber >= '17920' AND items

Re: [Koha] Help needed with SQL report

2017-10-05 Thread Barton Chittenden
number >= '17920' AND items.biblionumber <= '17959' > > ORDER BY text ASC > > > > > > -Ursprüngliche Nachricht- > > Von: Koha [mailto:koha-boun...@lists.katipo.co.nz] Im Auftrag von Elaine > > Bradtke > > Gesendet: Donne

Re: [Koha] Help needed with SQL report

2017-10-05 Thread Elaine Bradtke
lionumber <= '17959' > ORDER BY text ASC > > > -Ursprüngliche Nachricht----- > Von: Koha [mailto:koha-boun...@lists.katipo.co.nz] Im Auftrag von Elaine > Bradtke > Gesendet: Donnerstag, 5. Oktober 2017 15:08 > An: koha > Betreff: [Koha] Help needed with SQ

Re: [Koha] Help needed with SQL report

2017-10-05 Thread Holger Meissner
tke Gesendet: Donnerstag, 5. Oktober 2017 15:08 An: koha Betreff: [Koha] Help needed with SQL report I need a report that gives bib number, title and 260$c from a set of records within a range of biblio numbers. This is what the wizard gives me: SELECT biblioitems.biblionumber,biblio.title,b

[Koha] Help needed with SQL report

2017-10-05 Thread Elaine Bradtke
I need a report that gives bib number, title and 260$c from a set of records within a range of biblio numbers. This is what the wizard gives me: SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumb