sean_gilbert
Well Known Member
RE:using AND and OR
Gentlemen,
Here's my two cents...
It seems that the 'OR' only works to seperate groupings of 'AND'
statements...
Zoltan is right in that OneWorld will require a much longer set of
statements...
Following is my OneWorld Data Selection interpretation of your request..
where (((fieldA = value1 or fieldB = value2) and
(fieldC > value3 and fieldD < value4)) or
((fieldA = value5 or fieldB = value6) and
(fieldC > value7 and fieldD < value8)))
OneWorld
Where FieldA = value1
AND FieldC gt value3
AND FieldD lt value4
OR FieldB = value2
AND FieldC gt value3
AND FieldD lt value4
OR FieldA = value5
AND FieldC gt value7
AND FieldD lt value8
OR FieldB = value6
AND FieldC gt value7
AND FieldD lt value8
Hope this makes some kind of sense....
Sean Gilbert
JDEdwards Consultant
PricewaterhouseCoopers
Montreal
Tel: 514.205.5000 x3619
Fax: 450.655.0163
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
Gentlemen,
Here's my two cents...
It seems that the 'OR' only works to seperate groupings of 'AND'
statements...
Zoltan is right in that OneWorld will require a much longer set of
statements...
Following is my OneWorld Data Selection interpretation of your request..
where (((fieldA = value1 or fieldB = value2) and
(fieldC > value3 and fieldD < value4)) or
((fieldA = value5 or fieldB = value6) and
(fieldC > value7 and fieldD < value8)))
OneWorld
Where FieldA = value1
AND FieldC gt value3
AND FieldD lt value4
OR FieldB = value2
AND FieldC gt value3
AND FieldD lt value4
OR FieldA = value5
AND FieldC gt value7
AND FieldD lt value8
OR FieldB = value6
AND FieldC gt value7
AND FieldD lt value8
Hope this makes some kind of sense....
Sean Gilbert
JDEdwards Consultant
PricewaterhouseCoopers
Montreal
Tel: 514.205.5000 x3619
Fax: 450.655.0163
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.