Re: [rt-users] shredding attachments based on date

[Jon 'Boli' Copeland]

you can shred based on sql query, such as

./rt-shredder --plugin "Tickets=query,Queue = 'Support' and Status =
'deleted';limit,5000" --sqldump /root/bup9.sql --force

...so you can change the query as you see fit.


On 19-Dec-16 2:38 PM, Andy Smith wrote:
>
> Hi all,
>
>   I'd like to remove attachments older than x months from the database
> and thought probably rt-shredder is the tool for this (its not
> something I've used before). Having googled this a bit and checked
> "rt-shredder --plugin help-Attachments" for instructions it looks like
> it may not be possible to use date, can anyone advise? Otherwise I
> guess I need to delete them directly from MySQL, not sure if this will
> make a mess of RT though,
>
> thanks for any help, Andy.
>
>  

-- 
Jon 'Boli' Copeland
Systems Engineer
IT Sales & Services Ltd
All sales enquiries   : sa...@itss.co.tz
All support enquiries : supp...@itss.co.tz
Emergencies Only  : +255 (0) 685 374780

[rt-users] Some RT search links not working on Firefox 43, but working fine on IE 11 and Chrome

[Jon 'Boli' Copeland]

FF43 seems to (sometimes) strip all the = symbols out of a search URL.
Anyone have any idea why? The same URL when copied and pasted to IE or
Chrome works just fine.

Many of my searches work just fine when they're in a dashboard, but if I
try to open (some of them) to do a bulk update - then I get an error
like this (as you can see - at least all = symbols have been stripped):

Other searches work fine in FF. All searches work fine in IE and Chrome

-- 
Jon 'Boli' Copeland
Systems Engineer
IT Sales  Services Ltd