Versions Compared

Old Version 13

changes.mady.by.user Menno Gülpers

Saved on

compared with

New Version 14

changes.mady.by.user Unknown User (j.lomas)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Styling, examples, COUNT anchor

...

Panel
bgColorwhite

AVERAGE

Use this function to determine the average (arithmetic mean) of a list or collection.

The AVG function has two syntax forms: the collection form and the list form. You can use the collection form to determine the average value of all occurrences of an attribute. The list form is used to determine the average value of a set of different attributes.

Collection form syntax

Code Block
AVG ( attribute )
  • attribute - An attribute of any type of number or date of which multiple instances can occur at runtime.

List form syntax

Code Block
AVG ( [ value1 , value2 , ... ] )
  • [ value1 , value2 , … ] - A list of attributes, expressions or fixed values of any type of number or date. Use the square brackets to indicate that the arguments form a list of values.

Return types

  • number
  • integer
  • currency
  • percentage
  • date

The function returns UNKNOWN if one or more values are UNKNOWN.

Examples

Suppose the following domain model.

 

Entity.attributeValueMultivalued relationEntity.attributeValues

Residence.

appraisalValue 

appraisalValue

Residence.

askingPrice 

askingPrice

Residence.mortgage

€ 140000

€ 150000

€ 142000

hasBiddingsBidding.amount

 

If you want to determine the average bidding on the current residence:

  • AVG(Residence.hasBiddings.amount)
If you want to

€ 132000

€ 139000

€ 137500

GoalExpressionResultType
To determine the average amount
of
within the appraisal value, the asking price and the mortgage
of the current residence:
AVG ( [ Residence.appraisalValue , Residence.askingPrice , Residence.mortgage ] )€ 144000Currency
To determine the average bidding on the current residenceAVG ( Residence.hasBiddings.amount )€ 136166.67Currency

 

Include Page
_nav_BackToTop
_nav_BackToTop

...

Panel
bgColorwhite

MIN

Use this function to determine the minimum value of a list or collection.

The MIN function has two syntax forms: the collection form and the list form. You can use the collection form to determine the minimum value of all occurrences of an attribute. The list form is used to determine the minimum value of a set of different attributes.

Collection form syntax

Code Block
MIN ( attribute )
  • attribute - An attribute of any type of number or date of which multiple instances can occur at runtime.

List form syntax

Code Block
MIN ( [ value1 , value2 , ... ] )
  • [ value 1value1 , value 2value2 , … ] - A list of attributes, expressions or fixed values of any type of number or date. Use the square brackets to indicate that the arguments form a list of values.

Examples

Suppose the following domain model.

 

Entity.attributeValueMultivalued relationEntity.attributeValues

Residence.

appraisalValue 

appraisalValue

Residence.

askingPrice 

askingPrice

Residence.mortgage

€ 140000

€ 150000

€ 142000

hasBiddingsBidding.amount

 

If you want to determine the lowest bidding on the current residence:

  • MIN(Residence.hasBiddings.amount)
If you want to

€ 132000

€ 139000

€ 137500

GoalExpressionResultType
To determine the smallest amount within the appraisal value, the asking price and the mortgage
:
MIN ( [ Residence.appraisalValue , Residence.askingPrice , Residence.mortgage ] )€ 140000Currency
To determine the lowest bidding on the current residenceMIN ( Residence.hasBiddings.amount )€ 132000Currency

 

Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

MAX

Use this function to determine the maximum value of a list or collection.

The MAX function has two syntax forms: the collection form and the list form. You can use the collection form to determine the maximum value of all occurrences of an attribute. The list form is used to determine the maximum value of a set of different attributes.

Collection form syntax

Code Block
MAX ( attribute )
  • attribute - An attribute of any type of number or date of which multiple instances can occur at runtime.

List form syntax

Code Block
MAX ( [ value1 , value2 , ... ] )
  • [ value 1value1 , value 2value2 , … ] - A list of attributes, expressions or fixed values of any type of number or date. Use the square brackets to indicate that the arguments form a list of values.

Examples

Suppose the following domain model.

 

Entity.attributeValueMultivalued relationEntity.attributeValues

Residence.

appraisalValue 

appraisalValue

Residence.

askingPrice 

askingPrice

Residence.mortgage

€ 140000

€ 150000

€ 142000

hasBiddingsBidding.amount

 

If you want to determine the highest bidding on the current residence:

  • MAX(Residence.hasBiddings.amount)
If you want to determine the highest

€ 132000

€ 139000

€ 137500

GoalExpressionResultType
To determine the largest amount within the appraisal value, the asking price and the mortgage
:
MAX ( [ Residence.appraisalValue , Residence.askingPrice , Residence.mortgage ] )€ 150000Currency
To determine the highest bidding on the current residenceMAX ( Residence.hasBiddings.amount )€ 139000Currency

 

Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

Anchor
COUNT
COUNT
COUNT

Use this function to retrieve the number of instances for the specified entities or attributes. Please note the similar function SIZE.

Syntax

Code Block
COUNT ( collection )
  • collection - A collection of attribute or entity instances.

Return type

  • integer

Examples

Suppose the following data model.

 

InstancePerson.name
1“John”
2“Dave”
3“Jane”
4“Lisa”
 

 

InstanceHouse.rooms
singleton“living room”,  “bathroom”,  “bedroom”
ExpressionResult
 
Type
COUNT ( ALL Person )
results in
4Integer
COUNT ( House.rooms )
results in
3Integer
COUNT ( ALL Person + ALL House )
results in
5Integer
COUNT ( COLLECT Person FROM ALL Person WHERE ( Person.name = “Lisa” ) )
results in
1Integer
COUNT ( ? (= UNKNOWN) )
results in
UNKNOWNInteger

 

UI Text Box
typenote

SIZE and COUNT are similar except for ?:

SIZE( ? ) results in 0, while COUNT( ? ) results in ?

Include Page
_nav_BackToTop
_nav_BackToTop