Queries for UserLogger start-work-070517
authorcropposc
Mon, 08 Oct 2007 16:43:06 +0200
branchstart-work-070517
changeset 191a5c51cc869f0
parent 190 f4e0ea5c429d
child 192 1e5a7bd518a7
Queries for UserLogger
src/sql/queries.txt
     1.1 --- a/src/sql/queries.txt	Mon Oct 08 15:30:47 2007 +0200
     1.2 +++ b/src/sql/queries.txt	Mon Oct 08 16:43:06 2007 +0200
     1.3 @@ -18,7 +18,7 @@
     1.4  
     1.5  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     1.6  [1]
     1.7 -# In Spalte Duration müsste statt step='UI_CLOSE_WORKSHEET' eigentlich step='LO_STOP_SESSION' stehen,
     1.8 +# In Spalte Duration muesste statt step='UI_CLOSE_WORKSHEET' eigentlich step='LO_STOP_SESSION' stehen,
     1.9  # dieses wird aber noch nicht in die Datenbank geschrieben.
    1.10  select UserName, Argument as UserUrl, Time as Begin,
    1.11  unix_timestamp((select Time from UserLogger where step='UI_CLOSE_WORKSHEET' and session=ul1.session)) - unix_timestamp(ul1.time) as Duration,