[rt-users] Query Problem

[Olivier Horec]

I had a look at the SQL queries about the date problem.

In fact, when I search with a query like : Created = '2005-07-19',
I find this in the SQL log :
( ( (main.Created >= '2005-07-18 00:00')AND(main.Created <=
'2005-07-18 23:59') ) )

Has anyone an idea ?

Olivier

2005/7/28, Ruslan Zakirov <ruslan.zakirov at gmail.com>:
> On 7/28/05, Olivier Horec <olivier.horec at gmail.com> wrote:
> > Hi,
> >
> > I posted this problem before but I wasn't able to solve it.
> >
> > I have detected some problems with the queries in RT (the variable
> > "Query" in RT, used to make searh on tickets)
> >
> > The first problem is that you can't make searches on Owner Real Name
> > (the only thing you can do is search with the exact owner name)
> I plan to fix this in near future.
> 
> >
> > The second problem is when you search tickets with dates : you get the
> > tickets one day before the query.
> >
> > Has anyone tried to solve the problem or can anyone give me some ideas
> > to help me to solve it.
> >
> > Thanks in advance
> >
> > Olivier
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> >
> 
> 
> --
> Best regards, Ruslan.
>