Interface SetWindowFields
Properties
$setWindowFields
$set
Window
Fields
: { partitionBy
?: any; sortBy
?: <internal>.Record<string, 1 | -1>; output
: <internal>.Record<string, <internal>.Expression.First & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Last & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.AddToSet & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Push & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Shift & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Avg & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Count & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.CovariancePop & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.CovarianceSamp & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.DenseRank & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.DocumentNumber & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.ExpMovingAvg & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Integral & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Max & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Min & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.StdDevPop & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.StdDevSamp & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Sum & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Derivative & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.LinearFill & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Locf & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Rank & { window
?: { documents
?: [string | number, string | number]; range
?: [string | number, string | number]; unit
?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } }> }Type declaration
Optional partitionBy?: any
Optional sortBy?: <internal>.Record<string, 1 | -1>
output: <internal>.Record<string, <internal>.Expression.First & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Last & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.AddToSet & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Push & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Shift & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Avg & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Count & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.CovariancePop & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.CovarianceSamp & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.DenseRank & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.DocumentNumber & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.ExpMovingAvg & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Integral & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Max & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Min & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.StdDevPop & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.StdDevSamp & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Sum & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Derivative & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.LinearFill & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Locf & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } } & <internal>.Expression.Rank & { window?: { documents?: [string | number, string | number]; range?: [string | number, string | number]; unit?: "millisecond" | "second" | "minute" | "hour" | "day" | "week" | "month" | "quarter" | "year" } }>
$setWindowFields
reference