Specify the number of records to return
-
- UpdatedAug 3, 2023
- 1 minute read
- Vancouver
- Table Administration
The Vancouver release is no longer supported. As such, the product documentation and release notes are provided for informational purposes only, and will not be updated.
Specify the number of records to return for a database view when the view is used in a script.
A property called glide.db.max_view_records controls the maximum number of rows returned when running a GlideRecord query in a script. The default value for this property is 10001. To change this value, add the property to the System Property [sys_properties] table and edit the number of rows to return.
This property only applies when querying a database view table in a script. When the database view table is used in a list or report, this property doesn’t apply. Reports or lists based on the database view use all rows in the view.