Document Management SystemProject Type: software

Document Management System

Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-2434

Testing for encryption changes for Ethnicity, DateOfBirth, LegalId columns

    Details

    • Type: New Feature
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      Below scenarios needs to be tested:

       

      Data in below Person table columns for a use should come as encrypted when mapped in a document:
      Ethnicity, DateOfBirth, LegalId

      After mapping above columns in a document, admin and candidate is able to fill data for above fields, and submit.
      After signing the docuemnt, data in above fields is coming fine.

        Attachments

          Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. DMS-2366 Modify schema to support encryption

          • Medium - Has the potential to affect progress.
          • In QA Testing

          New Feature - A new feature of the product, which has yet to be developed. DMS-2367 Migrate existing data to new encrypted columns

          • Medium - Has the potential to affect progress.
          • In QA Testing

          New Feature - A new feature of the product, which has yet to be developed. DMS-2368 Update all SPs, Indexes to support encryption

          • Medium - Has the potential to affect progress.
          • In QA Testing

          New Feature - A new feature of the product, which has yet to be developed. DMS-2369 Update backend code to manage master key and store company Key in session

          • Medium - Has the potential to affect progress.
          • In QA Testing

          New Feature - A new feature of the product, which has yet to be developed. DMS-2370 Update SP calls to pass company decryption key

          • Medium - Has the potential to affect progress.
          • In QA Testing

          New Feature - A new feature of the product, which has yet to be developed. DMS-2371 Update all insert queries on code to support encryption

          • Medium - Has the potential to affect progress.
          • In QA Testing

          New Feature - A new feature of the product, which has yet to be developed. DMS-2372 Update update queries to support encryption

          • Medium - Has the potential to affect progress.
          • In QA Testing

          New Feature - A new feature of the product, which has yet to be developed. DMS-2373 Update get queries to support encryption

          • Medium - Has the potential to affect progress.
          • In QA Testing

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            poonam.rana poonam.rana (Inactive) added a comment - - edited

            Hello Harshveer Singh,

            I have tested the above scenario multiple times in DMS Workterra. After mapping of fields , submitting and signing the data, it is not Working as Expected. "Legal ID" column is still displaying NULL values.

             

            Thanks,

            Poonam Rana

            Show
            poonam.rana poonam.rana (Inactive) added a comment - - edited Hello Harshveer Singh , I have tested the above scenario multiple times in DMS Workterra. After mapping of fields , submitting and signing the data, it is not Working as Expected . "Legal ID" column is still displaying NULL values.   Thanks, Poonam Rana
            Hide
            Permalink
            harshveer.singh Harshveer Singh (Inactive) added a comment -

            Please check now.

            Show
            harshveer.singh Harshveer Singh (Inactive) added a comment - Please check now.
            Hide
            Permalink
            poonam.rana poonam.rana (Inactive) added a comment - - edited

            Hello Harshveer Singh,

            Data in columns of PERSON table is displaying as expected , I can see encrypted data now for below fields: 

            - Ethnicity,

            • DateOfBirth,
            • LegalId

             

            Marking this card as DONE.

            Show
            poonam.rana poonam.rana (Inactive) added a comment - - edited Hello Harshveer Singh , Data in columns of PERSON table is displaying as expected , I can see encrypted data now for below fields:  - Ethnicity, DateOfBirth, LegalId   Marking this card as DONE.

              People

              Assignee:
              poonam.rana poonam.rana (Inactive)
              Reporter:
              harshveer.singh Harshveer Singh (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1.75h
                  1.75h