{
  "title": "Overdue Progress Report",
  "every": null,
  "timeUnit": null,
  "doUploadToSharePoint": false,
  "doSchedule": false,
  "doPullRecurring": false,
  "reportDefinition": {
    "title": "Overdue Progress Report",
    "returnType": "Excel",
    "description": "Training overdue progress report that contains the following: \nFilters\n-Catalog name (placeholder needs to be updated with catalog name)\nReport Fields\na) Learner and Manager information (name, department, and email).\nb) Course name.\nc) Active enrollments with pending training completion (Not started, In Progress).\nd) Registration date.\ne) Overdue details (days overdue and due date)",
    "fields": [
      {
        "name": "Title",
        "label": "Learner Name",
        "source": "Learner",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "Email",
        "label": "Learner Email",
        "source": "Learner",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "Department",
        "label": "Department",
        "source": "Learner",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "Email",
        "label": "Manager Email",
        "source": "Learner's manager",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "Title",
        "label": "Course Title",
        "source": "Course",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "CoursePassingStatus",
        "label": "Completion Status",
        "source": "Enrollment",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "RegistrationDate",
        "label": "Enrollment Date",
        "source": "Enrollment",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "DaysOverdue",
        "label": "Days Overdue",
        "source": "Enrollment",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "DueDate",
        "label": "Due Date",
        "source": "Enrollment",
        "valueReplacements": [],
        "dateFormat": null
      }
    ],
    "filter": {
      "operator": "And",
      "groups": [],
      "conditions": [
        {
          "source": "Catalog",
          "field": "Title",
          "operator": "is equal to",
          "value": "Enter CatalogName"
        },
        {
          "source": "Learner",
          "field": "IsDeleted",
          "operator": "is equal to",
          "value": "false"
        },
        {
          "source": "Enrollment",
          "field": "OverdueNotCompleted",
          "operator": "is equal to",
          "value": "true"
        },
        {
          "source": "Course",
          "field": "IsDeleted",
          "operator": "is equal to",
          "value": "false"
        },
        {
          "source": "Enrollment",
          "field": "RegistrationStatus",
          "operator": "is equal to",
          "value": "Active"
        }
      ],
      "sign": "Is"
    }
  },
  "nextPullDate": null
}