Skip to main content




Service Studio version:


  • Edit
    Collaborate with us
    Edit this page on GitHub
  • 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?