number of bibliographic records
Hello Can you help me how to know the number of bibliographic records for each employee account Thank you very much
On 14/02/14 02:21, Nisreen Qabbani wrote:
Hello Can you help me how to know the number of bibliographic records for each employee account
Thank you very much Hi Nisreen, I am not sure exactly what you mean by 'employee account', however you may find a suitable report in the Koha reports library: http://wiki.koha-community.org/wiki/SQL_Reports_Library
I hope this helps. Bob Birchall Calyx
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 : actionbibsADD193DELETE10MODIFY1010 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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
Thank you very much On Wed, Feb 19, 2014 at 5:34 AM, Karam Qubsi <karamqubsi@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
hi you should put the user id no. not the username . it's something like : (1 , 2 , 3 ... ) you can check the userid from the user record . Best regards On Mon, Mar 3, 2014 at 2:53 PM, Nisreen Qabbani <nisreenqabbani@gmail.com>wrote:
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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
Oak Iam Going to try it Thanks Karam On Mon, Mar 3, 2014 at 12:13 PM, Karam Qubsi <karamqubsi@gmail.com> wrote:
hi you should put the user id no. not the username . it's something like : (1 , 2 , 3 ... ) you can check the userid from the user record .
Best regards
On Mon, Mar 3, 2014 at 2:53 PM, Nisreen Qabbani <nisreenqabbani@gmail.com>wrote:
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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
Hello We are our steps, but I do not know where the mistake Is it a Patron ID Or the card number or the report and thank you very much On Mon, Mar 3, 2014 at 11:13 AM, Karam Qubsi <karamqubsi@gmail.com> wrote:
hi you should put the user id no. not the username . it's something like : (1 , 2 , 3 ... ) you can check the userid from the user record .
Best regards
On Mon, Mar 3, 2014 at 2:53 PM, Nisreen Qabbani <nisreenqabbani@gmail.com>wrote:
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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
participants (3)
-
Bob Birchall -
Karam Qubsi -
Nisreen Qabbani