What happens when the GetEmployeeById Aggregate does not return any record?

When the GetEmployeeById Aggregate does not return any records, the RecordNotFound flow is executed. This feature of the OutSystems platform is designed to handle situations where an aggregate query does not find any results, typically leading to a scenario where a specific entity is expected (in this case, an employee record by ID) but is absent from the database.

Utilizing the RecordNotFound flow allows for a controlled way to manage such scenarios, enabling developers to define specific actions when an expected record is not found. This could involve redirecting users to an error page, displaying a message indicating that the employee does not exist, or any other form of user feedback that guides the interaction smoothly.

In contrast, scenarios such as triggering a global exception handler, raising a DatabaseException, or handling a situation with no exception being raised do not accurately reflect the intended and designed behavior of the OutSystems platform with regards to aggregates and record retrieval. The platform’s mechanism aims to provide clear paths for both found and not found scenarios, promoting a robust user experience and error handling strategy.