Oh that's great, I will do the necessary modification then I will posted back for the benifit of everyone, or you can added in the sql report Will be back to you soon Thanks again On Thursday, 21 July 2016, Michael Hafen <michael.hafen@washk12.org> wrote:
Ok, for the Guided Reports the SQL will be something like:
SELECT al.timestamp AS DateAndTime,b.surname,b.firstname,module,action FROM action_logs AS al LEFT JOIN borrowers AS b ON user = b.borrowernumber WHERE user <> 0 AND al.timestamp BETWEEN <<Between (yyyy-mmd-dd)|date>> AND <<And (yyyy-nn-dd)|date>> ORDER BY b.surname,b.firstname,al.timestamp
You may want to adjust the order by with asc or desc qualifiers on the timestamp.
But this only works for periods where you have the logging enabled, and only for those modules that are enabled. For example I don't see circulation when I run that SQL because I don't have logging enabled for that module.
On Thu, Jul 21, 2016 at 4:46 AM, rania azad mohammed < rania.azad@auis.edu.krd <javascript:_e(%7B%7D,'cvml','rania.azad@auis.edu.krd');>> wrote:
Oh I see, Can you help me on building the SQL query since I don't have a lot of knowledge with SQL? simple report on librarian activities circulation,items and cataloguing with date and time will be perfect
On Wed, Jul 20, 2016 at 7:48 PM, Michael Hafen <michael.hafen@washk12.org <javascript:_e(%7B%7D,'cvml','michael.hafen@washk12.org');>> wrote:
The action_logs table in the database could hold that information if you have turned on logging in the system preferences ( http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs). There is a Log Viewer in Tools that may be useful for getting information from this table, or you can try building an SQL Report by hand.
On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed < rania.azad@auis.edu.krd <javascript:_e(%7B%7D,'cvml','rania.azad@auis.edu.krd');>> wrote:
Dear
We are 3 admins in the library working on shifts in the library, each of us log-in during her time. I want a report or log file to see all the activities of each admin during a specific day. is there such report or file? I tried to find it using the wiki but hopeless
--
*Regards,*
*Rania Azad |* Library Manager Library Department http://library.auis.edu.iq/ The American University of Iraq, Sulaimani Office: *B-G-32* Ext *1219*
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org <javascript:_e(%7B%7D,'cvml','Koha-devel@lists.koha-community.org');> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Michael Hafen Washington County School District Technology Department Systems Analyst
--
*Regards,*
*Rania Azad |* Library Manager Library Department http://library.auis.edu.iq/ The American University of Iraq, Sulaimani Office: *B-G-32* Ext *1219*
-- Michael Hafen Washington County School District Technology Department Systems Analyst
-- *Regards,* *Rania Azad |* Library Manager Library Department http://library.auis.edu.iq/ The American University of Iraq, Sulaimani Office: *B-G-32* Ext *1219*