[Koha] INVENTORY SQL

[Coehoorn, Joel]

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 at york.edu | york.edu



On Thu, Jul 6, 2023 at 2:32 PM muiru james <muirunyeri at 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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>