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 isOwner = '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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
PGP.sig
Description: This is a digitally signed message part
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
