[rt-users] Query tickets login?
Roy El-Hames
rfh at pipex.net
Wed Jul 26 04:06:40 EDT 2006
Zhiming;
Its better you mail the list than just me .. someone else maybe able to
help quicker ..
Regard your query, I think it does not work because there is nothing
related to anything happening ..(a change in the transaction table) ..
I think you should be looking at
http://wiki.bestpractical.com/index.cgi?EditCustomFieldsOnUpdate or
similar ..
Regards;
Roy
Zhiming Liu wrote:
> Hi Roy, Please take a look of my codes and see why
> they don't work. This is the scrip of custom condition
> (In a ticket if CustomField 'Release to US Cert?' is
> 'Yes', return 1).
>
>
> my $CFName = 'Release to US Cert?';
> my $QueueObj = $self->TicketObj->QueueObj;
> my $CFObj = RT::CustomField->new(
> $QueueObj->CurrentUser );
> $CFObj->LoadByNameAndQueue( Name => $CFName, Queue
> => $QueueObj->id );
> if ( $CFObj->SelectCustomFieldValue(Name => $CFName)
> eq 'Yes') {
> return 1;
> } else {
> return undef;
> }
>
>
> Thanks, Zhiming.
>
> --- Roy El-Hames <rfh at pipex.net> wrote:
>
>
>> Query builder is based on a ticket object .. ie you
>> only search for
>> tickets ..not people ..
>> You may want to add an interface within the admin
>> pages to query login
>> and out times ..
>> for now I am sticking to query mysql when needed ..
>> I have few other
>> requirements pending
>> Regards;
>> Roy
>>
>> Zhiming Liu wrote:
>>
>>> Hi Roy, I got it works too. Thanks. Are you going
>>>
>> to
>>
>>> add this into Query Builder to query tickets?
>>>
>> Zhiming.
>>
>>> --- Roy El-Hames <rfh at pipex.net> wrote:
>>>
>>>
>>>
>>>> Yes I got it all working ..
>>>> the attached is a scripts that I run every 12
>>>>
>> hours
>>
>>>> to clear the session
>>>> table and also trap any logins that have not
>>>>
>> exited
>>
>>>> using the logout
>>>> button and updates the LogoffTime..
>>>> Good luck.
>>>> Roy
>>>>
>>>>
>>>> Zhiming Liu wrote:
>>>>
>>>>
>>>>> Hi Roy, Yes, I will redesign my table. I can't
>>>>>
>>>>>
>>>> update
>>>>
>>>>
>>>>> the LogoutTime from mysql. How about you? Do you
>>>>>
>>>>>
>>>> get
>>>>
>>>>
>>>>> update logofftime? Thanks, Zhiming.
>>>>>
>>>>> --- Roy El-Hames <rfh at pipex.net> wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>> Ahh .. I would suggest you redesign your table
>>>>>> similar to mine .. or
>>>>>> you'll need to modify your code as per your
>>>>>>
>> table
>>
>>>>>>
>>>>>>
>>>> ..
>>>>
>>>>
>>>>>> can you update the LogoutTime from mysql??
>>>>>> Roy
>>>>>> Zhiming Liu wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Hi Roy, I understood what you said.
>>>>>>> 1. Since I have only id (same as your userid)
>>>>>>>
>> as
>>
>>>>>>> primary key, so I didn't see second logintime
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> created
>>>>>>
>>>>>>
>>>>>>
>>>>>>> in my system.
>>>>>>> 2. LogoutTime is the same as your logofftime.
>>>>>>>
>> No
>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> error
>>>>>>
>>>>>>
>>>>>>
>>>>>>> created, just the LogoutTime field didn't
>>>>>>>
>>>>>>>
>>>> update.
>>>>
>>>>
>>>>>>> I will modify table and test again. Talk to
>>>>>>>
>> you
>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> later,
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Zhiming.
>>>>>>>
>>>>>>> --- Roy El-Hames <rfh at pipex.net> wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>> Zhiming Liu wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> Hi Roy, I have tested the codes. Create
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>> LoginTime
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>> working, but we need update LoginTime too.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>> Update
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>> LogoutTime codes don't work in both
>>>>>>>>>
>>>>>>>>>
>>>> autohandler
>>>>
>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>> and
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> Logout.html. What do you think? Zhiming.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>> I don't update the logintime.. if user 1005
>>>>>>>>
>>>>>>>>
>>>> login
>>>>
>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>> at
>>>>>>
>>>>>>
>>>>>>
>>>>>>>> 10 am and then
>>>>>>>> again at 12 am , I'll have 2 rows .
>>>>>>>> id sessionid userid logintime
>>>>>>>>
>> logofftime
>>
>>>>>>>> 1 fsdfsdf 1005 10.01
>>>>>>>> 2 rtetre 1005 12.01
>>>>>>>> there are 2 reasons for this:
>>>>>>>> 1- I can always track if a user logged in
>>>>>>>>
>> last
>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>> week
>>>>>>
>>>>>>
>>>>>>
>>>>>>>> 2- The sessionid changes for every login, so
>>>>>>>>
>> a
>>
>>>>>>>> separate row is more
>>>>>>>> consistent ..
>>>>>>>>
>>>>>>>> I am not quite sure I understand what you
>>>>>>>>
>> mean
>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>> about
>>>>>>
>>>>>>
>>>>>>
>>>>>>>> logouttime .. you
>>>>>>>> should only reference this from logout.html
>>>>>>>>
>> and
>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>> your
>>>>>>
>>>>>>
>>>>>>
>>>>>>>> session cleaner
>>>>>>>> script ..what errors are you getting ??
>>>>>>>> Roy
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> --- Roy El-Hames <rfh at pipex.net> wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> Hi Zhiming;
>>>>>>>>>> Just to let you know I have implemented
>>>>>>>>>>
>> this
>>
>>>>>>>>>> functionality as follow:
>>>>>>>>>> CREATE TABLE UserLogin (id INTEGER NOT NULL
>>>>>>>>>> auto_increment,sessionid
>>>>>>>>>> varchar(32),UserId INTEGER NOT
>>>>>>>>>>
>> NULL,LoginTime
>>
>>>>>>>>>> datetime default
>>>>>>>>>> CURRENT_TIMESTAMP, LogOffTime datetime,
>>>>>>>>>>
>>>>>>>>>>
>>>> PRIMARY
>>>>
>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>> KEY
>>>>>>>>
>>>>>>>>
> === message truncated ===
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
More information about the rt-users
mailing list