Table of Contents

Class QueryWindowRequest

Namespace
Datafication.Server.Core.Models
Assembly
Datafication.Server.Core.dll

Represents a window function request.

public class QueryWindowRequest
Inheritance
object
QueryWindowRequest

Properties

Column

Gets or sets the source column name for the window function.

public string Column { get; set; }

Property Value

string

DefaultValue

Gets or sets the default value for lag/lead when no value exists.

public object? DefaultValue { get; set; }

Property Value

object

Function

Gets or sets the window function type. Supported values:

  • Moving: movingavg, movingsum, movingmin, movingmax, movingstddev, movingvariance, movingcount, movingmedian, movingpercentile, exponentialmovingavg
  • Cumulative: cumsum, cumavg, cummin, cummax
  • Lag/Lead: lag, lead
  • Ranking: rownumber, rank, denserank
  • Value: firstvalue, lastvalue, nthvalue
public string Function { get; set; }

Property Value

string

NthValue

Gets or sets the N value for nthvalue function.

public int? NthValue { get; set; }

Property Value

int?

Offset

Gets or sets the offset for lag/lead functions.

public int? Offset { get; set; }

Property Value

int?

OrderByColumn

Gets or sets the column to order by within the window.

public string? OrderByColumn { get; set; }

Property Value

string

PartitionByColumns

Gets or sets the columns to partition by.

public string[]? PartitionByColumns { get; set; }

Property Value

string[]

Percentile

Gets or sets the percentile value (0-100) for movingpercentile.

public double? Percentile { get; set; }

Property Value

double?

ResultColumn

Gets or sets the name for the result column. If null, a default name is generated.

public string? ResultColumn { get; set; }

Property Value

string

WindowSize

Gets or sets the window size for moving functions.

public int? WindowSize { get; set; }

Property Value

int?