Hello Joel Thank you for your email.
I need books that have been since that date and after (>=) but the date should be picked from a date picker. Then add all books on loan for that particular item type. So that the total at a particular date shall be all books after that datelastseen plus all books on loan for each itemtype. Example: For itemtype 'BK' Total = All bks with datelastseen>='2023-06-30' AND all books on loan for itemtype 'BK'. I have itemtype BK AND JBK and wish that one report would be used for both itemtypes. Thank you for finding time to assist me. Warm Regards James On Fri, 7 Jul 2023, 00:22 Coehoorn, Joel, <jcoeho...@york.edu> wrote: > 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 | jcoeho...@york.edu | york.edu > > > > On Thu, Jul 6, 2023 at 2:32 PM muiru james <muiruny...@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 >> > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
