Salesforce

Operators (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Operators (Magic xpa 4.x)

In Magic xpa expressions, you can use the following mathematical, logical, and string operators:

Mathematical Operators

Example

Addition

A+B+C

Division

A/B

The result of integer division is rounded to the nearest whole number.

Exponentiation

A^B returns A to the power of B.

Modulus

A MOD B

17 MOD 10 returns 7

Returns the remainder of an integer division.

See also: The Online and Rich Client Samples projects (program NM03 and RNM03)

Multiplication

A*B

Subtraction

A-B-C

Unary Negation

-(3)

Changes the sign of a Numeric expression.

String Operators

Concatenation

'John'&'Smith' yields 'JohnSmith'

Use the & symbol to concatenate (string together) Alpha strings.

LIKE

Determines whether a given character string matches a specified pattern.

Logical Operators

* All expressions involving logical operators return a logical TRUE or FALSE.

AND

Returns TRUE only if both operands are TRUE.

NOT

NOT ('FALSE'LOG) returns TRUE

NOT (A) Logical returns TRUE

Reverses the logical value of its operand.

OR

Returns TRUE only if either operand is TRUE.

Different Than

A<>B

Not equal to.

Equal To

A=B

Greater Than

A>B

Greater Than or Equal To

A>=B

Less Than

A<B

Less Than or Equal To

A<=B

Reference
Attachment 
Attachment