Skip to main content






Fetches data from the database using your own SQL statement.


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 read from the database. The SQL statement is not changed by this setting; the limit applies only to the results received 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?