New Features 2017Project Type: software

New Features 2017

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

TSR : OnBoarding Structural Change: DB structure changes. AND Change in tour assignment & retrieval queries

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • 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
    • Sprint:
      NF Sprint 6
    • Feature Category:
      Integration
    • Severity:
      Simple

      Description

      OnBoarding Structural Change: Tour employee & Job mapping
      -Accept tour request in Workterra & send responses on basis of
      Employee - Job Position - Tour ID

      Following are the Dev activities involved

      DB structure changes
      Change in tour assignment & retrieval queries

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. NF-52 TSR - WT [ OnBoarding Integration ]

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            prasadp Prasad Pise (Inactive) created issue -
            Permalink
            rupesh.mandal Rupesh Mandal (Inactive) logged work - 08/Mar/17 01:19 PM
            • Time Spent:
              8h
               

              DB structure changes Done

            Permalink
            rupesh.mandal Rupesh Mandal (Inactive) logged work - 09/Mar/17 12:20 PM
            • Time Spent:
              4h
               

              Patch created for DB structure changes Done

            Permalink
            rupesh.mandal Rupesh Mandal (Inactive) logged work - 09/Mar/17 12:21 PM
            • Time Spent:
              4h
               

              Retrieves Query For changes

            rupesh.mandal Rupesh Mandal (Inactive) made changes -
            Field Original Value New Value
            Assignee Saurabh Sablaka [ saurabh.sablaka ] Rupesh Mandal [ rupesh.mandal ]
            rupesh.mandal Rupesh Mandal (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 8h [ 28800 ]
            Worklog Id 30065 [ 30065 ]
            rupesh.mandal Rupesh Mandal (Inactive) made changes -
            Time Spent 8h [ 28800 ] 12h [ 43200 ]
            Worklog Id 30068 [ 30068 ]
            rupesh.mandal Rupesh Mandal (Inactive) made changes -
            Time Spent 12h [ 43200 ] 16h [ 57600 ]
            Worklog Id 30070 [ 30070 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Feature Category Integration [ 13701 ]
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
            QA Prasad Pise [ prasadp ]
            Remaining Estimate 0h [ 0 ] 31h [ 111600 ]
            Original Estimate 31h [ 111600 ]
            Permalink
            rupesh.mandal Rupesh Mandal (Inactive) logged work - 10/Mar/17 12:58 PM
            • Time Spent:
              8h
               

              start retrieving queries which tables structure had changed in tour assignment

            rupesh.mandal Rupesh Mandal (Inactive) made changes -
            Remaining Estimate 31h [ 111600 ] 23h [ 82800 ]
            Time Spent 16h [ 57600 ] 24h [ 86400 ]
            Worklog Id 30538 [ 30538 ]
            Permalink
            rupesh.mandal Rupesh Mandal (Inactive) logged work - 13/Mar/17 11:41 AM
            • Time Spent:
              8h
               

              Done changes in manage tour Store procedure and queries don changes in tour assigment

            rupesh.mandal Rupesh Mandal (Inactive) made changes -
            Remaining Estimate 23h [ 82800 ] 15h [ 54000 ]
            Time Spent 24h [ 86400 ] 32h [ 115200 ]
            Worklog Id 31140 [ 31140 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Permalink
            saurabh.sablaka Saurabh Sablaka (Inactive) logged work - 21/Mar/17 11:00 AM
            • Time Spent:
              2h
               

              TSR changes for validation, add employee scenarios

            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Assignee Rupesh Mandal [ rupesh.mandal ] Saurabh Sablaka [ saurabh.sablaka ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Assignee Saurabh Sablaka [ saurabh.sablaka ] Prasad Pise [ prasadp ]
            Permalink
            saurabh.sablaka Saurabh Sablaka (Inactive) logged work - 22/Mar/17 11:02 AM
            • Time Spent:
              2h
               

              TSR changes for validation, add employee scenarios

            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Kunal Kedari [ kunal.kedari ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Code Review Date 23/Mar/2017
            Code Reviewed By Rohan Khandave [ 11903 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Code Reviewed By Rohan Khandave [ 11903 ] Saurabh Sablaka [ 11909 ]
            Permalink
            saurabh.sablaka Saurabh Sablaka (Inactive) logged work - 23/Mar/17 11:02 AM
            • Time Spent:
              7h
               

              TSR - API changes for validation, new column on employee source, update employee scenarios

            Hide
            Permalink
            saurabh.sablaka Saurabh Sablaka (Inactive) added a comment -

            Updated employee update scenarios from API to validate record in combination of CandidateID+JobID +TourID

            Show
            saurabh.sablaka Saurabh Sablaka (Inactive) added a comment - Updated employee update scenarios from API to validate record in combination of CandidateID+JobID +TourID
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Remaining Estimate 15h [ 54000 ] 13h [ 46800 ]
            Time Spent 32h [ 115200 ] 34h [ 122400 ]
            Worklog Id 33473 [ 33473 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Remaining Estimate 13h [ 46800 ] 11h [ 39600 ]
            Time Spent 34h [ 122400 ] 36h [ 129600 ]
            Worklog Id 33474 [ 33474 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Remaining Estimate 11h [ 39600 ] 4h [ 14400 ]
            Time Spent 36h [ 129600 ] 43h [ 154800 ]
            Worklog Id 33475 [ 33475 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint NF Sprint 6 [ 47 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked higher
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            Hide
            Permalink
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            We are done with the testing of this change on Stage. Marking status as "Production Deployment on Hold".

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - We are done with the testing of this change on Stage. Marking status as "Production Deployment on Hold".
            prasadp Prasad Pise (Inactive) made changes -
            Link This issue relates to NF-52 [ NF-52 ]
            prasadp Prasad Pise (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            Permalink
            kunal.kedari Kunal Kedari (Inactive) logged work - 25/Apr/17 11:04 AM
            • Time Spent:
              1.5h
               

              Testing on Production

            kunal.kedari Kunal Kedari (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 2.5h [ 9000 ]
            Time Spent 43h [ 154800 ] 44.5h [ 160200 ]
            Worklog Id 41299 [ 41299 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Hide
            Permalink
            kunal.kedari Kunal Kedari (Inactive) added a comment -

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

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Verified the change on Production, working as expected. Closing the ticket.
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Saurabh Sablaka (Inactive) made transition -
            New Request Pending for Approval
            		1d 20h 11m 1
            Saurabh Sablaka (Inactive) made transition -
            Pending for Approval Approved for Development
            		6s 1
            Saurabh Sablaka (Inactive) made transition -
            Approved for Development In Development
            		2s 1
            Saurabh Sablaka (Inactive) made transition -
            In Development In LB Testing
            		11d 20h 57m 1
            Kunal Kedari (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		23d 6h 25m 1
            Kunal Kedari (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		7s 1
            Kunal Kedari (Inactive) made transition -
            Approved for Stage Stage Testing
            		2s 1
            Kunal Kedari (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		17d 17h 46m 1
            Kunal Kedari (Inactive) made transition -
            Pending for Production Approval Approved for production
            		4s 1
            Kunal Kedari (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Kunal Kedari (Inactive) made transition -
            In Production Testing Production Complete
            		7s 1
            Kunal Kedari (Inactive) made transition -
            Production Complete Closed
            		3s 1

              People

              Assignee:
              kunal.kedari Kunal Kedari (Inactive)
              Reporter:
              prasadp Prasad Pise (Inactive)
              Developer:
              Rupesh Mandal (Inactive)
              QA:
              Prasad Pise (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 31h Original Estimate - 31h
                  31h
                  Remaining:
                  Time Spent - 44.5h Remaining Estimate - 2.5h
                  2.5h
                  Logged:
                  Time Spent - 44.5h Remaining Estimate - 2.5h
                  44.5h