Class Window
- Inheritance
-
Window
- Implements
-
- Inherited Members
-
Specifies window measure behavior for windowed, cumulative, or
semiadditive aggregations.
public record Window : IEquatable<Window>
- Extension Methods
-
Constructors
[SetsRequiredMembers]
protected Window(Window original)
Parameters
| Type |
Name |
Description |
| Window |
original |
|
Properties
protected virtual Type EqualityContract { get; }
Property Value
Optional offset that shifts the window frame backward or forward
along the Order field by a fixed interval. Treated
as an opaque string: we round-trip the source form verbatim and
do not validate.
Per the v1.1 spec the form is <n> <period>
where n is a signed integer (negative looks backward,
positive looks forward) and period is one of day,
days, month, months, year, or
years. Examples: -12 month, 1 year,
-3 days, 7 day.
Spec constraints we do not enforce: Order must be
a date or timestamp column; offset has no effect when
Range is all; a shifted frame outside the
available data evaluates to NULL at query time.
public string? Offset { get; set; }
Property Value
The field name that determines the ordering of the window.
public required string Order { get; set; }
Property Value
Defines the extent of the window.
Values: "current", "cumulative", "trailing N unit", "leading N unit", "all"
public required string Range { get; set; }
Property Value
Specifies how to summarize the measure when the order field is not
included in the query's GROUP BY.
public required Window.SemiadditiveType Semiadditive { get; set; }
Property Value
Methods
public override bool Equals(object? obj)
Parameters
| Type |
Name |
Description |
| object |
obj |
|
Returns
public virtual bool Equals(Window? other)
Parameters
| Type |
Name |
Description |
| Window |
other |
|
Returns
public override int GetHashCode()
Returns
PrintMembers(StringBuilder)
protected virtual bool PrintMembers(StringBuilder builder)
Parameters
Returns
public override string ToString()
Returns
Operators
public static bool operator ==(Window? left, Window? right)
Parameters
Returns
public static bool operator !=(Window? left, Window? right)
Parameters
Returns