Hi all, I'd like to be able to find tickets that have never been worked on, but am having difficulty doing so. In this case, no work means no replies sent to the user. I had not luck searching the list archives or wiki, but stumbled into TicketSQL on the wiki when researching something else and it seems to indicate that I ought to be able to search for: Told = NULL
The proper SQL equivalent works fine on the database directly, but in RT 3.8.2 the search results returns 0 tickets... -- Cambridge Energy Alliance: Save money. Save the planet. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com