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> 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> 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> 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
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