Turn 1: prompt (sent 2026-11-20T04:49:35.143Z)
Write me a WQL query I can run against our Workday tenant (through Workday’s WQL REST API) that returns, for each supervisory organization, the number of active employees hired on or after 1 January 2025, with the largest count first. Organizations with none can be left out.
Turn 1: answer (2026-11-20T04:50:02.476Z, 27.3 s)
I’ll check Workday’s WQL syntax and which field names you may need to confirm in your tenant.
SELECT supervisoryOrganization, COUNT()
FROM allActiveEmployees
WHERE hireDate >= '2025-01-01'
GROUP BY supervisoryOrganization
ORDER BY COUNT() DESCPass this statement as the URL-encoded query parameter to the WQL GET /data endpoint. It counts currently active employees under their current supervisory organization, includes hires on January 1, 2025, and returns only organizations with at least one match, largest count first. Workday WQL syntax · Workday REST request example