[rt-users] custom fields query not showing all tickets

[Anthony R. J. Ball]

  A custom field has to be global to ALWAYS show up in the search... 
otherwise a queue needs to be searched that contains it (i.e. Queue
is 'FOO')

On Mon, Apr 11, 2005 at 04:57:44PM +0200, Filip Jonckers wrote:
> RT version 3.4.1 (latest stable version) installed on Windows 2003
> server ...
> 
> Added several custom fields (applied to all queues)
> one of them has the "select one value" type where you can choose between
> "Yes" or "No"
> 
> This field is used to query a report where I would like to see all
> tickets
> which have status=Resolved and the custom field (mycustomfield) should
> not be "Yes"
> (this field is set to value "Yes" after the report has been run)
> 
> Advanced view of the query:
> 
>  Status = 'resolved'  AND 'CF.{mycustomfield}' != 'Yes' 
> 
> '<b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#',
> '__Subject__',
> '__Created__',
> '__Status__',
> '__CustomField.{mycustomfield}__'
> 
> This results in a list of tickets only having the "No" value
> which basically is correct - but I don't get the tickets were <no value>
> has been entered in the custom field
> There is no restriction possible on the custom field to have only Yes/No
> value (must be filled in...)
> so the custom field is often set to <no value> ... (users forget to
> enter this ofcourse...)
> 
> we used the same query in the older RT version 3.0.12 I believe - it
> worked fine
> 
> is there a way to get all the tickets using the query builder or is this
> a bug in the query builder ?
> 
> any help appreciated
> 
> Filip
> 
> CONFIDENTIALITY NOTICE
> -----------------------------------------------
> This E-mail message and any documents which accompany it are intended only for the use of the individual or entity to which addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law.  If the reader is not the intended recipient, any disclosure, distribution or other use of this E-mail message is prohibited.  If you have received this E-mail message in error, please delete and notify the sender immediately.  Thank you.
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 

-- 
     www.suave.net - Anthony Ball - ant at suave.net
        OSB - http://rivendell.suave.net/Beer
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
If the enemy is in range, so are you.