Increasing query rows in ServiceNow
The default query row limit is 250 in ServiceNow. The ServiceNow instances in Dublin have a default query row limit of 10000 for the JSON service.
The system property [of sys_properties table]: glide.processor.json.row_limit determines the query row limit.
To enable this property in the ServiceNow table, perform the following tasks:
- 1Type sys_properties.list in the Navigation filter.
The entire list of properties in the sys_properties table appears. When the property is not available, it uses the default value.
- 2If you want a different value, you must create the property. If the property already exists, update the value.
- 3To create a new property, click New in the System Properties list.
- 4Specify the Name as glide.processor.json.row_limit, Type as Integer, and Value with the required number.
- 5Click Save or Update.