The next table presents the properties of the Refresh Data.

Property

Description

Optionality

Default value

Obs.

Max. Records

Maximum number of records that are fetched from the database.

Optional

 

If you don't know exactly the number of records that the output List must have, you should specify a number big enough to handle these situations. For example, when you want to get all the rows of a table or delete a set of rows.

If a value is not specified, the OutSystems Platform uses the following as Max. Records:

  • In Widgets
StartIndex + LineCount + 1
  • Exporting to Excel
No limit of records

Query

The Aggregate or SQL query to be executed.

Mandatory

 

 

Arguments

The arguments that are used by the SQL query to re-execute it.

Mandatory

 

 

See Also

Refresh Data Properties | Fetching Data from the Database