[rt-users] Un deleting tickets

[Joachim Thuau]

Chris, 

You probably should have searched for "status=deleted" and find the ticket
you wanted to bring back those (bulk update for example).
With the actual DB change underneath, I'm not sure if this would actually
workŠ

Jok
-- 
| Joachim Thuau | IT Systems Engineer - Linux / SpaceX |
| Cell: 310-890-7937 | Office: 310-363-6153 |





On 5/16/12 1:34 PM, "Chris Preston" <chris at thetrafalgartravel.com> wrote:

>You spoke of transaction tables, what would be the name of the table.  Why
>would I delete it if I want to keep the transaction, do you mean to change
>the status in that table also back to new or actually delete the
>transactions
>
>-----Original Message-----
>From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On Behalf
>Of Ruslan Zakirov
>Sent: Monday, April 30, 2012 9:07 AM
>To: Chris Preston
>Cc: rt-users at lists.bestpractical.com
>Subject: Re: [rt-users] Un deleting tickets
>
>On Thu, Apr 26, 2012 at 20:44, Chris Preston
><chris at thetrafalgartravel.com> wrote:
>> Hello all,
>>
>> I had set the status to deleted for thousands of records in a particular
>> queue.  I have now found out that we still need them.  So I went into
>>the
>> tickets table and updated the records that were set to deleted and put
>them
>> to new.  I also changed the date of a tickets and set it to an earlier
>date.
>>
>>
>>
>> Is this all that I needed to do or what does the system actually do
>>when a
>> record is set to deleted.
>
>RT also records Status change in Transactions table. You may want to
>delete those records.
>
>
>-- 
>Best regards, Ruslan.
>-----
>No virus found in this message.
>Checked by AVG - www.avg.com
>Version: 2012.0.1913 / Virus Database: 2411/4969 - Release Date: 04/30/12
>