Versions Compared

Old Version 8

changes.mady.by.user Unknown User (a.jansen)

Saved on

compared with

New Version 9

changes.mady.by.user Tijmen Daatselaar

Saved on

Key

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

Panel
bgColorwhite

COUNT


Retrieves the number of instances for the specified entities or attributes. Please note the similar function SIZE.


Syntax

Code Block
COUNT ( collection )


Input

  • 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”

ExpressionResultType
COUNT ( ALL Person )4Integer
COUNT ( House.rooms )3Integer
COUNT ( ALL Person + ALL House )5Integer
COUNT ( COLLECT Person FROM ALL Person WHERE ( Person.name = “Lisa” ) )1Integer
COUNT ( ? (= UNKNOWN) )UNKNOWNInteger
UI Text Box
type
Info

SIZE and COUNT are similar except for ?:

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

Back to top