$('#CorrectiveActionsGrid').kendoGrid({
      toolbar: ['excel'],
      excel: {
        fileName: 'CorrectiveActions.xlsx',
        allPages: true,
      },
      dataSource: {
        type: 'aspnetmvc-ajax',
        transport: {
          read: {
            url: '/LoanAudit/GetAssignmentCorrectiveActions',
            type: 'GET',
            dataType: 'json',
            data: { assignedToId: $('#ddlEmployee').data('kendoDropDownList').value() },
          },
        },
        schema: {
          type: 'json',
          data: 'data',
          total: 'total',
          model: {
            id: 'id',
            fields: {
              id: { type: 'string' },
              loanNumb: { type: 'string' },
              questionText: { type: 'string' },
              note: { type: 'string' },
              status: { type: 'string' },
              caDueBy: { type: 'date' },
            },
          },
        },
        serverPaging: true,
        serverFiltering: true,
        serverSorting: true,
      },
      selectable: true,
      change: function (arg) {
        const selected = $.map(this.select(), function (item) {
          return $(item).find('td').first().text();
        });
        const url = `/LoanAudit/CorrectiveAction/${selected}`;
        window.open(url, '_blank');
      },
      filterable: true,
      sortable: true,
      pageable: {
        refresh: true,
        pageSize: 10,
        pageSizes: [5, 10, 15, 20, 30, 'All'],
        buttonCount: 5,
      },
      columns: [
        { field: 'id', filterable: true, title: 'Corrective Action Id' },
        { field: 'loanNumb', filterable: true, title: 'Loan Number' },
        { field: 'questionText', filterable: true, title: 'Action' },
        { field: 'note', filterable: true, title: 'Reviewer Note' },
        { field: 'status', filterable: true, title: 'Status' },
        {
          field: 'caDueBy',
          filterable: true,
          title: 'Due Date',
          template: "#= (caDueBy == null) ? '' : kendo.toString(kendo.parseDate(caDueBy, 'yyyy-MM-dd'), 'MM/dd/yyyy') #",
        },
      ],
    });