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

  1. Create Lookup Related Value type calculated field with name, cf_learning content_type.
  2. Create the True/False condition type calculated field with name, CF_enrollment_event_status.
  3. Create the Lookup Related Value type calculated field with name, CF_enrollment and select CF_enrollment_event_status as the return value.
  4. Create Extract Multi-Instance type calculated field with name, CF_learning_enrollment and select CF_enrollment as the return value.
  5. Create the True/False condition type calculated field with name, cf_course_type_is_blended.
  6. Create the True/False condition type calculated field with name, Cf_learning_content_type_is_digital_course.
  7. Create the True/False condition type calculated field with name, Cf_learning_content_type_is_course_offering.
  8. Create the True/False condition type calculated field with name, Cf_learning_content_type_is_program.
  9. Create the True/False condition type calculated field with name, Cf_learning_content_type_is_lesson.
  10. Create the Lookup Related Value type calculated field with name, CF_blended course.
  11. Create the Lookup Related Value type calculated field with name, cf_blended course id.
  12. Create the Lookup Related Value type calculated field with name, cf_digital course.
  13. Create the Lookup Related Value type calculated field with name, cf_digital_course_id.
  14. Create the Lookup Related Value type calculated field with name, cf_course_offering.
  15. Create the Lookup Related Value type calculated field with name, cf_course_offering_id.
  16. Create the Lookup Related Value type calculated field with name, CF_Program.
  17. Create the Lookup Related Value type calculated field with name, Cf_program_id.
  18. Create the Lookup Related Value type calculated field with name, CF_lesson.
  19. Create the Lookup Related Value type calculated field with name, cf_lesson_id.
  20. Create the Evaluate Expression type calculated field with name, cf_learning_content_id and use all the calculated field created under Calculated field 3.
  21. Create the Learning Assignment report.
    1. Access the Create Custom Report task.
    2. Provide the report name, for example, Test -Learning Assignment.
    3. Select report type as Advanced.
    4. Clear the Optimized for performance check box.
    5. Select data source as Learning Assignments by Learning Organization.
    6. Don’t select the temporary report check box.
    7. Click Ok.
    8. Select the report business object and report fields.
    9. In the Group Column Headings section, select all business objects.

      The Group Column Heading for each business object is empty.

    10. In the Sort tab, select the values as shown here.
    11. In the Filter tab, select the values as show here.

      Be sure to add parentheses.

    12. In the Prompts tab, select the Populate Undefined prompt defaults check box.
    13. 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.
    14. In the Advanced section, select the Enable as webservice check box and click Ok.
    15. After the report configuration is done, click the three dots icon and navigate to Web Services > View URLs.
    16. Specify values for the fields as per your requirement and click Ok.
    17. 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.