[rt-users] Showing full history in a query or report.

Kenneth Marshall ktm at rice.edu
Thu Feb 28 14:12:46 EST 2008


It sounds like something that could be done with the rt
commandline tool or a perl script using the RT API.

Cheers,
Ken

On Thu, Feb 28, 2008 at 07:09:42PM -0000, Stef Morrell wrote:
> Hi,
> 
> I've been back over the lists and I can't find any reference to this, so
> I'm probably asking a stupid question.
> 
> I'm in the process of setting up RT as a replacement to an old (largely
> broken) in-house ticketing system, coded by a long since gone employee,
> but I've hit a stumbling block.
> 
> I need to be able to produce a report each month which shows the full
> history on any open tickets or any tickets closed in the month.
> 
> I'm hoping there is something I can do in a query, but the more I fiddle
> with it, the more my hope is fading and I'm wondering if I need to be
> looking at a scrip, or perhaps a complex SQL query.
> 
> I wonder if anyone on the list has already solved this or a similar
> problem and can point me in the right direction?
> 
> Regards
> 
> Stef
> Stefan Morrell          | Operations Director
> Tel: 0845 3452820       | Alpha Omega Computers Ltd
> Fax: 0845 3452830       | Incorporating Level 5 Internet
> stef at aoc-uk.com         | stef at l5net.net
> 
> Alpha Omega Computers LTD computer network solution providers putting
> the technology in place that makes your information work for you. Visit
> our website for more information about how Alpha Omega can enhance your
> business. IMPORTANT: This E-Mail is confidential and may also be
> privileged. If you are not the intended recipient, please notify us
> immediately by telephoning +44 (0) 845 345 2820. Internet communications
> are not necessarily secure and may be intercepted or changed after they
> are sent. Alpha Omega Computers LTD does not accept liability for any
> such changes. If you wish to confirm the origin or content of this
> communication, please contact the sender using an alternative means of
> communication. In messages of a non-business nature, the views and
> opinions of the author are their own and do not necessarily reflect the
> views and opinions of the organisation.
> 
> Alpha Omega Computers Ltd, Unit 57, BBTC, Grange Road, Batley, WF17 6ER.
> Registered in England No. 3867142.  VAT No. GB734421454
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 



More information about the rt-users mailing list