[Koha] number of bibliographic records

[Nisreen Qabbani]

Have tried that
But there was a problem
After placing

SELECT l.action, count(l.timestamp) AS 'bibs'
FROM action_logs l
LEFT JOIN borrowers p ON (p.borrowernumber=l.user)
WHERE module='CATALOGUING'
      AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and
(yyyy-mm-dd)>>
      AND l.info!='item' AND user=<<user no.>>
GROUP BY l.action


The origin of the SQL reports
And specify the date and name
Does not show results, but shows the same instructions
What is the problem



On Wed, Feb 19, 2014 at 5:34 AM, Karam Qubsi <karamqubsi at gmail.com> wrote:

> Hi ,
> in my library I'm using this report , and I think this is the same report
> you want :
>
> SELECT l.action, count(l.timestamp) AS 'bibs'
> FROM action_logs l
> LEFT JOIN borrowers p ON (p.borrowernumber=l.user)
> WHERE module='CATALOGUING'
>       AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and
> (yyyy-mm-dd)>>
>       AND l.info!='item' AND user=<<user no.>>
> GROUP BY l.action
>
>
> this report will ask you for date range and cataloger no . then the
> results would be something like this :
>
>  action bibs ADD 193 DELETE 10 MODIFY 1010
> Note : the above report is modified by me the source is here :
> http://wiki.koha-community.org/wiki/SQL_Reports_Library where the report
> name there is :
>
>    - 5.83 Bib records added/deleted in time frame<http://wiki.koha-community.org/wiki/SQL_Reports_Library#Bib_records_added.2Fdeleted_in_time_frame> developed
>    by Nicole C. Engard, ByWater Solutions
>    -
>
> Best wishes .
>
>
> On Thu, Feb 13, 2014 at 11:21 PM, Nisreen Qabbani <
> nisreenqabbani at gmail.com> wrote:
>
>> Hello
>> Can you help me how to know the number of bibliographic records for each
>> employee account
>>
>> Thank you very much
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>
> --
> *Karam Qubsi*
>
>
>
>