[Koha] Report help

[Eric Phetteplace]

Hi Mutasem,

Can you clarify what you mean by "number of search book in koha"? I can
think of a few different interpretations, including:

1) number of times someone searched the OPAC for a book
2) number of books that be retrieved by a search

#1 cannot be answered with a report, as far as I know, but would instead
require web analytics that track how often a search URL is visited. If you
have Google Analytics set up for your catalog, you can see how often URLs
like "cgi-bin/koha/opac-search.pl?q=" were accessed.

2) can be very simply or rather lengthy depending on what you want to
include. At its simplest, you can just count the number of bibliographic
records in your Koha database:

SELECT COUNT(*)
FROM biblio

If you want something a bit more refined, for instance only biblios that
have attached items or perhaps the number items with a "BOOK" type, then
that has to be modified but it's hard to know what you want based on your
original message.

Best,

ERIC PHETTEPLACE

Systems Librarian


libraries.cca.edu | vault.cca.edu | 510.594.3660

5212 Broadway, Oakland, CA 94618

1111 8th St., San Francisco, CA 94107

Preferred Pronoun(s): he/him

:(){ :|: & };:

2018-03-19 0:04 GMT-07:00 Mutasem Al Shami <mshami at mcst.edu.sa>:

> Hi,
>
> any one can help me, i need report to count number of search book in koha.
>
> thank,
> Mutasem
>
> --
>
>
> ------------------------------
>
> Disclaimer: This message and its attachment, if any, are confidential and
> may contain legally privileged information. If you are not the intended
> recipient, please contact the sender immediately and delete this message
> and its attachment, if any, from your system. You should not copy this
> message or disclose its contents to any other person or use it for any
> purpose. Statements and opinions expressed in this e-mail are those of the
> sender, and do not necessarily reflect those of Al Maarefa College (MCST).
> All opinions and/or views expressed in this email are solely those of the
> author and do not necessarily represent those of MCST, MCSTaccepts no
> liability for damage caused by any virus transmitted by this email.
>
>   تنويه: هذه الرسالة ومرفقاتها (إن وجدت) تمثل وثيقة سرية قد تحتوي على
> معلومات تتمتع بحماية وحصانة قانونية. إذا لم تكن الشخص المعني بهذه الرسالة
> يجب عليك تنبيه المُرسل بخطأ وصولها إليك، وحذف الرسالة ومرفقاتها. ولا يجوز
> لك نسخ هذه الرسالة أو مرفقاتها أو أي جزء منها، أو البوح بمحتوياتها لأي شخص
> أو استعمالها لأي غرض. علماً بأن الآراء والإفادات التي تحويها هذه الرسالة
> تعبر فقط عن رأي المُرسل وليس بالضرورة رأي كلية المعرفة، ولا تتحمل كلية
> المعرفة أي مسئولية عن الأضرار الناتجة عن أي فيروسات قد يحملها هذا البريد.
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>