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

[Filip Jonckers]

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.