[rt-users] question on reporting

Jonathan Jesse jjesse at ftpb.com
Thu Dec 15 16:13:30 EST 2005

Wow, lots of replies thanks guys... I think I will tackle it two ways.
1.  The short way is to get the schema down as much as I need to get the
information out that my boss and above is looking for
2.  Learn perl better to get the information out that I need.

Thanks again,


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jim Meyer
Sent: Thursday, December 15, 2005 3:39 PM
To: Les Mikesell
Cc: Hersker, Steve; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] question on reporting


On Thu, 2005-12-15 at 11:52, Les Mikesell wrote:
> On Thu, 2005-12-15 at 14:22, Todd Chapman wrote:
> > I can understand that, but if you are going to spend time
> > learning something, your time would be better spent 
> > learning perl/RT API than figuring out the schema. Going
> > the perl route will serve you many times over, for many
> > tasks.
> On the other hand, learning SQL is useful for a lot of
> other things too, and you are a lot more likely to find
> pretty reporting tools that work natively with SQL databases
> than anything that works with RT's API. 

My free advice, which is worth exactly what you paid for it:

Using RT's Perl API is an order of magnitude faster and far, far more
safe -- I know the report I wrote for v3.0.1 will work in v3.5.5 (and
most of the stuff I wrote for v2.2 as well). If your knowledge of both
Perl and SQL is sketchy, I'd recommend learning Perl as it's (a) more
utilitarian, and (b) the API will give you data integrity which, unless
you know SQL to reasonable depth, you can't guarantee on your own. Is it
worthwhile to make reports fast if you're not sure they're accurate?

I know both Perl and SQL to reasonable depth. I've got all sorts of SQL
reporting tools handy that I could use if I chose to. I don't choose to.


Jim Meyer, Geek at Large                                    purp at acm.org


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

Download a free sample chapter of RT Essentials from O'Reilly Media at

WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at

More information about the rt-users mailing list