Skip to main content

Data

 

OutSystems

SQL

Fetches data from the database using your own SQL statement.

Properties

Name Description Mandatory Default value Observations
Name Identifies an element in the scope where it is defined, like a screen, action, or module. Yes    
Description Text that documents the element.     Useful for documentation purpose.
The maximum size of this property is 2000 characters.
Timeout Time in seconds after which, if the data request is not fulfilled, the request is aborted and an exception is raised.     If there is no value specified in this property, the timeout corresponds to the "Default query timeout" parameter specified in the Platform Server Configuration Tool.
Cache in Minutes Maximum time content or results are stored in memory. When undefined, nothing is cached.      
Max. Records Maximum number of records fetched from the database.     If undefined, the default value is:
– In widgets: StartIndex + LineCount + 1;
– Exporting to Excel: No limit.
Statement SQL statement to fetch data from the database.   SELECT  

Runtime Properties

Name Description Read Only Type Observations
List The records returned by the query.   Record List  
Count Number of records returned by the Count query.   Long Integer  
  • Was this article helpful?