ASSOCIATE-REACTIVE-DEVELOPER practice question 13 of 35

For a record to be included in the output result it must be true for all filters defined.

Full set: 262 questions
Answer options
A: True
B: False
Correct Answer:
T; R; U; E
Explanation

The statement is correct. In OutSystems, when multiple filter conditions are defined within an Aggregate, they are implicitly combined using the logical AND operator. This means that for a database record to be fetched and included in the final output list, it must simultaneously satisfy every single filter condition that has been defined. If a record fails to meet even one of the filter conditions, it will be excluded from the result set.

Why Incorrect

The "False" option is incorrect because it would imply that records could be included even if they don't meet all filter conditions. This would be the case if the filters were combined with a logical OR operator, where a record would only need to satisfy at least one condition. However, the default and standard behavior for Aggregates in OutSystems is to combine filters with AND, requiring all conditions to be met.

References

1. OutSystems Official Documentation, "Filter query results": In the section describing how to add filters to an Aggregate, the documentation explicitly states: "When you add more than one filter to an Aggregate, the platform joins them using the and operator. This means that only the database records that meet all the filter conditions are fetched."

Source: OutSystems Success Center, Documentation, "Developing an Application", "Use Data", "Query Data", "Filter query results".

2. OutSystems Official Documentation, "Aggregates": The documentation on Aggregates details their components, including Filters. It explains that the "Filters" tab is where you define the conditions to narrow down the records returned by the query, and the platform's engine translates these visual filters into a WHERE clause in the executed SQL, with multiple conditions joined by AND.

Source: OutSystems Success Center, Documentation, "Reference", "OutSystems Language", "Data", "Aggregates".

3. OutSystems Guided Path, "Reactive Web Developer", "Filtering Data" Lesson: This official training material demonstrates the process of adding filters. In the exercises and video tutorials, it is shown that adding a second filter further restricts the data from the first filter, visually and functionally reinforcing the AND logic.

Source: OutSystems Training, Guided Paths, "Becoming a Reactive Web Developer", "Reactive Web Development", "Data Queries", "Filtering Data" module.

Scroll to Top