Property
Description
Optionality
Default value
Obs.
Name
Text that identifies the query. The scope of the query depends on the scope of the action.
Mandatory
Name of the Record List. Used, for example, to feed a List Records widget.
Description
Free text that describes the query. You can edit the text by directly typing it in the property or in the description editor which opens by clicking 
Optional
Useful for documentation purposes.
The maximum size of this property is 2000 characters.
Cache in Minutes
Indicates how long the Simple Query results remain in cache. However, if the cache is invalidated, during this time, they are removed from the cache.
Optional
Empty value; means that the element is never cached.
Learn more About Caching Contents.
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 Record 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
Defines the maximum time Platform Server waits for this query to be executed, since the database connection was established.
This value is defined in seconds.
Optional
If there is no value specified in this property, the query time-out corresponds to the Default query timeout parameter specified in the Platform Server Configuration Tool.
Query
Double-click on the property name or click on to launch the Simple query editor where the query is specified.
Mandatory
Arguments
The arguments correspond to the parameters of the query. The values of the arguments must be of the same type as the parameters.
To specify the argument you can use the Expression editor.
Mandatory
Expressions assigned to parameters used in the Order By folder must follow the specific dynamic order by expression syntax