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, <jcoehoorn@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 | 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