Re: Qualification Error - Strange?
*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 2 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=aolfod000301.
__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
Re: Qualification Error - Strange?
*Hi Kathy Morris,*
Your second part of the question--*
Sometimes when I use LIKE %Mary Smith I find the name faster than if I
type = Mary Smith - never understood why.
*
*
Answer--*
A search on a character field with a QBE match type of Anywhere
performs a full table scan of the database,
reading every record in a form and ignoring any indexes for the field.
Searches on fields where the QBE match type is Leading or Equal are
typically *faster* than searches on fields
where the match type is Anywhere, especially if the field is indexed, as
described in Defining indexes forms6.html#wp256590.
Some relational operators and wildcards work during a query-by-example
regardless of the QBE Match setting.
This means that users can specify an exact match in a field with a QBE
Match setting of Anywhere by using the equal sign (=) relational
operator.
Users can also use the percent sign (%) wildcard at the beginning of the
search string (|%abcd|) to override a QBE Match setting of Leading or
Equal.
However, using the % wildcard anywhere else in a string (|abcd%|) does
not override the Equal setting.
Overriding the Leading or Equal QBE Match settings overrides the
performance benefits of using those settings.
Hope this helps...
Regards,
*Sandeep
Vyom Labs Pvt. Ltd.
An ISO 2 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=aolfod000301.
__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
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=aolfod000301)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Qualification Error - Strange?
Kathy,
It is Boolean logic as implemented by you favorite SQL optimizer.
X or Y and Z == x or ( y and z) because AND has a higher precedence than OR.
John
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris
Sent: Tuesday, May 20, 2008 8:27 PM
To: 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
http://food.aol.com/dinner-tonight?NCID=aolfod000301 twists on
family favorites at AOL Food.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
E-mail message checked by Internet Security (5.5.0.191)
Database version: 5.09860
http://www.pctools.com/Internet-Security/
E-mail message checked by Internet Security (5.5.0.191)
Database version: 5.09860
http://www.pctools.com/Internet-Security/
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Qualification Error - Strange?
The first qualification would be interpreted as:
('Assignee+' = Michael Davis) OR (( 'Assignee+' = Gurpreet Savi) AND
('Status*' = 3))
That explains the result return all entries with Status as they match with
Michael Davis
AF
On Tue, May 20, 2008 at 5:27 PM, Kathy Morris [EMAIL PROTECTED]
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=aolfod000301.
__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
Re: Qualification Error - Strange?
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=aolfod000301)
___
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
