Skip to content

/AWS1/CL_HNC=>QUERYTABLEROWS()

About QueryTableRows

The QueryTableRows API allows you to use a filter formula to query for specific rows in a table.

Method Signature

IMPORTING

Required arguments:

IV_WORKBOOKID TYPE /AWS1/HNCRESOURCEID /AWS1/HNCRESOURCEID

The ID of the workbook whose table rows are being queried.

If a workbook with the specified id could not be found, this API throws ResourceNotFoundException.

IV_TABLEID TYPE /AWS1/HNCRESOURCEID /AWS1/HNCRESOURCEID

The ID of the table whose rows are being queried.

If a table with the specified id could not be found, this API throws ResourceNotFoundException.

IO_FILTERFORMULA TYPE REF TO /AWS1/CL_HNCFILTER /AWS1/CL_HNCFILTER

An object that represents a filter formula along with the id of the context row under which the filter function needs to evaluate.

Optional arguments:

IV_MAXRESULTS TYPE /AWS1/HNCMAXRESULTS /AWS1/HNCMAXRESULTS

The maximum number of rows to return in each page of the results.

IV_NEXTTOKEN TYPE /AWS1/HNCPAGINATIONTOKEN /AWS1/HNCPAGINATIONTOKEN

This parameter is optional. If a nextToken is not specified, the API returns the first page of data.

Pagination tokens expire after 1 hour. If you use a token that was returned more than an hour back, the API will throw ValidationException.

RETURNING

OO_OUTPUT TYPE REF TO /AWS1/CL_HNCQUERYTABLEROWSRSLT /AWS1/CL_HNCQUERYTABLEROWSRSLT