Workday Developer Program GitHub

App catalog / wql

Workday Query Language (WQL)

Workday

Compare organization data from the standard endpoint with the data from WQL.

Reference Presentation WQL Workday Extend Workday REST API
View code Download zip
Get it with git instead

Check out only this folder and keep the git history, so you can open a pull request from the same checkout. See the contribution guide. 

git clone --filter=blob:none --sparse https://github.com/Workday/WorkdayDeveloperProgram.git
cd WorkdayDeveloperProgram
git sparse-checkout set catalog/wql

The zip carries the same trail: its SOURCE.md records the commit it was built from and these commands.

Version 2024.1

For details and updates associated with this version of the app, see the App Catalog Changelog.

Deploy Instructions

  1. Click the “Create Copy” button above.
  2. To modify app source code:
    1. Open the app in the Console.
    2. Click Open in App Builder.
  3. After making any changes, Save and Deploy.

Manual Deploy (Alternative)

  1. Install the Workday Extend Plugin for IntelliJ.
  2. Download and unzip the app source code.
  3. Open in IntelliJ
    1. Go to Tools > Workday Extend > Log in to Workday Extend. You will be prompted to login to Workday Developer Site.
    2. Go to Tools > Workday Extend > Log in to Tenant. You will be prompted to choose your tenant.
    3. Go to Tools > Workday Extend > Deploy App to Tenant. Select your application.

Create Custom Task (Optional)

  1. In your tenant, search for the Create Custom Task task.
  2. Fill in the form as outlined below:
    Title: Build WQL Query
    Application ID: {Your App's Reference ID} (ex: workdayQueryLanguage_abcdef)
    Site ID: {Your App's Reference ID} (ex: workdayQueryLanguage_abcdef)
    Route Path: /
  3. Under Business Object:
    Business Object: Worker (dropdown)
    Selection:: No Selection (radio button)
  4. Under Security
    Domains: Core Navigation
    Testing Mode Only: false (unchecked)

Usage Instructions

  1. The application lets you build and execute WQL queries and view the results on a single page
  2. Prompt for a Data Source then prompt for fields from that Data Source, view the resulting WQL query string and hit the Execute Query pageActionButton to see the raw results of the WQL call as well as the results of each row in a grid format. You can then modify your WQL query and re-execute as needed without having to refresh the page.