Operation Details
Description: Counts any recent existing records for a specified username, caseID, type and actionType.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  UserRecentAction 
WHERE UserRecentAction.userName = :userName 
  AND UserRecentAction.referenceNo = :referenceNo 
  AND UserRecentAction.type = :type 
  AND UserRecentAction.actionType = :actionType 
  AND UserRecentAction.actionDateTime >= :actionDateTime