Child pages
  • Min (Minimum)

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

MIN (Minimum)

Syntax

The MIN function can be used on any fields supporting aggregation which have a numeric type:

  • TimeSpan
  • DateTime
  • Integer (Int32/Int64)
  • Double
  • Float
  • Decimal

It will return the minimum value across all the values in the query (or the set of values being evaluated for the current Facet or Group).

The MIN function, like the AVG, MAX and SUM functions, takes a single argument, which is the name of the field it should calculate over.

Examples

This would return the date/time when the first entity of type script was created.

Code Block
languagenone
Min(CreatedAt) WHERE EntityType = Script