*Hi Kathy Morris,*

When you use multiple operators to construct qualification criteria, they are evaluated in the following order:

  1. |( )|
  2. |NOT (!) -| (unary minus)
  3. |* / %|
  4. |+ -|
  5. |< <= > >= = != LIKE|
  6. |AND (&&)|
  7. |OR (||)|

Operators of the same precedence are performed left to right. You can use parentheses in an expression to override operator precedence. AR System evaluates expressions inside parentheses /first/ before evaluating those outside In the expression --> 'Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi" AND 'Status*' <= 3, as per precedence rule,AND will be evaluated first i.e.('Assignee+' = "Gurpreet Savi" AND 'Status*' <= 3) will be evaluated first
and then OR will be evaluated.
Hope this helps...

*Regards,
*

*Mahendra.
*

*Vyom Labs Pvt. Ltd.
An ISO 20000 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
*



Kathy Morris wrote:
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>. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

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

Reply via email to