Operator

description

Example

==

Tests for equality in value between two operands.

[DEMOG.1][RACE] == 6

<=

Less than or equal to

[DEMOG.1][AGE] <= 65

< 

Less than

[DEMOG.1][AGE] < 18

>=

Greater than or equal to

[VITALS.1][DBP] >= 50

> 

Greater than

[VITALS.1][SBP] > 90

!=

Not equal to

[DEMOG.1][SEX] != ‘M’

  Operator

  description

Example

  MAX

Retrieves maximum value of all items in the group

[New Site][New Subject][ADVERSE EVENTS][AE][AE1][AESPID].MAX will return the maximum ID in all AE forms for a given patient.

  MIN

Retrieves minimum value of all items in the group

[New Site][New Subject][ADVERSE EVENTS][AE][AE1][AESPID].MIN will return the minimum ID in all AE forms for a given patient

Operator

description

Example

&& (AND)

Logical AND

[VITALS.1.][DBP] >= 50 && [VITALS.1][DBP] <= 10

|| (OR)

Logical OR

[AW.1][AEENDT]== ‘’ || [AE.1][AEENDT]<[AE.1][AESTDT]

! (NOT)

Logical NOT

[DEMOG.1][SEX] != ‘M’

Operator

description

Example

+

Adds numeric operands or concatenates two or more strings.

i_Date = String(year) + String(month) + String(day)

-

Subtracts numeric operands

intAge = dtDate.getFullYear() – dtDOB.getFullYear();

*

Multiplies numeric operands

(1000*60*60*24));

/

Divides numeric operands

Var daysDiff = Math.round((dt2.getTime() – dt1.getTime())/(1000*60*60*24));

Math.

Provides basic math functionality and constants

Math.round(number)