Queries
Collaborate with us
Edit this page on GitHub
We think these articles could help:
- New in OutSystems 11
- Getting Started
- Developing an Application
- Application Templates
- Use Data
- Data Modeling
- Query Data
- Fetch and Display Data from the Database
- Filter Query Results
- Sort Results in an Aggregate
- Calculate Values from Grouped Data
- Aggregate a Column into a Single Value
- Implement asynchronous data fetching using Aggregates
- Create a Calculated Attribute in an Aggregate
- Get Distinct Values from the Database
- SQL Queries
- Download a file through browser
- Bootstrap an Entity Using an Excel File
- Use Structures and Records to Create Compound Data Types
- Use Site Properties to Configure Behaviors at Runtime
- Sessions in Web Applications
- Share a Client Variable between apps
- Use Resources
- Caching
- Offline
- Design UI
- Implement Application Logic
- Use Processes (BPT)
- Use Timers
- Reuse and Refactor
- Secure the Application
- End User Management
- User Roles
- Restrict Access to an Internal Network
- Secure HTTP Requests
- Secure the Data of your Mobile Apps
- Troubleshooting Applications
- Merge the Work
- Developing for Testability
- Service Studio Shortcuts
- Delivering Mobile Apps
- Customize Your Mobile App
- Test Your Mobile App in the Device Using OutSystems Now
- Generate and Distribute Your Mobile App
- Mobile App Update Scenarios
- Mobile Apps Build Service
- Early Access - Distribute as a progressive web app (PWA)
- Compliance with Third Party Licenses
- Extensibility and Integration
- Artificial Intelligence
- Mobile Plugins
- JavaScript
- REST
- Consume REST APIs
- Expose REST APIs
- Expose a REST API
- Add Basic Authentication to an Exposed REST API
- Add Custom Authentication to an Exposed REST API
- Customize REST URLs
- Customize REST API Responses
- Preprocess REST API Requests
- Change the HTTP Status Code of a REST API
- Throw a Custom Error in an Exposed REST API
- Document an Exposed REST API
- Troubleshoot a REST API
- SOAP
- SAP
- Extend Logic with Your Own Code
- Integrate with an External Database
- Configure OutSystems to Send Emails
- Managing the Applications Lifecycle
- Manage Your OutSystems Infrastructure
- Deploy Applications
- Tag a Version
- Deploy an Application
- Deployment Plans
- Early Access - Configure Site Properties During Deployment
- Configure Application Settings After Deployment
- Deploy an Application with Dependencies
- Deploy a Single Module
- Plan a Deployment for the Operations Team
- Deploy in a Short Deployment Window
- Deploy to an Environment with Applications with Errors
- Deploy an Integration With an External Database
- Deploy an Application to a Container
- Apply a Hotfix
- Repair Deployed Applications
- Refactor an Application
- Rollback to a Previous Version
- Selective Deployment Using Deployment Zones
- Override the Default Mobile Extensibility Configurations
- Gather User Feedback
- Manage IT Users
- Understand the Permission Model for IT Users
- Create and Assign Roles
- Create an IT User
- Create an IT Team
- Set Up the Permissions in a Team
- Grant Permissions for Specific Applications
- Control Who Creates Applications
- Allow Managers to Handle Permissions of IT Teams
- Allow Integrations With External Databases
- Find Out the Permissions of IT Users
- Secure the Applications
- Monitor and Troubleshoot
- Test Automation in the Delivery Lifecycle
- Lifecycle Management and Data Protection
- Deploying to Containers
- Setting Up OutSystems
- Possible setups for an OutSystems infrastructure
- OutSystems system requirements
- OutSystems network requirements
- Default Platform Server and database configurations
- Configure your OutSystems environment
- Configure the infrastructure management console
- Unattended Installation and Upgrade
- OutSystems on Microsoft Azure
- Reference
- OutSystems Language
- Data
- Extensibility and Integration
- Mapping External DB Data Types to OutSystems Data Types
- REST APIs
- Consumed REST API
- Mapping REST Data Types to OutSystems Data Types
- REST API
- REST API Method
- Input Parameter (REST API Method)
- Output Parameter (REST API Method)
- Structure (REST API Method)
- Structure Attribute (REST API Method)
- REST API Callback
- Input Parameter (REST API Callback)
- Output Parameter (REST API Callback)
- Structure (REST API Callback)
- Structure Attribute (REST API Callback)
- Exposed REST API
- Built-in HTTP Status Codes
- Supported Media Types in REST API Requests
- REST API
- REST API Method
- Input Parameter (REST API Method)
- Output Parameter (REST API Method)
- REST API Callback
- Input Parameter (REST Service API Callback)
- Output Parameter (REST Service API Callback)
- Structure (REST Service API Callback)
- Structure Attribute (REST Service API Callback)
- REST API Callback (Authentication)
- Input Parameter (REST Authentication)
- Consumed REST API
- SAP
- Mapping SAP Data Types to OutSystems Data Types
- SAP Connection
- SAP Remote Function
- Input Parameter (SAP Remote Function)
- Output Parameter (SAP Remote Function)
- Structure (SAP Remote Function)
- Structure Attribute (SAP Remote Function)
- SAP Callback
- Input Parameter (SAP Callback)
- Input Parameter (SAP Username)
- Input Parameter (SAP Password)
- SOAP Web Services
- Consumed SOAP Web Service
- Mapping XML Data Types to OutSystems Data Types
- Consumed SOAP Web Services Constraints
- SOAP Web Service (Consumed)
- Web Service Method (Consumed)
- Input Parameter (Consumed SOAP Method)
- Output Parameter (Consumed SOAP Method)
- Username Input Parameter (Consumed SOAP)
- Password Input Parameter (Consumed SOAP)
- SOAP Callback (Consumed SOAP)
- Static Entity (Consumed SOAP)
- Static Entity Attribute (Consumed SOAP)
- Structure (Consumed SOAP)
- Structure Attribute (Consumed SOAP)
- Deprecated Implementation
- Exposed SOAP Web Service
- Consumed SOAP Web Service
- Logic
- Interfaces
- Platform Utilities
- Processes
- Workspace
- Traditional Web
- Web Interfaces
- Adding Data and Logic
- Designing Screens
- Button Widget
- Cell Widget
- Check Box Widget
- Combo Box Widget
- Comment Widget
- Container Widget
- Editable Table Widget
- Edit Record Widget
- Expression Widget
- Form Widget
- Header Row Widget
- If Widget
- Image Widget
- Input Password Widget
- Input Widget
- Label Widget
- Link Widget
- List Box Widget
- List Records Widget
- Placeholder Widget
- Radio Button Widget
- Row Widget
- Show Record Widget
- Table Records Widget
- Table Widget
- Text Widget
- Upload Widget
- Web Block Widget
- Designing the Layout
- Navigating in the Application
- Web Logic Tools
- Web System Events
- Module
- Web Interfaces
- Configuration Tool
- Errors and Warnings
- Errors
- 1-Click Publish Required Error
- Concurrent Publishing Error
- Connection Error
- Database Upgrade Error
- Empty 'OnException'
- Empty Widget
- Environment Fault Error
- Expression Overflow Error
- Grid Dimensions Overflow Error
- Incompatible Action Error
- Incompatible Date Formats Error
- Incompatible Version Error
- Internal Error
- Invalid Action Flow Error
- Invalid Aggregate Error
- Invalid Argument Value Error
- Invalid Attribute Error
- Invalid Blocks Error
- Invalid Client Function
- Invalid Column Reference Error
- Invalid Combo Box Widget Error
- Invalid Consumed Web Service Error
- Invalid Data Action
- Invalid Data Dependency
- Invalid Data Type Error
- Invalid Entity Error
- Invalid Entity Index Error
- Invalid Error Handler Error
- Invalid Error Handler Flow Error
- Invalid Excel Handling Error
- Invalid Excel Import Error
- Invalid Expression Error
- Invalid Extensibility Configurations
- Invalid Extension Error
- Invalid External Site Error
- Invalid Flow Error
- Invalid Group Error
- Invalid HTTP Method Error
- Invalid Image Error
- Invalid JavaScript
- Invalid Join Error
- Invalid Link Error
- Invalid List Box Widget Error
- Invalid Module Error
- Invalid Numeric Value Error
- Invalid Property Error
- Invalid Property Value Error
- Invalid Public Action Error
- Invalid Public Block Error
- Invalid Public Screen Block Error
- Invalid Public Structure Error
- Invalid Receive In Error
- Invalid Record Error
- Invalid Record List Indexer Error
- Invalid Reference Error
- Invalid Request Format Error
- Invalid Response Format Error
- Invalid SAP Connection Error
- Invalid Screen Error
- Invalid Send Bulk Messages Error
- Invalid SOAP Static Entity Usage Error
- Invalid SQL Error
- Invalid Structure Error
- Invalid Text Value Error
- Invalid Theme Error
- Invalid Transition
- Invalid URL Path Error
- Invalid Use of Grid Units Error
- Invalid User Function Error
- Invalid Username or Password Error
- Invalid Variable Error
- Licensing Error
- Mobile Debugger Related Errors
- module Name Conflict Error
- Module Version Error
- Multiple Date Formats Error
- Publishing Error
- Recursive Theme Hierarchy Error
- Required Input Parameter Error
- Required Output Parameter Error
- Required Permission Error
- Required Property Value Error
- Unknown Object
- Unsupported Consumed Web Service Error
- Unused Callback Error
- Unused Input Parameter Error
- Warnings
- Application Configuration Warning
- Audit Suggestion Warning
- Coherence Suggestion Warning
- Consumed Web Service Integrity Warning
- Data Dependency Warning
- Database Integrity Suggestion Warning
- Debugger Not Started Warning
- Deprecated jQuery Version Warning
- Expression Should Be Escaped Warning
- Grid Dimensions Overflow Warning
- HTML Injection Warning
- Incompatible Consumer Warning
- Inconsistent Dependency Warning
- Internal Warning
- Invalid Argument Value Warning
- Invalid Theme Warning
- Invalid Widget Warning
- JavaScript Injection Warning
- Licensing Warning
- Maintenance Suggestion Warning
- Missing Dependency Warning
- Missing Entity Association Warning
- Missing Entity Filter Warning
- Missing Entity Warning
- Missing Module Warning
- Missing Process Detail Warning
- Missing User Provider Warning
- Modified or Missing Reference Warning
- Module Name Changed Warning
- No Error Handling Warning
- Open Redirect Warning
- Outdated Consumer Info
- Outdated Producer Warning
- Outdated Subscriber Warning
- Performance Suggestion Warning
- Physical Table Name Changed Warning
- Possible Data Loss Warning
- Potential Incompatible Consumer Warning
- Potential Loop at Runtime Warning
- Required Phone Warning
- Scalability Suggestion Warning
- Security Warning
- SQL Injection Warning
- Unexpected Attribute Warning
- Unexpected Data Type Warning
- Unexpected Database Warning
- Unexpected Error Handler Warning
- Unexpected Link Warning
- Unexpected SQL Warning
- Unexpected Widget Warning
- Unused Action Warning
- Unused Attribute Warning
- Unused Connector Warning
- Unused Element Warning
- Unused User Action Warning
- Upgrade Information Warning
- Usability Suggestion Warning
- Integration Studio Errors
- Compiler Error
- Connection Error
- Environment Fault Error
- Expression Overflow error
- Extension Name Conflict Error
- Invalid Attribute Error
- Invalid Data Type Error
- Invalid Entity Error
- Invalid Expression Error
- Invalid Extension Error
- Invalid Parameter Error
- Invalid Property Value Error
- Invalid Resource Error
- Invalid Structure Error
- Invalid Text Value Error
- Merge Templates Error
- Missing Resource Error
- Publishing Error
- Resource in Use Error
- Integration Studio Warnings
- Errors
- Integration Studio
- OutSystems APIs
- Asynchronous Logging API
- BinaryData API
- BPT API
- Charts API
- DbCleaner API
- Emails API
- EnhancedWebReferences API
- EPA Taskbox API
- HTTPRequestHandler API
- IncludeJavascript API
- JavaScript API
- LifeTime API v2
- LifeTime API v1
- LifeTime SDK
- LifeTime Services API
- outsystems.api.preloader API
- outsystems.api.requestInfo API
- PerformanceMonitoring API
- PlatformPasswordUtils API
- PlatformRuntime API
- Processes API
- REST Extensibility API
- RuntimePublic.Db API
- Sanitization API
- SAP Extensibility API
- SOAP Extensibility API
- System Actions
- Text API
- Users API
- OutSystems Language
