<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I have read a few posts on this and I am not sure those posts apply in
this case.<br>
<br>
I am dealing with RT 3.6.0pre0 under Oracle 10g:<br>
<br>
When doing searches, I have this in the Current search area:<br>
Queue = '<i>queuename</i>'<br>
AND 'CF.{<i>customfieldname</i>}' = '<i>Customvalue</i>'<br>
<br>
Where customfield expects a single value (a string).<br>
<br>
On clicking add and search the query returns no rows, even though there
are rows satisfying the criteria.<br>
<br>
Additional info:<br>
(1) The customfield is queue specific<br>
(2) I have already tried adding search criteria using GUI which adds
'CF.{<i>customfieldname</i>}' = '<i>Customvalue</i>'<br>
(3) I have also tried things (using Advanced) such as:<br>
(a) 'CF.{<i>queuename</i>.<i>customfieldname</i>}' = '<i>Customvalue</i>'<br>
(b) 'CF.{<i>queuename</i>}.{<i>customfieldname</i>}' = '<i>Customvalue</i>'<br>
<br>
I am in trying to get access to V$ views so that I can see what is
getting executed on the oracle side.<br>
<br>
am I missing something very simple?<br>
<br>
Thanks<br>
</body>
</html>