SIZE_SELECTION
When used within a query the function produces a recordset of the specified number of records.
When used within a virtual field the function returns True for records that match the criteria given and False for those that do not.
SIZE_SELECTION ( <table_name or expression>, <size>, <offset> )
-
table name or expression: Can be either a table name, or an expression (a query string or another query domain function) resulting in a recordset.
-
size: The number of records to return
-
offset: A number representing the record at which to start sampling, as read from the first record in the table
Example: create a query at the CUSTOMER level
SIZE_SELECTION(CUSTOMER,7,2)