[rt-users] SearchBuilder and time intervals

[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 > 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 a way to get this to work from the
> documentation.  Have I missed something or is this simply impossible?
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080529/2f4ccada/attachment.sig>