Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-780

TSR Integration->Issues for OB tour reports.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Integrations
    • Labels:
      None
    • Module:
      TSR
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Q1

      Description

      1] Add employee through API on Stage environment.
      2] Start traversing assigned tour.
      3] Login as a partner and try to view different tour reports from Onboarding module.

      Issues -
      1] Tour Status Report -> Data is not getting loaded.
      2] Tour Step Completion Rate Report -> Completion time is displaying as 0 sec.
      3] Incomplete Tour Report-> "No Records Found" message displaying.

      Cc: Prasad Pise

        Attachments

          Issue Links

            Activity

            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected:

            1. Database Objects/MasterCompanyDB/04_Stored Procedures/ob.OES_SP_GetTourChart_Details.StoredProcedure.sql
            2. Web/Web Projects/OnBoard/Areas/Customization/Views/Customization/Reports/Reports.cshtml
            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: Database Objects/MasterCompanyDB/04_Stored Procedures/ob.OES_SP_GetTourChart_Details.StoredProcedure.sql Web/Web Projects/OnBoard/Areas/Customization/Views/Customization/Reports/Reports.cshtml
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Concern:Issues for OB tour reports.
            Cause:
            1] Tour Status Report -> Data is not getting loaded.
            – Employee's added through API do not have classes until classes are assigned. Tour Status chart uses the eligibility rule to process the employees. As these Employees do not satisfy the rule due to lack of classes,they do not show up on the report.
            2] Tour Step Completion Rate Report -> Completion time is displaying as 0 sec.
            – Instead of selected value ,selected Index of drop down is used as tour id. Due to this, tour id was getting mismatched with the data in the system,hence it always returned 0 sec.
            Correction :
            1] We have added code to consider Employees added through API in tour chart
            2] We are now considering selected value of drop down as tour id.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Concern :Issues for OB tour reports. Cause: 1] Tour Status Report -> Data is not getting loaded. – Employee's added through API do not have classes until classes are assigned. Tour Status chart uses the eligibility rule to process the employees. As these Employees do not satisfy the rule due to lack of classes,they do not show up on the report. 2] Tour Step Completion Rate Report -> Completion time is displaying as 0 sec. – Instead of selected value ,selected Index of drop down is used as tour id. Due to this, tour id was getting mismatched with the data in the system,hence it always returned 0 sec. Correction : 1] We have added code to consider Employees added through API in tour chart 2] We are now considering selected value of drop down as tour id.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Point 3 is non repro.
            Scenario tried:
            1. Created a tour with window period as 1 day
            2. Assigned this tour to an employee added through API whose employment date is 4/20/2017.
            3. Verified the Incomplete tour Report. This employee's record came up on report with tour status as Not started.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Point 3 is non repro. Scenario tried: 1. Created a tour with window period as 1 day 2. Assigned this tour to an employee added through API whose employment date is 4/20/2017. 3. Verified the Incomplete tour Report. This employee's record came up on report with tour status as Not started.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Kunal Kedari,

            Please verify the issues(pts. 1 and 2).
            Point 3 is non repro.
            Please go through my earlier comment for more details on point 3.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Kunal Kedari , Please verify the issues(pts. 1 and 2). Point 3 is non repro. Please go through my earlier comment for more details on point 3.
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Hi Ramya Tantry,

            We have verified the fixes for the "Tour Status" and "Tour Step Completion Rate Report", working as expected. We can deploy fix to Stage.

            Cc: Saurabh Sablaka, Prasad Pise

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Hi Ramya Tantry , We have verified the fixes for the "Tour Status" and "Tour Step Completion Rate Report", working as expected. We can deploy fix to Stage. Cc: Saurabh Sablaka , Prasad Pise
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Verified the mentioned report on Stage, working as expected. We can deploy fix to Production.

            Cc: Saurabh Sablaka, Prasad Pise

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Verified the mentioned report on Stage, working as expected. We can deploy fix to Production. Cc: Saurabh Sablaka , Prasad Pise
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Verified the fix on Production, working as expected. Closing the ticket.

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Verified the fix on Production, working as expected. Closing the ticket.

              People

              Assignee:
              kunal.kedari Kunal Kedari (Inactive)
              Reporter:
              kunal.kedari Kunal Kedari (Inactive)
              Developer:
              Ramya Tantry (Inactive)
              QA:
              Kunal Kedari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 12h Original Estimate - 12h
                  12h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 15h 20m
                  15h 20m