[Koha] INVENTORY SQL

[muiru james]

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 at 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 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
>>
>