What is the expected output of an aggregate with a "with or without" junction between two entities?

When using a "with or without" junction between two entities in an aggregate, the expected behavior is to include all records from the left entity regardless of whether there is a corresponding match in the right entity. This effectively means that a LEFT JOIN is being performed. In a LEFT JOIN, the result will include all records from the left entity, and for any record that does not have a match in the right entity, the fields from the right entity will be shown as null or empty.

This behavior is particularly important in scenarios where the integrity of the left entity’s data needs to be maintained, even when there are no corresponding records in the right entity. This allows for a comprehensive view of the data from the left entity, while potentially highlighting gaps in related data from the right entity.

Choosing this option reflects an understanding of how data relationships are represented in aggregates within the OutSystems platform, allowing for robust data querying and reporting.