[Koha] Subject Wise Report

[Owen Leonard]

Please reply to the mailing list so that others can participate.

On Wed, Apr 17, 2019 at 12:25 AM Rizwan Majeed <rizwanmajeed at ue.edu.pk> wrote:
>
> this is the query
>
> SELECT *
> FROM(SELECT
>     items.dateaccessioned,
>     items.barcode,
>     items.itemcallnumber,
>     biblio.title,
>     biblio.author,
>     biblioitems.publishercode,
>     (SELECT ExtractValue(biblioitems.marcxml,'//datafield[@tag="650"]/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.dateaccessioned BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>) AS t
> WHERE  Subject LIKE concat('%',<<Subject>>,'%')
> ORDER BY dateaccessioned DESC
>