[rt-users] How to see no value selected in custom field

[Sean]

Does anyone know how to see if a custom field has not been set in the example below?

----- Original Message ----
From: Sean <stroke_of_death at yahoo.com>
To: Brian Gallew <geek+rt at cmu.edu>; RT-Users at lists.bestpractical.com
Sent: Thursday, September 20, 2007 5:41:46 PM
Subject: Re: [rt-users] Custom reports


All,

I implemented the attached report generator, and it works great with one exception.
I would like to be able to see which tickets do not have a value in that custom field. Meaning, the page shows a count of how many tickets have value x, and value y in that custom field, I would like an additional count of how many have not set something in that custom field and after a few hours, I still cant figure out how to do it so I thought I would ask. I have reattched the file for convienience.

Thanks,
Jeff

----- Original Message ----
From: Brian Gallew <geek+rt at cmu.edu>
To: RT-Users at lists.bestpractical.com
Sent: Wednesday, September 12, 2007 6:42:48 AM
Subject: Re: [rt-users] Custom reports


Fernando Fugita wrote:
> Hello,
>
> I need to create a custom report, showing the number of tickets for 
> certain type (a custom field of the RT), in a determined period.
> I tried the RTx-Statistics, but was not useful.

You really have to write it yourself.  Attached is a report that we use 
at Carnegie Mellon - Qatar.


      ____________________________________________________________________________________
Catch up on fall's hot new shows on Yahoo! TV. Watch previews, get listings, and more!
http://tv.yahoo.com/collections/3658


       
____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search 
that gives answers, not web links. 
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC