|
(both conditions - right and left of .AND. - must be fulfilled) | |
|
(one of the two conditions - to the right or left of .OR. - must be fulfilled) | |
The following examples show key values:
(ERP_PDM_NUMBER.NE.'')
The expression is true if the relevant field in the ERP_PDM_NUMBER column is not empty.
((ERP_PDM_NUMBER.NE.'').AND.(ACTIVE_STATE.EQ.1))
The expression is true if the relevant field in the ERP_PDM_NUMBER column is not empty AND the relevant field in the ACTIVE_STATE column has the value 1 ( =released [Released] ).
(PRICE.LT.0.4)
The expression is true if the relevant field in the PRICE column has a value less than or equal to 0.4.
(REQUESTED_STATE.EQ.2)
The expression is true if the relevant field in the REQUESTED_STATE column has the value 2 ( =expired [Expired] ).
((ACTIVE_STATE.EQ.1).AND.(LOCATION1.NE.''))
The expression is true if the relevant field in the ACTIVE_STATE column has the value 1 ( =released [Released] ) AND the relevant field in the LOCATION1 column is not empty.
(CONTAINS(ERP_PDM_NUMBER,'AA').EQ..TRUE.)
The expression is true if the relevant field in the ERP_PDM_NUMBER column contains the substring 'AA'.
(CONTAINS(ERP_PDM_NUMBER,'AA').EQ..FALSE.)
The expression is true if the relevant field in the ERP_PDM_NUMBER column does NOT contain the substring 'AA'.