com.gpudb.protocol

Class GetRecordsByColumnRequest.Options

java.lang.Object

com.gpudb.protocol.GetRecordsByColumnRequest.Options

Enclosing class:

GetRecordsByColumnRequest

public static final class GetRecordsByColumnRequest.Options
extends Object

• EXPRESSION: Optional filter expression to apply to the table.
• SORT_BY: Optional column that the data should be sorted by. Empty by default (i.e. no sorting is applied).
• SORT_ORDER: String indicating how the returned values should be sorted - ascending or descending. Default is 'ascending'. If sort_order is provided, sort_by has to be provided. Supported values:
  • ASCENDING
  • DESCENDING
  The default value is ASCENDING.
• ORDER_BY: Comma-separated list of the columns to be sorted by; e.g. 'timestamp asc, x desc'. The columns specified must be present in columnNames. If any alias is given for any column name, the alias must be used, rather than the original column name.

A set of string constants for the parameter options.

Field Summary

Fields

Modifier and Type	Field and Description
static String	ASCENDING
static String	DESCENDING
static String	EXPRESSION Optional filter expression to apply to the table.
static String	ORDER_BY Comma-separated list of the columns to be sorted by; e.g.
static String	SORT_BY Optional column that the data should be sorted by.
static String	SORT_ORDER String indicating how the returned values should be sorted - ascending or descending.

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

EXPRESSION

public static final String EXPRESSION

Optional filter expression to apply to the table.

See Also:

Constant Field Values

SORT_BY

public static final String SORT_BY

Optional column that the data should be sorted by. Empty by default (i.e. no sorting is applied).

See Also:

Constant Field Values

SORT_ORDER

public static final String SORT_ORDER

String indicating how the returned values should be sorted - ascending or descending. Default is 'ascending'. If sort_order is provided, sort_by has to be provided. Supported values:

• ASCENDING
• DESCENDING

The default value is ASCENDING.

See Also:

Constant Field Values

ASCENDING

public static final String ASCENDING

See Also:

Constant Field Values

DESCENDING

public static final String DESCENDING

See Also:

Constant Field Values

ORDER_BY

public static final String ORDER_BY

Comma-separated list of the columns to be sorted by; e.g. 'timestamp asc, x desc'. The columns specified must be present in columnNames. If any alias is given for any column name, the alias must be used, rather than the original column name.

See Also:

Constant Field Values