[rt-users] Finding tickets that have never been worked on

Jerrad Pierce jpierce at cambridgeenergyalliance.org
Sat Jul 18 02:00:58 EDT 2009


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.



More information about the rt-users mailing list