filter_by_range
- filter_by_range(
table_name: string,
view_name: string | undefined,
column_name: string,
lower_bound: number,
upper_bound: number,
options?: Record<string, string>,
callback?: GPUdbCallback,
): Promise<FilterByRangeResponse>Parameters
- table_name: string
Name of the table on which the filter by range operation will be performed, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table.
- view_name: string | undefined
If provided, then this will be the name of the view containing the results, in [schema_name.]view_name format, using standard name resolution rules and meeting table naming criteria. Must not be an already existing table or view.
- column_name: string
Name of a column on which the operation would be applied.
- lower_bound: number
Value of the lower bound (inclusive).
- upper_bound: number
Value of the upper bound (inclusive).
Optionaloptions: Record<string, string>Optional parameters.
Optionalcallback: GPUdbCallbackOptional callback function
Returns Promise<FilterByRangeResponse>
Promise<Types.FilterByRangeResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:9590
- table_name: string
filter_by_range_request
- filter_by_range_request(
request: FilterByRangeRequest,
callback?: GPUdbCallback,
): Promise<FilterByRangeResponse>Calculates which objects from a table have a column that is within the given bounds. An object from the table identified by
table_nameis added to the viewview_nameif its column is within [lower_bound,upper_bound] (inclusive). The operation is synchronous. The response provides a count of the number of objects which passed the bound filter. Although this functionality can also be accomplished with the standard filter function, it is more efficient.For track objects, the count reflects how many points fall within the given bounds (which may not include all the track points of any given track).
Parameters
- request: FilterByRangeRequest
Request object containing the parameters for the operation
Optionalcallback: GPUdbCallbackOptional callback function
Returns Promise<FilterByRangeResponse>
Promise<Types.FilterByRangeResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:9549
- request: FilterByRangeRequest
Calculates which objects from a table have a column that is within the given bounds. An object from the table identified by
table_nameis added to the viewview_nameif its column is within [lower_bound,upper_bound] (inclusive). The operation is synchronous. The response provides a count of the number of objects which passed the bound filter. Although this functionality can also be accomplished with the standard filter function, it is more efficient.For track objects, the count reflects how many points fall within the given bounds (which may not include all the track points of any given track).