Search for deleted tickets in a Dashboard?

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


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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? :wink:

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


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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? :wink:

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


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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.