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 <[email protected]> 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 <
> [email protected]> 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
>> [email protected]
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>
> --
> *Karam Qubsi*
>
>
>
>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
