Works at the many end of a one-to-many link and flags child records that are after records that meet the criteria given in the source query. The records are checked in natural database order.
NTH_AFTER ( <source_query>, <link_table>, <N>, [, <All> [, <filter_query>] ] )
-
source_query: A query string that represents the set of records to check.
-
link_table: The name of the table at the one end.
-
N: The index value to be used. A value of 1 indicates that the first value (after a record meeting the source_query criteria) will be flagged; a value of 2 indicates that the second value (after a record meeting the source_query criteria) will be flagged and so on.
-
All: 1: Flag all records up to and including the Nth record. 0 just flag Nth record. 0 is default.
-
filter_query: A query string representing the domain of records to include.
Example
Example: Create a field on the PRODUCT table that flags all records up to and including the 3rd record after a product of type B was purchased.
NTH_AFTER([PRODUCT.PRODUCT_CODE] = "B",CUSTOMER,3,1 )