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

[Stephen Turner]

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.
>

Michel,

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.

Steve

-- 
Stephen Turner
Senior Programmer/Analyst - SAIS
MIT IS&T