QuerySlice()

edit

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 		edit

Query object to slice.
offset
number, required 		edit

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

The number of rows to slice from the offset.

Examples

edit 
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