Configure the Learning Assignment report in Workday to retrieve user's
learning assignments.
Before you begin
User with access to report creation and the Learning
Assignments by Learning Organization data source.
About this task
- For identification purposes, all calculated field name starts with
CF.
- Create all calculated fields for this report before developing the report.
Thus, all fields are available while creating the report.
- Report name can be different while creating the report. But ensure that the
report field name or column heading override for the respective field (if
it’s given in the report document) is same as it is in the report document.
Report field label should be same as it is in the report document. Else, the
developed action fails.
- Group Column Heading for each business object in the
Group Column Headings section should be
empty.
- Ensure that you add parenthesis in filter while creating it.
- All reports must be shared or owned by the ISU user that accesses these
actions on the ServiceNow platform.
- In the Advanced section, select the Enable
as webservice check box.
Procedure
-
Create Lookup Related Value type calculated field with name,
cf_learning content_type.
-
Create the True/False condition type calculated field with name,
CF_enrollment_event_status.
-
Create the Lookup Related Value type calculated field with name,
CF_enrollment and select
CF_enrollment_event_status as the return value.
-
Create Extract Multi-Instance type calculated field with name,
CF_learning_enrollment and select
CF_enrollment as the return value.
-
Create the True/False condition type calculated field with name,
cf_course_type_is_blended.
-
Create the True/False condition type calculated field with name,
Cf_learning_content_type_is_digital_course.
-
Create the True/False condition type calculated field with name,
Cf_learning_content_type_is_course_offering.
-
Create the True/False condition type calculated field with name,
Cf_learning_content_type_is_program.
-
Create the True/False condition type calculated field with name,
Cf_learning_content_type_is_lesson.
-
Create the Lookup Related Value type calculated field with name,
CF_blended course.
-
Create the Lookup Related Value type calculated field with name,
cf_blended course id.
-
Create the Lookup Related Value type calculated field with name,
cf_digital course.
-
Create the Lookup Related Value type calculated field with name,
cf_digital_course_id.
-
Create the Lookup Related Value type calculated field with name,
cf_course_offering.
-
Create the Lookup Related Value type calculated field with name,
cf_course_offering_id.
-
Create the Lookup Related Value type calculated field with name,
CF_Program.
-
Create the Lookup Related Value type calculated field with name,
Cf_program_id.
-
Create the Lookup Related Value type calculated field with name,
CF_lesson.
-
Create the Lookup Related Value type calculated field with name,
cf_lesson_id.
-
Create the Evaluate Expression type calculated field with name,
cf_learning_content_id and use all the calculated
field created under Calculated field 3.
-
Create the Learning Assignment report.
-
Access the Create Custom Report task.
-
Provide the report name, for example, Test -Learning Assignment.
-
Select report type as Advanced.
-
Clear the Optimized for performance check
box.
-
Select data source as Learning Assignments by Learning
Organization.
-
Don’t select the temporary report check box.
-
Click Ok.
-
Select the report business object and report fields.
-
In the Group Column Headings section, select all business objects.
The Group Column Heading for each business object is empty.
-
In the Sort tab, select the values as shown
here.
-
In the Filter tab, select the values as show here.
Be sure to add parentheses.
-
In the Prompts tab, select the
Populate Undefined prompt defaults check
box.
-
Select the values of prompts under the Prompt
Default section and ensure that the values of the
Label For Prompt XML Alias field are as shown
here.
-
In the Advanced section, select the
Enable as webservice check box and click
Ok.
-
After the report configuration is done, click the three dots icon and
navigate to .
-
Specify values for the fields as per your requirement and click
Ok.
-
In the View URLs Web Service page, click the active link you want to generate.
The RaaS URL is displayed in a new browser tab.