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" <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf >Of Ruslan Zakirov >Sent: Monday, April 30, 2012 9:07 AM >To: Chris Preston >Cc: [email protected] >Subject: Re: [rt-users] Un deleting tickets > >On Thu, Apr 26, 2012 at 20:44, Chris Preston ><[email protected]> 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 >
