Versions Compared

Old Version 14

changes.mady.by.user Menno Gülpers

Saved on

compared with

New Version 15

changes.mady.by.user Menno Gülpers

Saved on

Key

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

...

Panel
bgColorwhite

AND

This function returns TRUE if all its arguments evaluate to TRUE; it returns FALSE if one or more arguments evaluate to FALSE.

Syntax

Code Block
argument1 AND argument2 [AND ...]
  • argument1 - The first boolean condition that you want to evaluate.
  • argument2 - The first boolean condition that you want to evaluate.
  • [AND …] - Additional boolean conditions that you want to evaluate.

Return type

  • boolean

Examples

  • TRUE AND TRUE results in TRUE
  • TRUE AND FALSE results in FALSE
  • TRUE AND ? (= UNKNOWN) results in UNKNOWN

Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

OR

This function returns TRUE if at least one of its arguments evaluates to TRUE; it returns FALSE if none of the arguments evaluate to TRUE.

Syntax

Code Block
argument1 OR argument2 [OR ...]

argument1 - The first boolean condition that you want to evaluate. argument2 - The first boolean condition that you want to evaluate. [OR …] - Additional boolean conditions that you want to evaluate.

Return type

  • boolean

Examples

  • TRUE OR TRUE results in TRUE
  • TRUE OR FALSE results in TRUE
  • TRUE OR ? (= UNKNOWN) results in TRUE
  • FALSE OR ? (= UNKNOWN) results in UNKNOWN

Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

TRUE

This is the boolean value TRUE.

Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

FALSE

This is the boolean value FALSE.

Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

NOT

This operator reverses the value of its boolean argument.

Syntax

Code Block
NOT argument
  • argument - The boolean condition of which you want to reverse its value.

Return type

  • boolean

Examples

  • NOT (TRUE) results in FALSE
  • NOT (TRUE AND FALSE) results in TRUE
  • NOT (? (= UNKNOWN)) results in UNKNOWN
  • NOT (NOT (TRUE)) results in TRUE

Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

UNKNOWN

You can use the '?' (question mark), representing UNKNOWN, to check if an expression or an attribute has a value.

Example

Suppose a model with an entity Person and attributes Person.name and Person.age. In runtime, a user fills out a form and enters his name, but forgets to fill out his age.

As a result

  • Person.name = ? returns FALSE since this attribute is filled out
  • Person.age = ? returns TRUE since this attribute is not filled out and therefore is UNKNOWN

Include Page
_nav_BackToTop
_nav_BackToTop