[Koha] How to get statistic for borrowed item by borrower with department

Hi all master I need help with this matter where I need koha GUI sql script for:- A statistic for the borrowed item by a borrower with the department (if can do in the date range) tq for advance -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___

Re: [Koha] how to generate list for tag 245 |a

tqvm for helping me -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to get statistic for borrowed item by borrower with department

Hi ikbar, where do you store the department? Is it the library/branch or some other field in the borrower? Do you just need the number of checkouts, borrower information and department? Or a list with one line for each item? Katrin On 05.04.19 11:44, ikbar wrote: Hi all master I need help wi

Re: [Koha] Extracting list of biblios with . in the subject

hi there. im just using the SQL given by you and its work But can you help me to alter it to tag 245 where specific title like "mechatronics" i need to list down item with mechatronics title pls do help me tq for advance -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f30479

Re: [Koha] Extracting list of biblios with . in the subject

> hi there. im just using the SQL given by you and its work If you mean this query Barton provided, > SELECT > ExtractValue( metadata, '//datafield[@tag=650]/subfield[@code="a"]' ) > as 'Topical term', > biblionumber, > title > FROM > biblio > INNER JOIN biblio_metadata using