[Rt-devel] Custom SQL Query for RT at a glance
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:
> 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.
Senior Programmer/Analyst - SAIS
More information about the Rt-devel