Versions Compared

Old Version 5

changes.mady.by.user João Brilhante

Saved on

compared with

New Version 6

changes.mady.by.user João Brilhante

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Syntax

Output

Description

Examples

number + number

number

Adds two numbers.

  • @PropertyA @Cost + @PropertyBext@Taxes

  • @PropertyA @Width + 2.5

number - number

number

Subtracts a number from another.

  • @PropertyA ext@Budget - @PropertyBext@Spent

  • 150 - @PropertyA@Height

number * number

number

Multiplies two numbers.

  • @PropertyA ext@Estimate * @PropertyB@Cost

  • -1.2 * @PropertyA@Cost

number / number

number

Divides a number by another.

  • @PropertyA @Width / @PropertyB@Height

  • @PropertyA @Cost / 0.8 75

number % number

number

Computes the remainder of the division between two numbers.

  • @PropertyA @Length % @PropertyBext@Section@PropertyA % 0.8

  • ext@Man\ days % 10

Aggregation expressions

Syntax

Output

Description

Examples

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(@PropertyA@Cost, from@Refines)

  • SUM(@PropertyA + @PropertyBext@Estimate * @Cost, from@Refines)

  • SUM(1.2 * @PropertyA@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, from@Refines)

  • AVG(@PropertyA, from@Refines->from@Uses)

  • AVG(1.5 + @PropertyA, from@Refines)

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

number

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

  • MAX(@PropertyA, from@Refines)

  • MAX(2.5 * @PropertyA, from@Refines)

  • MAX(@PropertyA, 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, from@Refines)

  • MIN(@PropertyA - 15, from@Refines)

  • MIN(@PropertyA, from@Refines->from@Uses)

...

Syntax

Output

Description

Examples

NOT boolean

boolean

Applies a logical NOT to a boolean expression.

  • NOT @PropertyAext@Delivered

  • NOT (@PropertyA @Approved AND @PropertyBext@Delivered)

boolean AND boolean

boolean

Applies a logical AND between two boolean expressions.

  • @PropertyA @Tested AND true

  • false AND true

boolean OR boolean

boolean

Applies a logical OR between two boolean expressions.

  • @PropertyA ext@Approved OR true

  • false OR true

  • expression = expression

  • expression == expression

boolean

Indicates whether two expressions are equal.

  • @PropertyA @Priority = 12@PropertyA + 3 == 121

  • ext@Estimate * 1.2 == 20

  • @Author = ‘John Doe’

  • expression != expression

  • expression <> expression

boolean

Indicates whether two expressions are different.

  • @PropertyA @Priority != 5@PropertyA + 2 != 5

  • @Width * 2 <> 120

number > number

boolean

Indicates whether a numeric expression is greater than another.

  • @PropertyA > 0ext@Cost > 500

  • @Cost + ext@Taxes > 1000

number >= number

boolean

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

@PropertyA

  • @Cost >= 0

  • ext@Estimate - 10 >= 0

number < number

boolean

Indicates whether a numeric expression is less than another.

  • @PropertyA < 0

number <= number

boolean

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

  • @PropertyA <= 0

  • string like ~ string

  • string LIKE string

  • string ~ ILIKE string

boolean

Indicates whether a string expression matches a string pattern.

  • @PropertyA LIKE ‘BR-%’

  • @PropertyA ~ ‘BR-%’@Author ~ ‘John%’

expression IS NULL

boolean

Indicates whether an expression is null.

  • @PropertyA @Cost IS NULL

expression IS NOT NULL

boolean

Indicates whether an expression is not null.

  • @Cost IS NOT NULL

  • @PropertyA ext@Delivered IS NOT NULL