Query Data

Articles in this Section

• Fetch and Display Data from the Database

  Fetching data from the database using Aggregates. Check a mobile and a web usage example.

• Filter Query Results

  When designing queries, you can add conditions to filter sets of records returned by aggregates to fine-tune the database content you want to display.

• Sort Results in an Aggregate

  Use fixed and dynamic sorting in Aggregates to display records on your application screens following a customized sorting the records they return.

• Calculate Values from Grouped Data

  Use aggregate functions to calculate values based on groups of identical data.

• Aggregate a Column into a Single Value

  Use aggregate functions on a column to calculate a single value.

• Create a Calculated Attribute in an Aggregate

  How to create a new attribute to a data query and base its value on the other record's attributes.

• Get Distinct Values from the Database

  Use an aggregate with grouped columns to obtain only the distinct values of entity attributes.

• SQL Queries

  Use the SQL element to write and execute custom SQL queries.

• Write Your Own SQL Queries

  In OutSystems, you can use custom SQL to perform more advanced queries or operations not supported by aggregates.