-SQL report on total cost of books

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

-SQL report on total cost of books

Yatheesh lis
Hi

I would like to know total cost of books in my library
Can anyone suggest -SQL query on following details
1) total number books & total cost.
2) total number of books with out cost

Thank you
_______________________________________________

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: -SQL report on total cost of books

Bob Birchall @ Calyx
There are a couple here that may be useful, at least for your first
question.
Bob
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Library_Books_Investment_by_Collection_Code



On Mon, 9 Mar 2020 at 17:33, Yatheesh lis <[hidden email]> wrote:

> Hi
>
> I would like to know total cost of books in my library
> Can anyone suggest -SQL query on following details
> 1) total number books & total cost.
> 2) total number of books with out cost
>
> Thank you
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> [hidden email]
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha