Page Comparison

number + number

number

Adds two numbers.

• @Cost + ext@Taxes

• @Width + 2.5

number - number

number

Subtracts a number from another.

• ext@Budget - ext@Spent

• 150 - @Height

number * number

number

Multiplies two numbers.

• ext@Estimate * @Cost

• 1.2 * @Cost

number / number

number

Divides a number by another.

• @Width / @Height

• @Cost / 0.75

number % number

number

Computes the remainder of the division between two numbers.

• @Length % ext@Sectionext@Segment

• ext@Man\ days % 10

COUNT(requirements: requirement[])

number

Counts the requirements in a given list.

• COUNT(from@Refines)

• COUNT(to@Refines->from@Uses)

SUM(expression: number, requirements: requirement[])

number

Computes the sum of a numeric expression applied to a list of requirements.

• SUM(@Cost, from@Refines)

• SUM(ext@Estimate * @Cost, from@Refines)

• SUM(1.2 * @Cost, from@Refines->from@Uses)

AVG(expression: number, requirements: requirement[])

number

Computes the average of a numeric expression applied to a list of requirements.

• AVG(@PropertyA@Cost, from@Refines)

• AVG(@PropertyAext@Estimate, from@Refines->from@Uses)

• AVG(1.5 + @PropertyAext@Man\ days * 150, from@Refines)

MAX(expression: number, requirements: requirement[])

number

Computes the maximum value of a numeric expression applied to a list of requirements.

• MAX(@PropertyA@Cost, from@Refines)

• MAX(2.5 * @PropertyAext@Estimate, from@Refines)

• MAX(@PropertyAext@Weight, from@Refines->from@Uses)

MIN(expression: number, requirements: requirement[])

number

Computes the minimum value of a numeric expression applied to a list of requirements.

• MIN(@PropertyA@Cost, from@Refines)

• MIN(@PropertyA - 15ext@Budget + 200, from@Refines)

• MIN(@PropertyAext@Estimate, from@Refines->from@Uses)

NOT boolean

boolean

Applies a logical NOT to a boolean expression.

• NOT ext@Delivered

• NOT (@Approved AND ext@Delivered)

boolean AND boolean

boolean

Applies a logical AND between two boolean expressions.

• @Tested AND true

• false AND true

boolean OR boolean

boolean

Applies a logical OR between two boolean expressions.

• ext@Approved OR true

• false OR true

• expression = expression

• expression == expression

boolean

Indicates whether two expressions are equal.

• @Priority = 1

• ext@Estimate * 1.2 4 == 20

• @Author = ‘John Doe’

• expression != expression

• expression <> expression

boolean

Indicates whether two expressions are different.

• @Priority != 5

• @Width * 2 <> 120

number > number

boolean

Indicates whether a numeric expression is greater than another.

• ext@Cost @Cost > 500

• 1.2 * @Cost + ext@Taxes > 1000ext@Budget

number >= number

boolean

Indicates whether a numeric expression is greater or equal to another.

• @Cost >= 0100

• ext@Estimate - + 10 >= 025

number < number

boolean

Indicates whether a numeric expression is less than another.

• @Cost < 1000

• ext@Man\ days < 30

number <= number

boolean

Indicates whether a numeric expression is less or equal to another.

• @Width > 6.5

• @PropertyA ext@Estimate <= 0 20

• string ~ string

• string LIKE string

• string ILIKE string

boolean

Indicates whether a string expression matches a string pattern.

• @Author ~ ‘John%’

• @Tags LIKE ‘%Billing%’

expression IS NULL

boolean

Indicates whether an expression is null.

• @Cost IS NULL

expression IS NOT NULL

boolean

Indicates whether an expression is not null.

• @Cost IS NOT NULL

• ext@Delivered ext@Estimate IS NOT NULL