Use Data

OutSystems allows you to define and use complex data in entities and structures. Entities allow you to keep information persistently, while structures are used to manage complex data.

To retrieve information from your application database you can define aggregates and advanced SQL queries.

• Data Modeling

  Learn how to define the tables, relationships and indexes of the application of your database.

  Featured Article:

  • Entities
  • Create an Entity to Persist Data
  • Static Entities

  See More

• Query Data

  Check examples of database queries using aggregates and custom SQL queries. See how to manipulate sets of records returned using filters, sorting or operations other operations supported by aggregates.

  Featured Article:

  • Filter Query Results
  • Sort Results in an Aggregate
  • Calculate Values from Grouped Data

  See More

• Offline

  An overview of how to implement offline sync in your mobile apps.

  Featured Article:

  • Implementing Offline Sync
  • Sync Framework Reference
  • Offline Data Sync Patterns

  See More

Articles in this Section

• Bootstrap an Entity Using an Excel File

  Import data from Excel files to quickly have your data up and running in the application while developing it.

• Use Structures and Records to Create Compound Data Types

  Learn how to create and use complex data types in your applications.

• Use Site Properties to Configure Behaviors at Runtime

  Store variables at the environment level and use them to implement application behaviors that are configurable at runtime.

• Sessions in Web Applications

  Learn how OutSystems uses Sessions to maintain information about the previous web requests the end-user made.

• Use Resources

  Learn how to use Resources to display a PDF document or to play a video file in a screen.