Zhiming;
There is nothing within the RT code that allow for this ..
I have a similar requirement, which I will be starting to work on in the
next couple of weeks .. if you wish we can exchange ideas ..
What I had in mind is :
Create new table UserLogins (3->4 fields --keeping it small
..(id,UserId, LoginTime,Logoff time)
create appropriate classes using factory
grab user login(session starting ) from web.pm and populate the table
with id,UserId, LoginTime
I am still investigating how to trap the session end .. anyone any ideas
?? but once its known you can update that row with logoff time
Roy
Zhiming Liu wrote:
Hi, can someone help me to write a query for
users/super users:
select all of modified tickets since last login
Thanks, Zhiming.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
