Expressions

You can specify an expression in the Criteria field of the Filtering tab and in the Expression field of the New Virtual Field dialog box. This expression works similar to that in Java, but is simplified.

Examples of Boolean expressions used in the Criteria field:

ADTH = 1
SUTY <> 5
STCO = 'LANC'
BODE = 1 AND BDMT = 4
STCO = 'PYCD' and STKY <> '' and SUBSTRING (PARM, 1, 2)
E065 = 'BOD' AND OLD (STAI) < '60' AND STAI = '60'
INOU == 2 AND PGRS == 90 AND (RORC == 4 OR RORC == 5)

Examples of string expressions used in the Expression field:

'Sync'
'NOLOOKUP'
'60s'
'SupplierPartyMaster_' + CONO + '_' + SUNO