The Post-Select trigger fires after the default selection phase of query processing, or after the successful execution of the On-Select trigger. It fires before any records are actually retrieved through fetch processing.
Definition Level form or block
SELECT statements, unrestricted Built-ins
Enter Query Mode no
Usage Note:
Use the Post-Select trigger to perform an action based on the outcome of the Select phase of query processing such as an action based on the number of records that match the query criteria.
When the populate_group Built-in fails because the record group does not exist, a NULL value will be returned.
Execute the Query
Open the Query