PARAMETERS

You can add a PARAMETERS clause at the beginning of a Workday Query Language (WQL) query to specify built-in prompt values for:

Data sources.

Data source filters.

Report fields.

Specify values for report fields in the PARAMETERS clause. You can specify values for data sources and data source filters in the PARAMETERS or FROM clause, but not both.

Syntax

PARAMETERS parameter1 = value1,...parameterN

Arguments

Argument	Description
parameter1 , parameter2 , ... parameterN	The alias for a parameter.
value1 , value2 , ... valueN	The value of the parameter that you want to query.

Comparison Operators

Operator	Field Data Type Compatibility	Description
=	Boolean Date Numeric Text	Equal.

Examples

To specify the

reportingDate

parameter for the

contractRates

field and the

company

parameter for a data source in the PARAMETERS clause:

PARAMETERS reportingDate = "2018-01-01", company = cb550da820584750aae8f807882fa79a
SELECT contractRateSheet, contractRates 
FROM contractRateSheetsForCompany

To specify the

reportingDate

parameter for the

contractRates

field in the PARAMETERS clause and the

company

parameter for a data source in the FROM clause:

PARAMETERS reportingDate = "2018-01-01" 
SELECT contractRateSheet, contractRates 
FROM contractRateSheetsForCompany(company = cb550da820584750aae8f807882fa79a)

To specify the parameters for a data source filter in the PARAMETERS clause:

PARAMETERS projectsAndProjectHierarchies = (0c0bbf2e124810a26765415bb08406c5), includeSubordinateProjectHierarchies = true
SELECT projectObject 
FROM projects (dataSourceFilter = projectsByProjectsProjectHierarchiesFilter)

Limitations

You can only specify the same parameter once in the query.

PARAMETERS field_1=val1, field1=val2

is invalid.

You must specify the

dataSourceFilter

in the FROM clause.