View WQL Query Results

Administrator Guide

Security: Workday Query Language
domain in the System functional area.

You can test Workday Query Language (WQL) queries in your tenant as an alternative to testing them in third-party applications. Workday returns up to 500 rows of results, providing you with a response you can use to continue developing your query.

Access the

View WQL Query Result

report.

Enter a WQL query for which you want to view sample results.

Workday truncates the results to 500 rows when you enter a query:

Without a limit.

With a limit greater than 500.

(Optional) To save the query for later use, enter a name for it and click

Save

You can access the

Manage My Saved Filters

report later to retrieve the saved query.

When you enter this query:

SELECT location, count() 
FROM allWorkers 
GROUP BY location
ORDER BY count ()
LIMIT 4

Workday returns the discrete count of locations in ascending order because of the clause

ORDER BY count ()

Location	Count
Main Campus	419
Pleasanton	1042
San Francisco	1103
London	1172

To sort the discrete count of locations in descending order, specify:

ORDER BY count () desc

Reference: Reporting Limits

Reference: WQL Result Limits