All; I had a technician close a ticket with a state of "closed unsuccessful," when in fact it should have been "closed successful." Where can I go in the tables to change that? Thank you, Dominic L. Hilsbos, MBA, CSDA Director - Information Technology Perform Air International Inc.
Hi, 07.03.2016 17:16 - DHilsbos@performair.com schrieb:
I had a technician close a ticket with a state of "closed unsuccessful," when in fact it should have been "closed successful."
Where can I go in the tables to change that?
I would never change in the tables (via SQL) Click on a action to modify the state (for example phone call outbound) and close it successfull. -- Florian
Florian; If I were to do it that way, the resolution time would change. Thank you, Dominic L. Hilsbos, MBA, CSDA Director – Information Technology Perform Air International Inc. From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Florian Edlhuber Sent: Tuesday, March 08, 2016 10:24 AM To: otrs@otrs.org Subject: Re: [otrs] Modify Ticket Close State Hi, 07.03.2016 17:16 - DHilsbos@performair.com schrieb:
I had a technician close a ticket with a state of "closed unsuccessful," when in fact it should have been "closed successful."
Where can I go in the tables to change that?
I would never change in the tables (via SQL) Click on a action to modify the state (for example phone call outbound) and close it successfull. -- Florian
DHilsbos@performair.com schrieb:
I had a technician close a ticket with a state of "closed unsuccessful," when in fact it should have been "closed successful."
Where can I go in the tables to change that?
If you really want to do it in the database directly, here's how I would get to
it. I'm going from memory here, so consult mysql manuals in case of any doubts.
- log into mysql (either as root or as otrs user, as you need read/write access
- "use otrs;" to chooose the database
- "show tables;" to list all tables
You will need several tables. There's the ticket state table for one. I don't
know the exact name, I assume ticket_state.
- "explain ticket_state;" to have mysql tell you about all fields in this table
- "select * from ticket_state;" (short list probably) to list all entries
This will give you the state ids you need: The id for "closed unsuccessfully"
and the id for "closed successfully".
Now on to exploring where the ticket state is saved. If I remember correctly,
that's either in the ticket table or in the article table. Have mysql tell you
that via "explain ticket;".
You do not want to do a "select * from ticket" without more details. But you
should know the ticket number for the offending ticket. So you can look at the
current entry via "select * from ticket where tn="your ticket number";"
(Read the rest completely before executing!)
Now to change the value, once you are very sure you know the where statement
will select the right table row, it's something like (I'm guessing the names,
verify them!)
"update ticket set state_id=
Susan; That got me where I wanted to go, thank you. Thank you, Dominic L. Hilsbos, MBA, CSDA Director - Information Technology Perform Air International Inc. -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Susan Dittmar Sent: Wednesday, March 09, 2016 3:21 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Modify Ticket Close State DHilsbos@performair.com schrieb:
I had a technician close a ticket with a state of "closed unsuccessful," when in fact it should have been "closed successful."
Where can I go in the tables to change that?
If you really want to do it in the database directly, here's how I would get to it. I'm going from memory here, so consult mysql manuals in case of any doubts.
- log into mysql (either as root or as otrs user, as you need read/write access
- "use otrs;" to chooose the database
- "show tables;" to list all tables
You will need several tables. There's the ticket state table for one. I don't know the exact name, I assume ticket_state.
- "explain ticket_state;" to have mysql tell you about all fields in this table
- "select * from ticket_state;" (short list probably) to list all entries
This will give you the state ids you need: The id for "closed unsuccessfully"
and the id for "closed successfully".
Now on to exploring where the ticket state is saved. If I remember correctly, that's either in the ticket table or in the article table. Have mysql tell you that via "explain ticket;".
You do not want to do a "select * from ticket" without more details. But you should know the ticket number for the offending ticket. So you can look at the current entry via "select * from ticket where tn="your ticket number";"
(Read the rest completely before executing!)
Now to change the value, once you are very sure you know the where statement will select the right table row, it's something like (I'm guessing the names, verify them!)
"update ticket set state_id=
participants (3)
-
DHilsbos＠performair.com -
Florian Edlhuber -
Susan Dittmar