Re: [otrs] Trying to find out the time taken to close a ticket

2007-06-19 Thread Alexander Scholler
Hi Gabriele, Gabriele D'Andrea schrieb: Well, there was something I still didn't understand about OTRS DataBase Schema. Now finally I got it. I've written a SQL query, that allow me to filter closed tickets, and see the time taken from ticket opening till the last closing. SELECT t.tn, t.cust

Re: [otrs] Trying to find out the time taken to close a ticket

2007-06-19 Thread Gabriele D'Andrea
Well, there was something I still didn't understand about OTRS DataBase Schema. Now finally I got it. I've written a SQL query, that allow me to filter closed tickets, and see the time taken from ticket opening till the last closing. SELECT t.tn, t.customer_id, t.create_time, MAX(th.change_time)

Re: [otrs] Statistic extensions (considering TimeWorkingHours)

2007-06-19 Thread Gabriele D'Andrea
OK, thanks for your explanation, now I think I understand V Gabriele - Original Message - From: "Alexander Scholler" <[EMAIL PROTECTED]> To: "User questions and discussions about OTRS.org" Sent: Monday, June 18, 2007 5:04 PM Subject: Re: [otrs] Statistic extensions (considering TimeW

RE: [otrs] Using Tabed browser & Next Page

2007-06-19 Thread Dave Wojciechowski
Well I answered my own question, so I thought I would toss it out there for anyone else looking for an answer, if you want to have tabs that are totally independent of each other, say 2 tabs open that are not using the same session id, in your sysconfig change SessionUseCookie to no, this will caus

[otrs] httpd.conf file

2007-06-19 Thread support
How can I unpack the original httpd.conf file from the otrs install program? I'm on a windows platform and installed the otrs software using the .exe file. Thanks, Greg ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://list

Re: [otrs] Can't see my queues

2007-06-19 Thread Gabriele D'Andrea
so it should be a problem of group membership: you must be sure to assign yourself permission on the group linked to the queue you want to see. Gabriele - Original Message - From: "Eugene Ventimiglia" <[EMAIL PROTECTED]> To: "User questions and discussions about OTRS.org" Sent: Tues

RE: [otrs] Can't see my queues

2007-06-19 Thread Eugene Ventimiglia
I thought of that too, but the queues I can't see also don't appear in the My Queues control. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Nils Breunese (Lemonbit) > Sent: Tuesday, June 19, 2007 11:27 AM > To: User questions and discussions about

RE: [otrs] Can't see my queues

2007-06-19 Thread Greg Horne
A little different, not that this should make any difference, but remove your rights from the group, update it. The come back in and give yourself rights again. Should not make any difference, but its worked in the past for other products. Greg Horne geh gehorne -Original Message-

Re: [otrs] Can't see my queues

2007-06-19 Thread Nils Breunese (Lemonbit)
Eugene Ventimiglia wrote: I logged into my otrs system today to see no tickets, and on closer examination, realized that I can’t see some of my queues. What would determine who can see which queues? Each agent can set his/her queues in his/her preferences. Log in, click Preferences and s

RE: [otrs] Can't see my queues

2007-06-19 Thread Eugene Ventimiglia
Interresting - The user I'm logged in as has r/w access to all groups, but the queue's Group attribute is "Agents" I can't see it. When I changed the queue's Group attribute to 'users' it works. Agents is valid Any other ideas? From: [EMAIL PROTECTED]

RE: [otrs] Can't see my queues

2007-06-19 Thread Greg Horne
A fast answer is Groups. Login as an Admin and verify that you are a member of the group that the queue was made part of. Greg Horne GEH GEHORNE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Eugene Ventimiglia Sent: Tuesday, June 19, 2007 10:53 AM To: o

[otrs] Can't see my queues

2007-06-19 Thread Eugene Ventimiglia
Hello All - I logged into my otrs system today to see no tickets, and on closer examination, realized that I can't see some of my queues. What would determine who can see which queues? --e ___ OTRS mailing list: otrs - Webpage: http://otrs.org

[OTRS] Customer Auto Login, how to avoid the registration/login process?

2007-06-19 Thread pierre biais
Hi the pros, I am currently modifying the InterfaceCustomer.pm (more precisely the CustomerAuth module) to let customers login automatically from our portal. Actually I want to use the same login/password as used on our portal to auto signup/login on the OTRS customer interface. Does anybody kno