Also, If u want to see for all the member of his groups then, remove the qual - (( 'Assignee Login ID' = $USER$) OR ( 'Assignee Login ID' = $NULL$) So the Final Qual will be - (( 'Status' != "Closed") AND ( 'Status' != "Resolved") AND ( 'Status' ! = "Cancelled")) AND ($GROUPS$ LIKE 'Assignment Group') Lemme know if this helped! Kinnary
________________________________ From: Kinnary Shah (WT01 - FINANCE BANKING & SERVICES) Sent: Tue 7/24/2007 8:33 AM To: arslist@ARSLIST.ORG Subject: RE: Table qualification for open incidents assigned to the group. Hi , U want the open tickets assigned to "His" groups, rt? Try this - (( 'Status' != "Closed") AND ( 'Status' != "Resolved") AND ( 'Status' ! = "Cancelled")) AND (( 'Assignee Login ID' = $USER$) OR ( 'Assignee Login ID' = $NULL$) AND ($GROUPS$ LIKE 'Assignment Group') Regards, Kinnary ________________________________ From: Action Request System discussion list(ARSList) on behalf of BeXpress Sent: Tue 7/24/2007 4:23 AM To: arslist@ARSLIST.ORG Subject: Re: Table qualification for open incidents assigned to the group. I tried qualification that you suggested Don and got the same outcome. Thanks Brian On Jul 23, 4:19 pm, Don McClure <[EMAIL PROTECTED]> wrote: > 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! > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"