DataSetRowRange (PQL)

Returns a list of values found in a row of data in a given query result set, starting from a specific position and ending at a specific position

  • Returned Output: Numeric List
  • Library: PQL \ Dynamic \ Row
  • Version: 2020.18.000
  • Compatibility: Any content (regardless of data source) in the relevant parts of the application

Syntax

DataSetRowRange( <Row Integer> , <Start Integer> , <End Integer> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The row number is the zero-based index number of the row of data in the result set.
Different Function types

Examples

The examples below use the following example grid.

This example returns the list of values from the "Poomah" row, starting in columns 1 through 3. (136,814.63 to 240,816.15):

DataSetRowRange(6, 1,3)