> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# filter_by_range

### filter\_by\_range

<ul>
  <li>
    filter\_by\_range(\
    &#x20;table\_name: string,\
    &#x20;view\_name: string | undefined,\
    &#x20;column\_name: string,\
    &#x20;lower\_bound: number,\
    &#x20;upper\_bound: number,\
    &#x20;options?: Record\<string, string>,\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/javascript/types/GPUdbCallback.md),\
    ): Promise\<[FilterByRangeResponse](https://docs.kinetica.com/content/api/javascript/interfaces/FilterByRangeResponse.md)>

    Calculates which objects from a table have a column that is within the given bounds. An object from the table identified by `table_name` is added to the view `view_name` if 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

    <ul>
      <li>
        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.
      </li>

      <li>
        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.
      </li>

      <li>
        column\_name: string

        Name of a column on which the operation would be applied.
      </li>

      <li>
        lower\_bound: number

        Value of the lower bound (inclusive).
      </li>

      <li>
        upper\_bound: number

        Value of the upper bound (inclusive).
      </li>

      <li>
        `Optional`options: Record\<string, string>

        Optional parameters.
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/javascript/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[FilterByRangeResponse](https://docs.kinetica.com/content/api/javascript/interfaces/FilterByRangeResponse.md)>

    Promise\<Types.FilterByRangeResponse> - Promise resolving to the response

    <ul>
      <li>Defined in [src/GPUdb.ts:9846](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/GPUdb.ts#L9846)</li>
    </ul>
  </li>
</ul>

### filter\_by\_range\_request

<ul>
  <li>
    filter\_by\_range\_request(\
    &#x20;request: [FilterByRangeRequest](https://docs.kinetica.com/content/api/javascript/interfaces/FilterByRangeRequest.md),\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/javascript/types/GPUdbCallback.md),\
    ): Promise\<[FilterByRangeResponse](https://docs.kinetica.com/content/api/javascript/interfaces/FilterByRangeResponse.md)>

    Calculates which objects from a table have a column that is within the given bounds. An object from the table identified by `table_name` is added to the view `view_name` if 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

    <ul>
      <li>
        request: [FilterByRangeRequest](https://docs.kinetica.com/content/api/javascript/interfaces/FilterByRangeRequest.md)

        Request object containing the parameters for the operation
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/javascript/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[FilterByRangeResponse](https://docs.kinetica.com/content/api/javascript/interfaces/FilterByRangeResponse.md)>

    Promise\<Types.FilterByRangeResponse> - Promise resolving to the response

    <ul>
      <li>Defined in [src/GPUdb.ts:9805](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/GPUdb.ts#L9805)</li>
    </ul>
  </li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.