It literally reads the qualification as:  
assigned = x ,regardless of status, OR (assigned = x and status  less than 3).

It assumes the "and" and the last qualification before it are paired together.  
When you added the brackets you specified (this group of qualifications) PLUS 
this qualification.

If they had all been "or", or "and", it wouldn't have been a problem.

Hope that helps.

-----Original Message-----
From: Kathy Morris <[EMAIL PROTECTED]>
Sent: Tuesday, May 20, 2008 7:26 PM
To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>
Subject: Qualification Error - Strange?

Hello all,
 
I ran this qualification:
 
'Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi"  AND 'Status*' 
<= 3
 
Result:  status values that such as Closed and  Cancelled appeared that have 
a value of 5 and 6?? 
 
When I modified the qualification:
('Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet  Savi") AND 
'Status*' <= 3
Result:  the values that were less than or equal to 3  appeared correctly.
 
What logic is this based on?  
 
Sometimes when I use LIKE %Mary Smith I find the  name faster than if I type 
= "Mary Smith" - never understood  why.



**************Wondering what's for Dinner Tonight? Get new twists on family 
favorites at AOL Food.      
(http://food.aol.com/dinner-tonight?NCID=aolfod00030000000001)

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
This message is subject to and does not create or vary any contractual 
relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries 
or affiliates and you. Internet communications are not secure and therefore the 
TuringSMI Group does not accept any legal responsibility for the contents of 
this message. Any views or opinions expressed are those of the author.  This 
message is intended for the addressee(s) only and its contents and any attached 
files are strictly confidential. If you have received it in error, please 
contact the sender on the number above.

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to