Class IQueryTable_FluentExtensions

Inheritance

System.Object

IQueryTable_FluentExtensions

Namespace: Deephaven.OpenAPI.Client

Assembly: DeephavenOpenAPI.dll

Syntax

public static class IQueryTable_FluentExtensions : object

Methods

AbsSumBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable AbsSumBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

AsOfJoin(IQueryTable, IQueryTable, IMatchWithColumn[], ISelectColumn[])

Declaration

public static IQueryTable AsOfJoin(this IQueryTable self, IQueryTable rhs, IMatchWithColumn[] columnsToMatch, ISelectColumn[] columnsToAdd)

Parameters

Type	Name	Description
IQueryTable	self
IQueryTable	rhs
IMatchWithColumn[]	columnsToMatch
ISelectColumn[]	columnsToAdd

Returns

Type	Description
IQueryTable

AvgBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable AvgBy(this IQueryTable self, params ISelectColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	columns

Returns

Type	Description
IQueryTable

By(IQueryTable, AggregateCombo, ISelectColumn[])

Declaration

public static IQueryTable By(this IQueryTable self, AggregateCombo comboAggregate, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
AggregateCombo	comboAggregate
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

By(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable By(this IQueryTable self, params ISelectColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	columns

Returns

Type	Description
IQueryTable

CountBy(IQueryTable, IColumn, ISelectColumn[])

Declaration

public static IQueryTable CountBy(this IQueryTable self, IColumn resultColumn, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
IColumn	resultColumn
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

DropColumns(IQueryTable, IColumn[])

Declaration

public static IQueryTable DropColumns(this IQueryTable self, params IColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
IColumn[]	columns

Returns

Type	Description
IQueryTable

ExactJoin(IQueryTable, IQueryTable, IMatchWithColumn[], ISelectColumn[])

Declaration

public static IQueryTable ExactJoin(this IQueryTable self, IQueryTable rhs, IMatchWithColumn[] columnsToMatch, ISelectColumn[] columnsToAdd)

Parameters

Type	Name	Description
IQueryTable	self
IQueryTable	rhs
IMatchWithColumn[]	columnsToMatch
ISelectColumn[]	columnsToAdd

Returns

Type	Description
IQueryTable

FirstBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable FirstBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

HeadBy(IQueryTable, Int32, ISelectColumn[])

Declaration

public static IQueryTable HeadBy(this IQueryTable self, int n, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
System.Int32	n
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

InnerJoin(IQueryTable, IQueryTable, IMatchWithColumn[], ISelectColumn[])

Declaration

public static IQueryTable InnerJoin(this IQueryTable self, IQueryTable rhs, IMatchWithColumn[] columnsToMatch, ISelectColumn[] columnsToAdd)

Parameters

Type	Name	Description
IQueryTable	self
IQueryTable	rhs
IMatchWithColumn[]	columnsToMatch
ISelectColumn[]	columnsToAdd

Returns

Type	Description
IQueryTable

LastBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable LastBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

LazyUpdate(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable LazyUpdate(this IQueryTable self, params ISelectColumn[] customColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	customColumns

Returns

Type	Description
IQueryTable

LeftJoin(IQueryTable, IQueryTable, IMatchWithColumn[], ISelectColumn[])

Declaration

public static IQueryTable LeftJoin(this IQueryTable self, IQueryTable rhs, IMatchWithColumn[] columnsToMatch, ISelectColumn[] columnsToAdd)

Parameters

Type	Name	Description
IQueryTable	self
IQueryTable	rhs
IMatchWithColumn[]	columnsToMatch
ISelectColumn[]	columnsToAdd

Returns

Type	Description
IQueryTable

MaxBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable MaxBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

MedianBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable MedianBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

MinBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable MinBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

NaturalJoin(IQueryTable, IQueryTable, IMatchWithColumn[], ISelectColumn[])

Declaration

public static IQueryTable NaturalJoin(this IQueryTable self, IQueryTable rhs, IMatchWithColumn[] columnsToMatch, ISelectColumn[] columnsToAdd)

Parameters

Type	Name	Description
IQueryTable	self
IQueryTable	rhs
IMatchWithColumn[]	columnsToMatch
ISelectColumn[]	columnsToAdd

Returns

Type	Description
IQueryTable

PercentileBy(IQueryTable, Double, ISelectColumn[])

Declaration

public static IQueryTable PercentileBy(this IQueryTable self, double percentile, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
System.Double	percentile
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

PercentileBy(IQueryTable, Double, Boolean, ISelectColumn[])

Declaration

public static IQueryTable PercentileBy(this IQueryTable self, double percentile, bool avgMedian, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
System.Double	percentile
System.Boolean	avgMedian
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

ReverseAsOfJoin(IQueryTable, IQueryTable, IMatchWithColumn[], ISelectColumn[])

Declaration

public static IQueryTable ReverseAsOfJoin(this IQueryTable self, IQueryTable rhs, IMatchWithColumn[] columnsToMatch, ISelectColumn[] columnsToAdd)

Parameters

Type	Name	Description
IQueryTable	self
IQueryTable	rhs
IMatchWithColumn[]	columnsToMatch
ISelectColumn[]	columnsToAdd

Returns

Type	Description
IQueryTable

Select(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable Select(this IQueryTable self, params ISelectColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	columns

Returns

Type	Description
IQueryTable

Sort(IQueryTable, IColumn[])

Declaration

public static IQueryTable Sort(this IQueryTable self, params IColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
IColumn[]	columns

Returns

Type	Description
IQueryTable

Sort(IQueryTable, SortDirection, Boolean, IColumn[])

Declaration

public static IQueryTable Sort(this IQueryTable self, SortDirection direction, bool abs, params IColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
SortDirection	direction
System.Boolean	abs
IColumn[]	columns

Returns

Type	Description
IQueryTable

SortAbs(IQueryTable, IColumn[])

Declaration

public static IQueryTable SortAbs(this IQueryTable self, params IColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
IColumn[]	columns

Returns

Type	Description
IQueryTable

SortDescending(IQueryTable, IColumn[])

Declaration

public static IQueryTable SortDescending(this IQueryTable self, params IColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
IColumn[]	columns

Returns

Type	Description
IQueryTable

SortDescendingAbs(IQueryTable, IColumn[])

Declaration

public static IQueryTable SortDescendingAbs(this IQueryTable self, params IColumn[] columns)

Parameters

Type	Name	Description
IQueryTable	self
IColumn[]	columns

Returns

Type	Description
IQueryTable

StdBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable StdBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

SumBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable SumBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

TailBy(IQueryTable, Int32, ISelectColumn[])

Declaration

public static IQueryTable TailBy(this IQueryTable self, int n, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
System.Int32	n
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

Ungroup(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable Ungroup(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

Ungroup(IQueryTable, Boolean, ISelectColumn[])

Declaration

public static IQueryTable Ungroup(this IQueryTable self, bool nullFill, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
System.Boolean	nullFill
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

Update(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable Update(this IQueryTable self, params ISelectColumn[] customColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	customColumns

Returns

Type	Description
IQueryTable

UpdateView(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable UpdateView(this IQueryTable self, params ISelectColumn[] customColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	customColumns

Returns

Type	Description
IQueryTable

VarBy(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable VarBy(this IQueryTable self, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

View(IQueryTable, ISelectColumn[])

Declaration

public static IQueryTable View(this IQueryTable self, params ISelectColumn[] customColumns)

Parameters

Type	Name	Description
IQueryTable	self
ISelectColumn[]	customColumns

Returns

Type	Description
IQueryTable

WAvgBy(IQueryTable, IColumn, ISelectColumn[])

Declaration

public static IQueryTable WAvgBy(this IQueryTable self, IColumn weightColumn, params ISelectColumn[] groupByColumns)

Parameters

Type	Name	Description
IQueryTable	self
IColumn	weightColumn
ISelectColumn[]	groupByColumns

Returns

Type	Description
IQueryTable

Where(IQueryTable, BooleanExpression)

Declaration

public static IQueryTable Where(this IQueryTable self, BooleanExpression condition)

Parameters

Type	Name	Description
IQueryTable	self
BooleanExpression	condition

Returns

Type	Description
IQueryTable