[rt-users] Query in script not working

[Stephen Turner]

Quoting Mathew Snyder <mathew.snyder at gmail.com>:

> I'm trying to get all of the tickets which, for any given day, were 
> LastUpdated
> 'yesterday'.  When I do a search within RT using " LastUpdated = '2008-02-24'
> AND  (  Queue = 'CustomerCare' OR Queue = 'TechOps' )" I'm shown 8 tickets.
> However, when I run the following script I get nothing.
>
>

Mathew,

What do you get if you put 'print $yesterday' in your script? Also, printing
$tix->BuildSelectQuery (after the FromSQL statement) will show you the actual
sql statement being used, and might be helpful.

Steve