Class DataBlockQueryRequest

Namespace

Datafication.Server.Core.Models

Assembly

Datafication.Server.Core.dll

Main request model for comprehensive DataBlock query operations. Supports filtering, sorting, aggregation, grouping, window functions, merging, and more.

public class DataBlockQueryRequest

Inheritance

object

DataBlockQueryRequest

Properties

Aggregate

Gets or sets the simple aggregation request (returns single row).

public QueryAggregationRequest? Aggregate { get; set; }

Property Value

QueryAggregationRequest

Compute

Gets or sets the list of computed column requests. Each creates a new column based on an expression.

public List<QueryComputeRequest>? Compute { get; set; }

Property Value

List<QueryComputeRequest>

DropDuplicates

Gets or sets the drop duplicates request.

public QueryDropDuplicatesRequest? DropDuplicates { get; set; }

Property Value

QueryDropDuplicatesRequest

DropNulls

Gets or sets the drop nulls request.

public QueryDropNullsRequest? DropNulls { get; set; }

Property Value

QueryDropNullsRequest

FillNulls

Gets or sets the fill nulls request.

public QueryFillNullsRequest? FillNulls { get; set; }

Property Value

QueryFillNullsRequest

Format

Gets or sets the output format (json, csv, html, or custom sink). Default is "json".

public string Format { get; set; }

Property Value

string

GroupBy

Gets or sets the GroupBy with aggregations request.

public QueryGroupByRequest? GroupBy { get; set; }

Property Value

QueryGroupByRequest

Melt

Gets or sets the melt (unpivot) request.

public QueryMeltRequest? Melt { get; set; }

Property Value

QueryMeltRequest

Merge

Gets or sets the merge request for joining with another DataBlock.

public QueryMergeRequest? Merge { get; set; }

Property Value

QueryMergeRequest

Pivot

Gets or sets the pivot request.

public QueryPivotRequest? Pivot { get; set; }

Property Value

QueryPivotRequest

Sample

Gets or sets the number of random rows to sample. If specified, Skip and Take are ignored.

public int? Sample { get; set; }

Property Value

int?

SampleSeed

Gets or sets the random seed for reproducible sampling.

public int? SampleSeed { get; set; }

Property Value

int?

Select

Gets or sets the column names to include in the result. If null or empty, all columns are returned.

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

Property Value

string[]

Skip

Gets or sets the number of rows to skip (for pagination).

public int? Skip { get; set; }

Property Value

int?

Sort

Gets or sets the sort condition.

public QuerySortCondition? Sort { get; set; }

Property Value

QuerySortCondition

Take

Gets or sets the maximum number of rows to return.

public int? Take { get; set; }

Property Value

int?

Transpose

Gets or sets the transpose request.

public QueryTransposeRequest? Transpose { get; set; }

Property Value

QueryTransposeRequest

Where

Gets or sets the list of filter conditions to apply. Multiple filters are combined with AND logic.

public List<QueryFilterCondition>? Where { get; set; }

Property Value

List<QueryFilterCondition>

WhereIn

Gets or sets the WhereIn condition for filtering by a collection of values.

public QueryWhereInCondition? WhereIn { get; set; }

Property Value

QueryWhereInCondition

WhereNot

Gets or sets the WhereNot condition for excluding a specific value.

public QueryWhereNotCondition? WhereNot { get; set; }

Property Value

QueryWhereNotCondition

Window

Gets or sets the list of window function requests. Each creates a new column with the window function result.

public List<QueryWindowRequest>? Window { get; set; }

Property Value

List<QueryWindowRequest>