[PATCH] Searches like Created = 'YYYY-MM-DD'(was: [rt-users] Query Problem)

[Olivier Horec]

Thanks for your reply,

2005/8/2, Ruslan Zakirov <ruslan.zakirov at gmail.com>:
> On 8/1/05, Olivier Horec <olivier.horec at gmail.com> wrote:
> > Hi,
> >
> > I have made a few tests with the patch "Searches by Owner's fields". I
> > have detected two problems.
> >
> > First, I can't search Ticketsw with the owner Id anymore (it was used
> > to display your tickets on the "RT at a glance" page)
> Is it your code? If so, please, show code sample.
> 

No, it's in the code used to display tickets on the home page by default.
In html/Elements/MyTickets :
my $Query = " Owner = '".$session{'CurrentUser'}->Id."' AND ( Status =
'new' OR Status = 'open')";
(If I replace $session{'CurrentUser'}->Id by
$session{'CurrentUser'}->Name, it works)

> >
> > When I make a search with "Owner = 'Nobody'",  I get the Tickets
> > contained in the "___Approvals" queue. (when I don't use "Owner =
> > 'Nobody'", I don't get these tickets)
> What's results you get without patch?

Without the patch, it never shows the Tickets in the "___Approvals" queue.

> 
> >
> > Has anyone tried to install this patch ?
> Yeah, I made some hand testing, but could miss something...
> 
> >
> > Thanks in advance
> >
> > Olivier
> >