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 wrote:
> Ok, for the Guided Reports the SQL will be something like:
>
> SEL
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 <> AND <> ORDER BY b.surname,b.firstname,al.timestam
I don't think those patches will effect Rania's request for reports. Though
adding the interface column will be a nice feature.
On Jul 21, 2016 9:55 AM, "Tomas Cohen Arazi" wrote:
> This patches will improve it and are worth testing do they get pushed :-)
>
> https://bugs.koha-community.org/bugz
This patches will improve it and are worth testing do they get pushed :-)
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16829
El mié., 20 jul. 2016 13:48, Michael Hafen
escribió:
> The action_logs table in the database could hold that information if you
> have turned on logging in t
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 t
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
