Details

    • Type: New Feature
    • Status: Done
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: CBAT Offer Letter - Fall
    • Labels:
      None

      Description

      API will rerturn candidate data (System & Custom Fields) from DMS

       

        Attachments

        1. CP1.JPG
          CP1.JPG
          25 kB
        2. CP2.JPG
          CP2.JPG
          20 kB
        3. DMS-1547- Details.doc
          32 kB
        4. DMS-1547- Details - V2.doc
          24 kB
        5. Pre-prod_1547_CBES.jpg
          Pre-prod_1547_CBES.jpg
          229 kB
        6. Pre-prod_1547.jpg
          Pre-prod_1547.jpg
          219 kB
        7. Screenshot (3560).png
          Screenshot (3560).png
          173 kB
        8. Screenshot (3561).png
          Screenshot (3561).png
          218 kB
        9. Screenshot (3565).png
          Screenshot (3565).png
          165 kB
        10. Screenshot (3566).png
          Screenshot (3566).png
          220 kB
        11. Screenshot (3567).png
          Screenshot (3567).png
          224 kB

          Activity

          samir Samir created issue -
          samir Samir made changes -
          Field Original Value New Value
          Fix Version/s CBAT Offer Letter - Fall [ 10607 ]
          samir Samir made changes -
          Epic Link DMS-473 [ 75966 ]
          samir Samir made changes -
          Sprint DMS - Fall Sprint 6 [ 165 ]
          samir Samir made changes -
          Remaining Estimate 16h [ 57600 ]
          Original Estimate 16h [ 57600 ]
          samir Samir made changes -
          Sprint DMS - Fall Sprint 6 [ 165 ] DMS - Fall Sprint 7 [ 166 ]
          samir Samir made changes -
          Assignee Samir [ samir ] Rohan J Khandave [ rohan.khandave ]
          samir Samir made changes -
          Assignee Rohan J Khandave [ rohan.khandave ] Ramya Tantry [ ramya.tantry ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Summary Changes in Candidate Profile Get API Changes in Candidate Profile API
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Hi Samir,

          Please provide the Candidate Profile API details where these changes are to be done.

          CC:Rohan J Khandave

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Samir , Please provide the Candidate Profile API details where these changes are to be done. CC: Rohan J Khandave
          ramya.tantry Ramya Tantry (Inactive) logged work - 09/Jul/19 06:34 AM
          • Time Spent:
            1h
             

            API analysis and discussion with Rohan

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ] 15h [ 54000 ]
          Time Spent 1h [ 3600 ]
          Worklog Id 187256 [ 187256 ]
          samir Samir made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Akash Thakur [ akash.thakur ]
          samir Samir made changes -
          Assignee Akash Thakur [ akash.thakur ] Ramya Tantry [ ramya.tantry ]
          Hide
          samir Samir added a comment -

          Hi Shamooka Mohapatra

          Mapped fields with their change data.

          If 10 fields are mapped and data changed for 2 then only 2 mapped fields change data

          Regards,

          Samir

          Show
          samir Samir added a comment - Hi Shamooka Mohapatra Mapped fields with their change data. If 10 fields are mapped and data changed for 2 then only 2 mapped fields change data Regards, Samir
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment DMS-1547- Details.doc [ 112618 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Hi Samir,

          As per our discussion in today's call, Please refer DMS-1547- Details.doc for sample responses.

          I have listed queries as well in the document for which your input/discussion is needed. Once our approach is finalized I will analyze and update the estimates.

          As discussed, this Jira is only related to returning candidate data (System & Custom Fields) from DMS. Hence updating the description.

          CC:Rohan J Khandave,Ganesh Sadawarte

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Samir , As per our discussion in today's call, Please refer  DMS-1547- Details.doc  for sample responses. I have listed queries as well in the document for which your input/discussion is needed. Once our approach is finalized I will analyze and update the estimates. As discussed, this Jira is only related to returning candidate data (System & Custom Fields) from DMS. Hence updating the description. CC: Rohan J Khandave , Ganesh Sadawarte
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Description API will rerturn candidate data (System & Custom Fields) from DMS

          API will accept candidate data (system & Custom fields) update in DMS
          API will rerturn candidate data (System & Custom Fields) from DMS

           
          ramya.tantry Ramya Tantry (Inactive) logged work - 16/Jul/19 04:58 AM - edited
          • Time Spent:
            5h
             

            Analysis

            Document preparation

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 15h [ 54000 ] 9.5h [ 34200 ]
          Time Spent 1h [ 3600 ] 6.5h [ 23400 ]
          Worklog Id 188658 [ 188658 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 9.5h [ 34200 ] 10h [ 36000 ]
          Time Spent 6.5h [ 23400 ] 6h [ 21600 ]
          Worklog Id 188658 [ 188658 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment DMS-1547- Details - V2.doc [ 112725 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Hi Samir,

          PFA Updated Document as per our discussion over call - DMS-1547- Details - V2.doc

          CC: Rohan J Khandave, Ganesh Sadawarte

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Samir , PFA Updated Document as per our discussion over call -  DMS-1547- Details - V2.doc CC: Rohan J Khandave , Ganesh Sadawarte
          ramya.tantry Ramya Tantry (Inactive) logged work - 17/Jul/19 05:36 AM
          • Time Spent:
            5h
             

            Document changes

            History details fetching analysis

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 10h [ 36000 ] 5h [ 18000 ]
          Time Spent 6h [ 21600 ] 11h [ 39600 ]
          Worklog Id 188935 [ 188935 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Task Details and Estimate breakdown
          A. Fetch history details - 20h
          1. Generic logic for all tables in code but process needs to handled Table wise.
          2. Tables - Person, Assignment, PersonCustomAttribute, AssignmentCustomAttribute, users, Address, phone, Email, Webtype
          B. Validation logic for Sourceproduct and documentid - 4h
          C. Fetch source field ids - 4h
          D. Fetch dms field names for original resultant set - 4h
          E. Create object as per sourcefield and its value - 6h
          F. Test cases writing and Performance testing - 10h
          G. Unit testing - 4h
          H. Code review - 4h

          Total Estimate : 56 hrs.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Task Details and Estimate breakdown A. Fetch history details - 20h 1. Generic logic for all tables in code but process needs to handled Table wise. 2. Tables - Person, Assignment, PersonCustomAttribute, AssignmentCustomAttribute, users, Address, phone, Email, Webtype B. Validation logic for Sourceproduct and documentid - 4h C. Fetch source field ids - 4h D. Fetch dms field names for original resultant set - 4h E. Create object as per sourcefield and its value - 6h F. Test cases writing and Performance testing - 10h G. Unit testing - 4h H. Code review - 4h Total Estimate : 56 hrs.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ] 61h [ 219600 ]
          Original Estimate 16h [ 57600 ] 72h [ 259200 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 18/Jul/19 06:04 AM
          • Time Spent:
            7h
             

            Analysis of fetching History details from SP
            Discussion with Swapnil
            Analysis of creating generic function for fetching history details

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 61h [ 219600 ] 54h [ 194400 ]
          Time Spent 11h [ 39600 ] 18h [ 64800 ]
          Worklog Id 189311 [ 189311 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 18/Jul/19 09:04 PM - edited
          • Time Spent:
            5h
             

            Code changes for fetching history details

          samir Samir made changes -
          Sprint DMS - Fall Sprint 7 [ 166 ] DMS - Fall Sprint 8 [ 167 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 54h [ 194400 ] 49h [ 176400 ]
          Time Spent 18h [ 64800 ] 23h [ 82800 ]
          Worklog Id 189998 [ 189998 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Worklog Id 189998 [ 189998 ]
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Hello Ramya Tantry,

          As per discussion in call with Shamooka Mohapatra & Alex. CBATS needs only mapped fields which are having CBATS source fields ids into DMS.

          Thanks,
          RohanK

          CC – Samir , Satya

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Hello Ramya Tantry , As per discussion in call with Shamooka Mohapatra & Alex. CBATS needs only mapped fields which are having CBATS source fields ids into DMS. Thanks, RohanK CC – Samir , Satya
          ramya.tantry Ramya Tantry (Inactive) logged work - 22/Jul/19 05:21 AM
          • Time Spent:
            7h
             

            Code changes
            Creating triggers for company,person,address,assignment,users
            Fetch source field ids
            Fetch dms field names for original resultant set

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 49h [ 176400 ] 42h [ 151200 ]
          Time Spent 23h [ 82800 ] 30h [ 108000 ]
          Worklog Id 190450 [ 190450 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment DMS-1547- Details - V2.doc [ 112725 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment DMS-1547- Details - V2.doc [ 114119 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment CP1.JPG [ 114229 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment CP2.JPG [ 114230 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          API Details :
          API URL : api/candidateProfile/{emailAddress}/{sourceProduct}/{documentid}

          HTTP Verb : GET
          Responses:
          1. Last updated mapped document details provided with source field id for CBATS
          Input: api/candidateProfile/ramya.tantry@careerbuilder.com/CBATS/9793
          Output:

          2. All mapped fields details provided for given document id for source product other than CBATS
          Input : api/candidateProfile/ramya.tantry@careerbuilder.com/WORKTERRA/9575
          Output :

           

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - API Details : API URL : api/candidateProfile/{emailAddress}/{sourceProduct}/{documentid} HTTP Verb : GET Responses: 1. Last updated mapped document details provided with source field id for CBATS Input: api/candidateProfile/ramya.tantry@careerbuilder.com/CBATS/9793 Output : 2. All mapped fields details provided for given document id for source product other than CBATS Input : api/candidateProfile/ramya.tantry@careerbuilder.com/WORKTERRA/9575 Output :  
          ramya.tantry Ramya Tantry (Inactive) logged work - 23/Jul/19 05:27 AM
          • Time Spent:
            8h
             

            Unit testing

            Code changes

            Test case writing

            Discussion with Rohan

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 42h [ 151200 ] 34h [ 122400 ]
          Time Spent 30h [ 108000 ] 38h [ 136800 ]
          Worklog Id 190739 [ 190739 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Hi Samir,

          Please refer my earlier comment for sample responses. Also refer DMS-1547- Details - V2.doc for additional information related to API.

          Assigning this Jira to you for code review.

          Note : Triggers are prerequisite for this and it is assumed that Triggers and History tables are created for all tables.

          CC: Rohan J Khandave

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Samir , Please refer my earlier comment for sample responses. Also refer  DMS-1547- Details - V2.doc  for additional information related to API. Assigning this Jira to you for code review. Note : Triggers are prerequisite for this and it is assumed that Triggers and History tables are created for all tables. CC: Rohan J Khandave
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Samir [ samir ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 24/Jul/19 04:26 AM
          • Time Spent:
            7h
             

            Code changes

            Unit testing

            Create branch and PR

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 34h [ 122400 ] 27h [ 97200 ]
          Time Spent 38h [ 136800 ] 45h [ 162000 ]
          Worklog Id 190988 [ 190988 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 27h [ 97200 ] 15h [ 54000 ]
          Original Estimate 72h [ 259200 ] 60h [ 216000 ]
          samir Samir made changes -
          Assignee Samir [ samir ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Code Review [ 11801 ] In Progress [ 3 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 15h [ 54000 ] 25h [ 90000 ]
          Original Estimate 60h [ 216000 ] 70h [ 252000 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 26/Jul/19 05:56 AM
          • Time Spent:
            7.5h
             

            Code review changes
            DIscussion with Rohan and Swapnil

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 25h [ 90000 ] 17.5h [ 63000 ]
          Time Spent 45h [ 162000 ] 52.5h [ 189000 ]
          Worklog Id 191585 [ 191585 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 29/Jul/19 05:52 AM
          • Time Spent:
            6.5h
             

            Code changes
            Unit test case writing
            Testing

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 17.5h [ 63000 ] 11h [ 39600 ]
          Time Spent 52.5h [ 189000 ] 59h [ 212400 ]
          Worklog Id 191924 [ 191924 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 29/Jul/19 09:45 PM
          • Time Spent:
            0.5h
             

            PR updation

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 11h [ 39600 ] 10.5h [ 37800 ]
          Time Spent 59h [ 212400 ] 59.5h [ 214200 ]
          Worklog Id 192053 [ 192053 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Status Code Review [ 11801 ] In QA Testing [ 11901 ]
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Priya Dhamande [ priya.dhamande ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment Pre-prod_1547_CBES.jpg [ 114842 ]
          Attachment Pre-prod_1547.jpg [ 114843 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Verified on Pre-prod.
          CBAT Response :

          Other Response :

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Verified on Pre-prod. CBAT Response : Other Response :
          ramya.tantry Ramya Tantry (Inactive) logged work - 30/Jul/19 05:42 AM
          • Time Spent:
            1.25h
             

            Discussion with Rohan and Sonali

            Pre-prod testing

             

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 10.5h [ 37800 ] 9.25h [ 33300 ]
          Time Spent 59.5h [ 214200 ] 60.75h [ 218700 ]
          Worklog Id 192157 [ 192157 ]
          priya.dhamande Priya Dhamande (Inactive) logged work - 01/Aug/19 06:01 AM
          • Time Spent:
            2h
             

            Analysis
            Test cases
            Preprod verification
            Discussion with Ramya

          priya.dhamande Priya Dhamande (Inactive) made changes -
          Remaining Estimate 9.25h [ 33300 ] 7.25h [ 26100 ]
          Time Spent 60.75h [ 218700 ] 62.75h [ 225900 ]
          Worklog Id 192739 [ 192739 ]
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Preprod - OneIm
          Browser: FF and Chrome
          API: /api/candidateProfile/

          {emailAddress}

          /

          {sourceProduct}

          /

          {documentid}

          Scenarios:
          1. CBAT User
          2. CBES User
          3. Onboard user
          4. User not matching with document.

          All scenarios worked as expected. So, marking jira done.

          Sachin Hingole Hrishikesh Deshpande Rohan J Khandave Samir

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Preprod - OneIm Browser: FF and Chrome API: /api/candidateProfile/ {emailAddress} / {sourceProduct} / {documentid} Scenarios: 1. CBAT User 2. CBES User 3. Onboard user 4. User not matching with document. All scenarios worked as expected. So, marking jira done. Sachin Hingole Hrishikesh Deshpande Rohan J Khandave Samir
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Screenshot (3563).png [ 115164 ]
          Attachment Screenshot (3562).png [ 115165 ]
          Attachment Screenshot (3561).png [ 115166 ]
          Attachment Screenshot (3560).png [ 115167 ]
          Attachment Screenshot (3567).png [ 115168 ]
          Attachment Screenshot (3566).png [ 115169 ]
          Attachment Screenshot (3565).png [ 115170 ]
          Attachment Screenshot (3564).png [ 115171 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Screenshot (3564).png [ 115171 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Screenshot (3562).png [ 115165 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Screenshot (3563).png [ 115164 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Ramya Tantry [ ramya.tantry ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Status Done [ 10001 ] In QA Testing [ 11901 ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Priya Dhamande [ priya.dhamande ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          To Do In Progress
          24d 18h 7m 1
          Ramya Tantry (Inactive) made transition -
          Code Review In Progress
          1d 16h 19m 1
          Ramya Tantry (Inactive) made transition -
          In Progress Code Review
          12d 9h 39m 2
          Ashwin Wankhede (Inactive) made transition -
          Code Review In QA Testing
          2h 39m 1
          Raj Hawaldar (Inactive) made transition -
          Done In QA Testing
          26d 16h 59m 1
          Priya Dhamande (Inactive) made transition -
          In QA Testing Done
          24d 10h 53m 2

            People

            Assignee:
            priya.dhamande Priya Dhamande (Inactive)
            Reporter:
            samir Samir
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 70h
                70h
                Remaining:
                Time Spent - 62.75h Remaining Estimate - 7.25h
                7.25h
                Logged:
                Time Spent - 62.75h Remaining Estimate - 7.25h
                62.75h