[Koha] Need a little help with an SQL query

Joe Sikowitz joe at flo.org
Thu Feb 21 05:35:53 NZDT 2019


Something like this may work:

SELECT b.cardnumber, b.surname, b.firstname, i.issuedate
FROM borrowers b
INNER JOIN issues i ON (b.borrowernumber = i.borrowernumber)
WHERE i.issuedate BETWEEN <<Issue Date Between (yyyy-mm-dd)|date>> AND
<<and (yyyy-mm-dd)|date>>
GROUP BY b.cardnumber

Joe

On Wed, Feb 20, 2019 at 11:24 AM Chris Brown <chris at stayawake.co.uk> wrote:

> Gentle Reader,
>
> We want to get a list of all patrons for who we do *not *have email
> addresses but who are "active" (for example, have checked a book out in the
> last 6 months)
>
> I know how to get a list of patrons with no email address but my knowledge
> of SQL and the database schema aren't good enough to write the "AND have
> checked a book out in the last 6 months" part of the query.
>
> Is there a kind soul out there who could help? We are using Koha 17.11
>
> Thanks and Best Regards,
>
> Chris Brown
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Joe Sikowitz
Collaborative Services Librarian
Fenway Library Organization
(617) 989-5031
joe at flo.org


More information about the Koha mailing list