ROWS (for IdoPostLoad-Collection Events)

Returns the number of rows loaded by the collection that generated an event. This keyword applies only to IdoPostLoad-Collection events. If you use it for other types of events, it returns 0.

Return Value

Integer

Syntax

ROWS()

This example, specified in the Event Actions parameters for a Notify action type, sends a notification to the sysadm user if someone loads more than 1000 rows:


CONDITION(ROWS()>1000)
TO("sysadm")
SUBJECT("Excessive Use")
BODY(SUBSTITUTE("User {0} loaded {1} rows", USERNAME(), ROWS())
SAVEMESSAGE(FALSE)