Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Reference: WQL Result Limits

Reference: WQL Result Limits

WQL queries return a maximum of 1 million rows. Workday processes queries for up to 30 minutes, after which they time out. Refer to this table for query and
LIMIT
 clause behavior.
Rows Returned By Query
LIMIT Clause in WQL Query
Query Behavior
>1 million
None
Query fails.
>1 million
<=1 million
Query succeeds and returns a maximum of 1 million rows. You can view 10,000 rows at a time.
<=1 million
None or <=1 million
Query succeeds and returns all rows. You can view 10,000 rows at a time.
Workday reserves the keyword
LIMIT
 for both a clause and a pagination parameter. The LIMIT keyword isn't case-sensitive.
  • Use the
    LIMIT
     clause to limit the number of total rows returned in a query response.
  • Use the
    limit
     parameter to specify how many rows to display per page of query response.