> I'm trying to do a search in the Query Builder interface for tickets > with null Told (Last Contacted) date - I can't figure out how to do > it. Does anyone know how?
Here's what I suggest, since this seems to be a problem with RT not knowing how to query for null dates. 1. mysql> alter table Tickets change Told Told datetime not null default '0000-00-00 00:00:00'; 2. mysql> update Tickets set Told='0000-00-00 00:00:00' where Told is null; 3. TicketSQL: Told < '1980-01-01 00:00:00' Or you can use some other really old date for 3. But now, you're dealing with valid datetime values rather than NULL, so the query with the comparison operator will work. Also note, this will not affect how "Last Contact" is displayed in the ticket display screen (it will still say "Not set"). Funny thing, however, is that this TicketSQL: Told = '0000-00-00 00:00:00' will not work. Probably due to a problem someone else posted in the list in the past day, about there being some weird off by one date calculation/string conversion or something. Eric Schultz United Online _______________________________________________ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
