Help on Searching Comments

We recently switched to RT for project management where I work. One of the
big advantages to using this system was for time management. Now, the
system has been in place for about a month and I need to go back through
and see all the work that I have done in the past month. I posted comments
and time worked on various projects (Some that I owned, some that I
didn’t).

I have used the query builder and its several options, but there does not
appear to be any formulas for outputing results. Does anyone already do
this? Basically I need the following.

List all comments from user X between 8/1/2005 and 8/31/2005 for all
tickets in [queue] regardless of status and ownership.

I have spent hours looking at all the mailing list archives and have
searched the wiki and related resources. Any help would be appreciated.
There are about 25 of us where I work that desperately need this time of
reporting.

-John Oliver

We recently switched to RT for project management where I work. One of the
big advantages to using this system was for time management. Now, the
system has been in place for about a month and I need to go back through
and see all the work that I have done in the past month. I posted comments
and time worked on various projects (Some that I owned, some that I
didn’t).

I have used the query builder and its several options, but there does not
appear to be any formulas for outputing results. Does anyone already do
this? Basically I need the following.

List all comments from user X between 8/1/2005 and 8/31/2005 for all
tickets in [queue] regardless of status and ownership.
You can’t build this report with clear RT WebUI, but this type of
report is easy to implement as new page. If you can’t hack RT yourself
then you can ask for help at sales@bestpractical.com.

I have spent hours looking at all the mailing list archives and have
searched the wiki and related resources. Any help would be appreciated.
There are about 25 of us where I work that desperately need this time of
reporting.

-John Oliver


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

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.