[Rt-devel] Custom SQL Query for RT at a glance

Stephen Turner sturner at MIT.EDU
Tue Jan 20 13:58:33 EST 2009

On Tue, 20 Jan 2009 13:02:42 -0500, Michel Kohl <mkohl at linux.lu> wrote:

> Hello,
> I have now spent hours to find out how to integrate custom SQL commands
> into an extension for the RT at a glance page.
> I know that I could easily use PERLs SQL interface to do the job.
> But I wonder if I could not use the existing SQL handle of RT to execute
> an SQL command on the RT database.


This will get you a DBI-style database handle:

my $dbh = $RT::Handle->dbh;

I'd only use this for reading from the DB. You could ruin your day by  
doing direct SQL updates.


Stephen Turner
Senior Programmer/Analyst - SAIS

More information about the Rt-devel mailing list