Do you need to match the exact date last seen, books that have been seen since that date, or books that haven't been seen since before that date? Also, the part about combining books on loan is not clear. Can you explain that in more detail? *Joel Coehoorn* Director of Information Technology *York University* Office: 402-363-5603 | jcoehoorn@york.edu | york.edu On Thu, Jul 6, 2023 at 2:32 PM muiru james <muirunyeri@gmail.com> wrote:
Hello team,
Im trying to create a sql query that will return a count of books that will have a datelastseen from a date picker and combine/add all books on loan for the particular itemtype.
I have 2 different itemtypes and would like a count for each itemtype to include those with a datelastseen and all those onloan for the itemtype.
Any ideas/help will really be appreciated.
Warm regards
James _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha