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
* 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
- See the related functions for DataSetRows, DataSetColumns and DataSetColumnRange.
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)