Please reply to the mailing list so that others can participate.
On Wed, Apr 17, 2019 at 12:25 AM Rizwan Majeed <rizwanmaj...@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
>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
