How do you get the SQL that is generated from the ticketSQL

I am trying to get the SQL that will be sent to the database given some
ticketSQL.

I am not sure what I am doing is the right way to try to do this and
unfortunately it is not working anyway.

Does anyone have some tips?

I tried the following but it gives me an error of:
Can’t locate object method “QueryHistory” via package “RT::Tickets”

But looking at this documentation I thought it would work.

#!/usr/bin/perl
use strict;
use warnings;
use v5.10;
use RT -init;
use RT::Ticket;
my $ticketSQL = “Id=‘1’”;
my $tickets = RT::Tickets->new( RT->SystemUser );
my $validQuery = $tickets->FromSQL($ticketSQL);
say $tickets->QueryHistory();

Thanks
HP

do “export DBI_PROFILE=2” before running your command :wink:

(see also $StatementLog in RT_Config.pm)

Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com