System Properties

glide.db.max_view_records

The system property glide.db.max_view_records controls the maximum number of rows returned.

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 10000. To change this value, add the property to the System Property (sys_properties) table and edit the number of rows to return.

Source: Configuring the number of records to return

If this threshold is breached this will be logged as

08.04.2024 16:50:21 Warning 2024-04-08 16:50:21.708 - The current rowCount of 10001 is greater than the value set as system property 'glide.db.max_view_records': 10000. Records could be missing. Please check the amount of records you are expecting.

and the returned JSON will include a warning

{
  "metadata": {
    ...,
    "row_count": 10001,
    "warnings": [
      "The current rowCount of 10001 is greater than the value set as system property 'glide.db.max_view_records': 10000. Records could be missing. Please check the amount of records you are expecting."
    ]
  },
  ...
}

If you see these warnings, please consider increasing the glide.db.max_view_records value or restricting your queries.

Squid intentionally does not sort or page data. What entities are returned if this threshold is breached is totally arbitrary.

Why no paging!?

Squid attempts to deliver as reliable and reproducible data as possible. Data in dynamic systems like ServiceNow is a moving target. Pagination implies that data is returned at different points in time and as pagination would only come into play with large data amounts every request/response cycle would take 1 - 10 - ? minutes. As Squid is stateless, we would need to reexecute the query against the then current state of data.

Added data in a previous page? Get redundant data in the current page.

Removed data in a previous page? Data is missing in the current page.

Hey, Squid, you're inconsistent! As that is something we definitely do not want to do here, we do not support pagination.

x_a46gh_squidx.useScopedCache

The system property x_a46gh_squidx.useScopedCache controls whether Squid uses scoped caches or not.

Squid is installed with this system property set to true.

x_a46gh_squidx.allowAclOverride

The system property x_a46gh_squidx.allowAclOverride explicitly allows Squid to ignore ACLs and must be set to true by you, the customer. ServiceNow best practices and guidelines require us to get your explicit permission to override ACLs.

Why?!

We get it. This might sound absurd at first glance, but there are very good reasons for this. See ServiceNow ACLs from a data export perspective for details.

Support restriction

Due to the inherent nature of ACLs and the accompanying risk of incomplete data exports,

arc46 cannot and will not offer any support unless this system property is set to true.