PAGESIZE

By default, the maximum number of results displayed per page is 200 for documents and 1000 for objects. In v20.3+, use the PAGESIZE clause to limit the number of results returned per page.

Using PAGESIZE does not change the total number of results found, only the number displayed per page.

Learn more about limiting page results.

If you’re using VQL version v20.2 or lower, you must use LIMIT instead of PAGESIZE. If you use both LIMIT and PAGESIZE in a query, the query ignores LIMIT.

Note

Vault may scale down the page size to protect performance.

Syntax

Section link for Syntax

Copy to clipboard

SELECT {fields} FROM {query target} PAGESIZE {number}

Query Examples

Section link for Query Examples

The following are examples of queries using PAGESIZE.

Query

Section link for Query

The following query returns 25 documents per page:

Copy to clipboard

SELECT id FROM documents PAGESIZE 25

LIMIT

Section link for LIMIT

Note

Deprecated as of v20.3. Instead, use PAGESIZE.

By default, the maximum number of results displayed per page is 200 for documents and 1000 for objects. Use the LIMIT clause to limit the number of results returned per page.

Using LIMIT does not change the total number of results found, only the number displayed per page.

Learn more about limiting page results.

Syntax

Section link for Syntax

Copy to clipboard

SELECT {fields} FROM {query target} LIMIT {number}

Query Examples

Section link for Query Examples

The following are examples of queries using LIMIT.

Query

Section link for Query

The following query returns 25 documents per page:

Copy to clipboard

SELECT id FROM documents LIMIT 25