Child pages
  • Max (Maximum)
Skip to end of metadata
Go to start of metadata

MAX (Maximum)


The MAX 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 maximum value across all the values in the query (or the set of values being evaluated for the current Facet or Group).

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


This would return the date/time of the most recent update to a script across all projects.

Max(LastUpdatedAt) WHERE EntityType = Script
  • No labels