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

Kevin Falcone falcone at bestpractical.com
Mon Jul 20 09:27:45 EDT 2009

On Sat, Jul 18, 2009 at 02:00:58AM -0400, Jerrad Pierce wrote:
> 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 syntax you want is "Told is 'NULL'" but right now the code that
builds date clauses doesn't treat 'is' as a valid operator, so there
would need to be some patching to build the query you want.


> The proper SQL equivalent works fine on the database directly,
> but in RT 3.8.2 the search results returns 0 tickets...

More information about the rt-users mailing list