gt;new($session{'CurrentUser'});
$Tickets->FromSQL($Query);
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Simon Lane
Sent: March 17, 2009 8:59 AM
To: Ruslan Zakirov
Cc: rt-users@lists.bestpractical.com
Subje
--
From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com]
Sent: March 13, 2009 1:07 PM
To: Simon Lane
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] How to get tickets with nested SQL select statement
SimpleQuery does binding for you, ->SimpleQuery("... WHERE x = ? ...",
$
$Tickets[$ticket_count]->FromSQL($Query);
> $ticket_count++;
> }
>
> Sorry, I realize this might be a bit basic, but I am new and learning this.
> Thanks very much.
>
> -Original Message-
> From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com]
>
am new and learning this.
Thanks very much.
-Original Message-
From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com]
Sent: March 12, 2009 5:37 PM
To: Simon Lane
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] How to get tickets with nested SQL select statement
If you're
If you're working on something that's only for you then it's easier to
use $RT::Handle ( in 3.8 it should be written as RT->DatabaseHandle )
that returns connection to the DB. This object has SimpleQuery method
to execute any SQL. SimpleQuery returns sth (statement handle)
described in `perldoc DBI
I have an installation of RT (3.6.4) on Oracle and am trying to write a
report (a modified MyDay report) that displays only those tickets that have
been updated by the current user within a given period. I can get a list of
all tickets that have been modified by setting:
$Query = "LastUpdated