Re: [rt-users] SearchBuilder and time intervals

2008-05-29 Thread Brian Gallew
Jesse Vincent wrote: > RT's ticketsql actually should be able to handle this somewhat more simply: > > Owner = 'jesse' AND Resolved > '2 weeks ago' > > works for me :) Wow, do I feel stupid! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/r

Re: [rt-users] SearchBuilder and time intervals

2008-05-29 Thread Jesse Vincent
RT's ticketsql actually should be able to handle this somewhat more simply: Owner = 'jesse' AND Resolved > '2 weeks ago' works for me :) On May 29, 2008, at 1:35 AM, Brian Gallew wrote: I'm having a problem doing time interval searches in RT. What I want is Owner = '11510' AND Resolved

[rt-users] SearchBuilder and time intervals

2008-05-28 Thread Brian Gallew
I'm having a problem doing time interval searches in RT. What I want is Owner = '11510' AND Resolved > datesub(curdate(), interval 2 weeks) The above syntax works for MySQL (which is what I'm using). Unfortunately, SearchBuilder doesn't seem to do the right thing with this. I've also not found