QuerySlice()

creates a new query containing a part of the given query

QuerySlice( query=query, offset=number, length=number );

Returns: Query

Argument Description
query
query, required

Query object to slice.
offset
number, required

Start position in the original query to slice
length
number, optional

The number of rows to slice from the offset.

Examples

people = QueryNew( "name,dob,age", "varchar,date,int", [
    [ "Susi", CreateDate( 1970, 1, 1 ), 0 ],
    [ "Urs" , CreateDate( 1995, 1, 1 ), 0 ],
    [ "Fred", CreateDate( 1960, 1, 1 ), 0 ],
    [ "Jim" , CreateDate( 1988, 1, 1 ), 0 ]
]);
Dump( var=people, label="people - original query" );
/* Output:
| name | dob                 | age |
------------------------------------
| Susi | 1970-01-01 00:00:00 | 0   |
| Urs  | 1995-01-01 00:00:00 | 0   |
| Fred | 1960-01-01 00:00:00 | 0   |
| Jim  | 1988-01-01 00:00:00 | 0   |
*/
// paging
qrySlice = people.slice(3,2)
dump(var=qrySlice, label='qrySlice - from record 3, 2 records');
/* Output:
| name | dob                 | age |
------------------------------------
| Fred | 1960-01-01 00:00:00 | 0   |
| Jim  | 1988-01-01 00:00:00 | 0   |
*/

See also