Interface: FetchByOffsetParameters

Oracle® JavaScript Extension Toolkit (JET)


  • 4.1.0
  • ojdataprovider




Defines the parameters to the DataProvider method DataProvider#fetchByOffset



interface FetchByOffsetParameters<D> extends FetchListParameters<D>

Generic Parameters
DType of Data
Typescript Import Format
//To use this interface, import as below.
import {FetchByOffsetParameters} from "ojs/ojdataprovider";

For additional information visit:


(nullable) attributes :Array.<(string|FetchAttribute)>

attributes to include in the result. If specified, then at least these set of attributes will be included in each row results. If not specified then the default attributes will be included.
  • 6.1.0

(nullable) clientId :symbol

Optional symbol that can uniquely identify the consumer of the DataProvider. Each consumer can call Symbol() to obtain a unique symbol, which can be stored and reused on each subsequent call to fetchFirst. Note that Symbol() returns a different unique symbol every time, so it should not be called every time the consumer calls fetchFirst. There should only be one active iterator per clientId. All previous iterators obtained with the same clientId should be considered invalid. This is used to optimize resource usage in some DataProvider implementations.
  • 9.0.0
Inherited From:

(nullable) filterCriterion :DataFilter.Filter.<D>

Optional filter criterion to apply. The filter criterion would be composed of a supported DataFilter.Filter such as a AttributeFilter, AttributeExprFilter, ExtendedCompoundFilter, NestedFilter, TextFilter.
  • 4.1.0
Inherited From:
let filterDef = {op: '$or', criteria: [{op: '$eq', value: {name: 'Bob'}}, {op: '$gt', value: {level: 'Low'}}]};
let filter = FilterFactory.getFilter({filterDef}); // create a standard filter using the filterFactory.
let fetchListParam = {filterCriterion: filter, size: 5};

(nullable) includeFilteredRowCount :('enabled'|'disabled')

Optional property to request that the total filtered row count be included in the fetch result. The total filtered row count is a count of all the rows that can be iterated after applying any filterCriterion.

Valid values are:

  • "enabled": Total row count should be included in the fetch result.
  • "disabled": Total row count should not be included in the fetch result.

The default is 'disabled'.

Not all DataProvider implementations support returning total filtered row count. Consumers should check if the value is a valid number before trying to use it.

  • 12.0.0
Inherited From:

Request and use totalFilteredRowCount

const fetchListParams = {includeFilteredRowCount: 'enabled'};
const asyncIterator = dataprovider.fetchFirst(fetchListParams)[Symbol.asyncIterator]();
let iteratorResult = await;
let fetchListResult = iteratorResult.value;
let totalFilteredRowCount = fetchListResult.totalFilteredRowCount;
if (typeof totalFilteredRowCount === 'number' && totalFilteredRowCount !== -1) {
  // Do something with totalFilteredRowCount if available

offset :number

The offset used for the fetch call.
  • 4.1.0

(nullable) signal :AbortSignal

The AbortSignal from AbortController. A signal associated with fetchByOffset so that this request can be aborted later.
  • 14.0.0

(nullable) size :number

Optional number of rows to fetch. If fewer than that number of rows exist, the fetch will succeed but be truncated. A value of -1 will return all rows or the maximum size supported by the DataProvider. If the size is not specified or is 0, then the DataProvider implementation will determine how many rows to return.
  • 4.1.0
Inherited From:

(nullable) sortCriteria :Array.<SortCriterion.<D>>

Optional sort criteria to apply.
  • 4.1.0
Inherited From:
[{attribute: 'DepartmentName', direction: 'ascending'}]