Have you tried a slight Boolean modification: (( 'Status' != "Closed") AND ( 'Status' != "Resolved") AND ( 'Status' ! = "Cancelled")) AND (( 'Assignee Login ID' = $USER$) OR ( 'Assignee Login ID' = $NULL$)) I took the liberty of some whitespace--important point is that the 'Login ID' checks must be in one set of parentheses--else de Morgan's law will undo your logic!
>>> BeXpress <[EMAIL PROTECTED]> 23-Jul-07 4:02 PM >>> I hope some of you guys can help me with this, I submitted this to Remedy support over a month ago and cannot get an answer. I have created a table field in a form to display incidents that are assigned to the group with no individual assignee and open incidents that are assigned to the other members of the group that you are in. The problem that I am running into is that in the table you can only see the incidents that have no assignee and the incidents that are assigned to you. The incidents that are assigned to members of your group are not displaying. Here is the qualification that I am using: (( 'Status' != "Closed") AND ( 'Status' != "Resolved") AND ( 'Status' ! = "Cancelled") AND ( 'Assignee Login ID' = $USER$)) OR (( 'Assignee Login ID' = $NULL$) Please let me know what changes need to be made to it. We are running ARS 7.01, Windows 2003, SQL Let me know if you need anymore information. Thanks Brian _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
