Brian, The qualification that you typed will only list cases for current USER or "No assignee".
If you want to include all cases for your GROUP, you need to make the qualification include AssigneeGroup... Of course, you'll need to determine whether there'll be a static GROUP that you want as a part of that table, or, will you be putting in some more dynamic lookup?? George Payne Assistant Director, User Services Information Technology Services University of Texas at Austin 512.232.7513 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Don McClure Sent: Monday, July 23, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: Table qualification for open incidents assigned to the group. 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" __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
