Home Page Queries

RT Users
1

Hello List,

Is it possible to show multiple “user queries” on the home page? For
instance, in addition to the “20 Highest Priority Tickets I Own”, I want to
show the:

  •      "20 Longest Ignored Tickets I Own" (determined by the amount of

time they have gone without any updates), and the

  •      "20 Oldest Tickets I Own" (determined by their date created)

Would this be something that could be done? If so, would you please tell me
how? In very specific laymen’s terms please. :slight_smile:

Thanks,

Kris

2

Hello again,

So. Is that a no? Or has this been asked before and I just need to look
deeper into the archives? Oh by the way, my version number is 3.2.2.
Someone else mentioned that if I had version 3.5 or above, this would be an
easy task. Unfortunately, I don’t.

Please Advise,

KrisFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kristopher
Lusk
Sent: Tuesday, May 02, 2006 3:54 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Home Page Queries

Hello List,

Is it possible to show multiple “user queries” on the home page? For
instance, in addition to the “20 Highest Priority Tickets I Own”, I want to
show the:

  •      "20 Longest Ignored Tickets I Own" (determined by the amount of

time they have gone without any updates), and the

  •      "20 Oldest Tickets I Own" (determined by their date created)

Would this be something that could be done? If so, would you please tell me
how? In very specific laymen’s terms please. :slight_smile:

Thanks,

Kris

3

This was answered many times.On 5/4/06, Kristopher Lusk klusk@brit.com wrote:

Hello again,

So… Is that a no? Or has this been asked before and I just need to look
deeper into the archives? Oh by the way, my version number is 3.2.2.
Someone else mentioned that if I had version 3.5 or above, this would be an
easy task. Unfortunately, I don’t.

Please Advise,

Kris

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Kristopher Lusk
Sent: Tuesday, May 02, 2006 3:54 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Home Page Queries

Hello List,

Is it possible to show multiple “user queries” on the home page? For
instance, in addition to the “20 Highest Priority Tickets I Own”, I want to
show the:

  •      "20 Longest Ignored Tickets I Own" (determined by the amount of

time they have gone without any updates), and the

  •      "20 Oldest Tickets I Own" (determined by their date created)

Would this be something that could be done? If so, would you please tell me
how? In very specific laymen’s terms please… J

Thanks,

Kris

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

We’re hiring! Come hack Perl for Best Practical:
Careers — Best Practical Solutions

Best regards, Ruslan.

4

Hello,

Have you seen Request Tracker Wiki ? While I haven’t attempted to make any of these modifications myself (we’re waiting for 3.6), it seems like this is what you’re looking for, no?

Sincerely,
Frank Pater
DCANet

voice: 888-4-DCANET (888-432-2638)
fax: 302-426-6386On Wed, May 03, 2006 at 04:15:18PM -0500, Kristopher Lusk wrote:

Hello again,

So… Is that a no? Or has this been asked before and I just need to look
deeper into the archives? Oh by the way, my version number is 3.2.2.
Someone else mentioned that if I had version 3.5 or above, this would be
an easy task. Unfortunately, I don’t.

Please Advise,

Kris

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kristopher
Lusk
Sent: Tuesday, May 02, 2006 3:54 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Home Page Queries

Hello List,

Is it possible to show multiple “user queries” on the home page? For
instance, in addition to the “20 Highest Priority Tickets I Own”, I want
to show the:

  •      "20 Longest Ignored Tickets I Own" (determined by the amount of

time they have gone without any updates), and the

  •      "20 Oldest Tickets I Own" (determined by their date created)

Would this be something that could be done? If so, would you please tell
me how? In very specific laymen’s terms please… J

Thanks,

Kris

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

We’re hiring! Come hack Perl for Best Practical: Careers — Best Practical Solutions

5

Hi,

Due to some testing I had to create several fake users in RT. Those users
were never added to any group, ever posted anything, never created any
ticket. Now I need to delete them.

The manual says that you cannot delete users, only disable them. Well, I
do not believe that I cannot do what I want. I want to delete them in
order not to pollute databases with junk.

I want to go to rt database, go to table Users and execute mysql delete
command on those users. This will delete them. But is it enough? Is the
user information cross referenced somehow from other tables?

Those users did not do any activity, so they do not own any tickets, and
the like. I assume that they do not appear in any tables but Users, but I
would like to be sure.

Tomasz Wlodek | tel 631-344-7448
Brookhaven Laboratory, Building 510M | fax 631-344-7616
Upton NY 11973-5000 |

6

At Monday 5/8/2006 05:34 PM, Tomasz Wlodek wrote:

Hi,

Due to some testing I had to create several fake users in RT. Those users
were never added to any group, ever posted anything, never created any
ticket. Now I need to delete them.

The manual says that you cannot delete users, only disable them. Well, I
do not believe that I cannot do what I want. I want to delete them in
order not to pollute databases with junk.

I want to go to rt database, go to table Users and execute mysql delete
command on those users. This will delete them. But is it enough? Is the
user information cross referenced somehow from other tables?

Those users did not do any activity, so they do not own any tickets, and
the like. I assume that they do not appear in any tables but Users, but I
would like to be sure.

Tomasz,

Don’t do it!!! You’ll be sorry.

Grab Ruslan’s RTx::Shredder extension - it removes tickets & users
safely. See Request Tracker Wiki
under Packages.

Steve