Hello Michael, You got me a bit confused here as "($GROUPS$ LIKE "%System POC%" )" is a part of a qualification.
I believe that LIKE keyword will search the whole database and I think it will find at least one record where $GROUPS$ is %System POC% AND the 'Dialog_Prev_Status' is one of those 3. May be you need to narrow-down to a record level somehow to avoid having to scan the whole table. I would put a pre-condition like have another field on the form and (let's say temp_group) set temp_group = "YES" if (($GROUPS$ LIKE "%System POC%" ) OR ($GROUPS$ LIKE "%Reshipment%" ) OR ($GROUPS$ LIKE "%Quality Assurance%" )) otherwise set it to "NO" And then re-write your original qual as (( 'Dialog_Prev_Status' = "Closed" ) OR ( 'Dialog_Prev_Status' = "Helpdesk Working" ) OR ( 'Dialog_Prev_Status' = "Pending Vendor" )) AND (temp_group = "YES") I hope this helps. Best regards, Neel Gautam Accenture - Chicago Delivery Centre Office: 312-693-7279 Mobile: 630-440-6335 MSN: [EMAIL PROTECTED] AIM: neelgautam Core Values: Stewardship * Best People * Client Value Creation * One Global Network * Respect for the Individual * Integrity From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SrA HQ 754 ELSG/DOO Sent: Wednesday, April 25, 2007 9:53 AM To: [email protected] Subject: Boolean Logic Version 5.1.2 SQL 2K I'm having problems with a run if condition that isn't allowing our System POC's to send emails. Here's the condition. (( 'Dialog_Prev_Status' = "Closed" ) OR ( 'Dialog_Prev_Status' = "Helpdesk Working" ) OR ( 'Dialog_Prev_Status' = "Pending Vendor" )) AND (($GROUPS$ LIKE "%System POC%" ) OR ($GROUPS$ LIKE "%Reshipment%" ) OR ($GROUPS$ LIKE "%Quality Assurance%" )) If it evaluates to true, a message pops up that tells the user they don't have permission to update a ticket that had a previous status of: $Dialog_Prev_Status$ The problem is, this always evaluates to true if $GROUPS$ = "System POC" regardless of the value of Dialog_Prev_Status. I unhid Dialog_Prev_Status to make sure, and I had a ticket where Dialog_Prev_Status = "Sys POC Working" and it still evaluated to true and didn't allow the System POC to update the ticket. I'm sure it's something boneheaded that I'm missing but I can't wrap my head around it. Michael A. McManus, SrA, USAF Remedy Developer HQ 754 ELSG/DOOH DSN: 596-6478/Comm: 334-416-6478 This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
