I’m trying to create a Dashboard which will mail out the tickets for
review which are going to be purged from the system by rt-scrubber.
In testing I have found something weird. Giving rt-scrubber a query
like this works fine.
rt-shredder --plugin “Tickets=query, Status = ‘deleted’ AND
LastUpdated < ‘90 days ago’;limit,100” --sqldump /u/rtweb/shredder-
restore.sql
However the same query in the ticket system returns no results. Is
there something about doing ticket queries where Deleted is not a
valid status? How do we solve this problem?
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness
There is no way to search deleted tickets in the web UI.On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett jrhett@netconsonance.com wrote:
I’m trying to create a Dashboard which will mail out the tickets for
review which are going to be purged from the system by rt-scrubber.
In testing I have found something weird. Giving rt-scrubber a query
like this works fine.
rt-shredder --plugin “Tickets=query, Status = ‘deleted’ AND
LastUpdated < ‘90 days ago’;limit,100” --sqldump /u/rtweb/shredder-
restore.sql
However the same query in the ticket system returns no results. Is
there something about doing ticket queries where Deleted is not a
valid status? How do we solve this problem?
–
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Best regards, Ruslan.
You can use custom portlet based on a component with
$tickets->{‘allow_search_deleted’} = 1;On Wed, Jun 3, 2009 at 6:04 PM, Ruslan Zakirov ruslan.zakirov@gmail.com wrote:
There is no way to search deleted tickets in the web UI.
On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett jrhett@netconsonance.com wrote:
I’m trying to create a Dashboard which will mail out the tickets for
review which are going to be purged from the system by rt-scrubber.
In testing I have found something weird. Giving rt-scrubber a query
like this works fine.
rt-shredder --plugin “Tickets=query, Status = ‘deleted’ AND
LastUpdated < ‘90 days ago’;limit,100” --sqldump /u/rtweb/shredder-
restore.sql
However the same query in the ticket system returns no results. Is
there something about doing ticket queries where Deleted is not a
valid status? How do we solve this problem?
–
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
–
Best regards, Ruslan.
Best regards, Ruslan.
Sorry to be dense, but can you translate the first sentence for me? 
I realize that this parameter needs to be set, I’m just unclear as to
how.
And would you guys accept a patch which put a checkbox for searching
deleted messages on the Web UI?On Jun 3, 2009, at 7:05 AM, Ruslan Zakirov wrote:
You can use custom portlet based on a component with
$tickets->{‘allow_search_deleted’} = 1;
On Wed, Jun 3, 2009 at 6:04 PM, Ruslan Zakirov <ruslan.zakirov@gmail.com wrote:
There is no way to search deleted tickets in the web UI.
On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett jrhett@netconsonance.com wrote:
I’m trying to create a Dashboard which will mail out the tickets for
review which are going to be purged from the system by rt-scrubber.
In testing I have found something weird. Giving rt-scrubber a query
like this works fine.
rt-shredder --plugin “Tickets=query, Status = ‘deleted’ AND
LastUpdated < ‘90 days ago’;limit,100” --sqldump /u/rtweb/shredder-
restore.sql
However the same query in the ticket system returns no results. Is
there something about doing ticket queries where Deleted is not a
valid status? How do we solve this problem?
–
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
–
Best regards, Ruslan.
–
Best regards, Ruslan.
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness
Sorry to be dense, but can you translate the first sentence for me?
I realize that this parameter needs to be set, I’m just unclear as to how.
Create share/html/Elements/DeleteTickets that does the search and
displays it, register it in HomepageComponents option.
And would you guys accept a patch which put a checkbox for searching deleted
messages on the Web UI?
It’s up to Jesse Vincent.
You can use custom portlet based on a component with
$tickets->{‘allow_search_deleted’} = 1;
There is no way to search deleted tickets in the web UI.
I’m trying to create a Dashboard which will mail out the tickets for
review which are going to be purged from the system by rt-scrubber.
In testing I have found something weird. Giving rt-scrubber a query
like this works fine.
rt-shredder --plugin “Tickets=query, Status = ‘deleted’ AND
LastUpdated < ‘90 days ago’;limit,100” --sqldump /u/rtweb/shredder-
restore.sql
However the same query in the ticket system returns no results. Is
there something about doing ticket queries where Deleted is not a
valid status? How do we solve this problem?
–
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
–
Best regards, Ruslan.
–
Best regards, Ruslan.
–
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source and
other randomness
Best regards, Ruslan.