ASSOCIATE-REACTIVE-DEVELOPER practice question 8 of 35

It is possible to see the SQL generated by an Aggregate?

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

In OutSystems Service Studio, developers can view the SQL query that the platform generates from a visual Aggregate. When an Aggregate is open in the editor, the "Executed SQL" property is available in the properties pane. This feature displays the actual SQL statement that will be executed against the database, which is invaluable for debugging, performance tuning, and understanding how the visual query translates to a database command.

Why Incorrect

The alternative, "False," is incorrect. The OutSystems platform is designed to provide developers with transparency and control. Hiding the generated SQL would hinder a developer's ability to diagnose performance issues or verify the logic of complex data fetches. The "Executed SQL" property is an explicit and standard feature of the Aggregate editor in Service Studio.

References

1. OutSystems Official Documentation, "Use Aggregates to Fetch Data": In the section describing the Aggregate editor interface, the documentation explicitly states: "The Executed SQL property of the Aggregate shows the SQL query that is executed on the database. Use this for debugging, for example, to test the query directly on the database."

Source: OutSystems Success Center, Documentation, "Use Aggregates to Fetch Data".

2. OutSystems Official Documentation, "Troubleshoot the performance of an Aggregate": This performance guide instructs developers on how to analyze slow queries. A key step mentioned is: "Check the SQL query that is executed on the database in the Executed SQL property of the Aggregate. Copy the SQL and run it directly on the database using a database management tool."

Source: OutSystems Success Center, Documentation, "Troubleshoot the performance of an Aggregate".

3. OutSystems Training Courseware, "Aggregates 101": Within the "Becoming a Reactive Web Developer" guided path, this course demonstrates the features of the Aggregate editor. The lesson on the editor's interface showcases the "Executed SQL" tab and explains its function as a tool for developers to inspect the underlying query generated by the platform.

Source: OutSystems Training, Guided Path: Becoming a Reactive Web Developer, Course: "Aggregates 101".

Scroll to Top