Hi Okpa
Please always copy the list. Therefore others can benefit from the
discussion and you can receive help from more people.
You need to enter your staff interface and go the the ABOUT page. There you
will find details about the issue you have.
Regards,
Alvaro
|
r,
> >> biblio.title,
> >> biblio.author,
> >> biblioitems.publishercode,
> >>
> >>
> ExtractValue(biblio_metadata.metadata,'//datafield[@tag="650"]/subfield[@code>="a"]')
> >> AS Subject
>
umber)
>> LEFT JOIN biblio ON (biblioitems.biblionumber = biblio.biblionumber)
>> LEFT JOIN biblio_metadata ON (biblio_metadata.biblionumber =
>> biblio.biblionumber)
>> WHERE
>> items.dateaccessioned BETWEEN <>
>> AND <>
>
lio_metadata.biblionumber =
> biblio.biblionumber)
> WHERE
> items.dateaccessioned BETWEEN <>
> AND <>
> ) AS t
> WHERE
> Subject LIKE concat('%',<>,'%')
> ORDER BY dateaccessioned DESC
>
> Regards,
utosi
Gesendet: Dienstag, 19. März 2019 15:23
An: Barton Chittenden
Cc: koha
Betreff: Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject
Hi everyone,
Mohammad, Barton, thanks very much for this. Unfortunately, I've already tried
this report (I found it on the Koha SQL report
ag="650"]/subfield[@code>="a"]'))
>>> AS Subject
>>> FROM items
>>> LEFT JOIN biblioitems ON
>>> (items.biblioitemnumber=biblioitems.biblioitemnumber)
>>> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
>
0"]/subfield[@code>="a"]'))
>> AS Subject
>> FROM items
>> LEFT JOIN biblioitems ON
>> (items.biblioitemnumber=biblioitems.biblioitemnumber)
>> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
>> WHERE items.dat
essioned DESC
>
>
> Thanks & Best Regards,
>
> Mohammed Nashbat
> Library Instructor
>
>
> -Original Message-
> From: Mohammad Nashbat
> Sent: Tuesday, March 19, 2019 10:04 ص
> To: 'Craig Butosi'; koha@lists.katipo.co.nz
&g
;%',<>,'%')
ORDER BY dateaccessioned DESC
Thanks & Best Regards,
Mohammed Nashbat
Library Instructor
-Original Message-
From: Mohammad Nashbat
Sent: Tuesday, March 19, 2019 10:04 ص
To: 'Craig Butosi'; koha@lists.katipo.co.nz
Subject: RE: [Koha] Koha
s.katipo.co.nz] On Behalf Of Craig Butosi
Sent: Monday, March 18, 2019 07:29 م
To: koha@lists.katipo.co.nz
Subject: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject
Hi everyone,
Running Koha 18.11 on Ubuntu 16.04 w/ MariaDB. Having a bit of trouble
understanding the db structural changes
Hi everyone,
Running Koha 18.11 on Ubuntu 16.04 w/ MariaDB. Having a bit of trouble
understanding the db structural changes made in 18.xx and how SQL reports
are built in Koha 18.11. I know some tables and such have changed since the
old 16.xx days.
*I'd like to create a report that draws a list
11 matches
Mail list logo