Document Management SystemProject Type: software

Document Management System

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

Document completion email shows a different From email address (Circor)

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Company:
      All Clients/Multiple Clients

      Description

      Document completion email shows a different From email address (Circor)

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          narendra.kumar Narendra Kumar created issue -
          narendra.kumar Narendra Kumar made changes -
          Field Original Value New Value
          Rank Ranked higher
          narendra.kumar Narendra Kumar made changes -
          Attachment DMS-2299.png [ 150776 ]
          narendra.kumar Narendra Kumar made changes -
          Assignee Samir [ samir ] Narendra Kumar [ narendra.kumar ]
          narendra.kumar Narendra Kumar made changes -
          Comment [ Hi [~harshveer.singh]

          Please run the below query to fix this issue.

          {{UPDATE  emailtemplate}}
          {{SET     FromAddress = REPLACE(FromAddress, '}}{{[workterra.net|http://dms.workterra.net/]}}{{', '}}{{[careerbuilder.com|http://dms.careerbuilder.com/]}}{{'),}}
          {{        BodyText = REPLACE(BodyText, '}}{{[workterra.net|http://dms.workterra.net/]}}{{', '}}{{[careerbuilder.com|http://dms.careerbuilder.com/]}}{{')}}
          {{WHERE   FromAddress LIKE '%}}{{[workterra.net|http://dms.workterra.net/]}}{{%' }}
          {{OR      BodyText LIKE '%}}{{[workterra.net|http://dms.workterra.net/]}}{{%';}}

          {{}}

          {{cc: [~samir]}}

          {{}}

          {{}} ]
          Hide
          Permalink
          narendra.kumar Narendra Kumar added a comment -

          Hi Harshveer Singh
          Please run the below query to fix this issue.

          UPDATE emailtemplate
          SET FromAddress = REPLACE(FromAddress, 'workterra.net', 'careerbuilder.com'),
          BodyText = REPLACE(BodyText, 'workterra.net', 'careerbuilder.com')
          WHERE FromAddress LIKE '%workterra.net%'
          OR BodyText LIKE '%workterra.net%';

          cc: Samir

          Show
          narendra.kumar Narendra Kumar added a comment - Hi Harshveer Singh Please run the below query to fix this issue. UPDATE emailtemplate SET FromAddress = REPLACE(FromAddress, 'workterra.net', 'careerbuilder.com'), BodyText = REPLACE(BodyText, 'workterra.net', 'careerbuilder.com') WHERE FromAddress LIKE '%workterra.net%' OR BodyText LIKE '%workterra.net%'; cc: Samir
          narendra.kumar Narendra Kumar made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          Permalink
          narendra.kumar Narendra Kumar logged work - 13/Jul/20 11:02 PM
          • Time Spent:
            0.5h
             

            Prepared the query to fix this issue.

          narendra.kumar Narendra Kumar made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 253621 [ 253621 ]
          Hide
          Permalink
          narendra.kumar Narendra Kumar added a comment -

          Hi Samir

          I have executed the query on both stage and production environment, so this is fixed now.

           

          Show
          narendra.kumar Narendra Kumar added a comment - Hi Samir I have executed the query on both stage and production environment, so this is fixed now.  
          narendra.kumar Narendra Kumar made changes -
          Status In Progress [ 3 ] In QA Testing [ 11901 ]
          Permalink
          narendra.kumar Narendra Kumar logged work - 15/Jul/20 04:37 AM
          • Time Spent:
            1h
             

            executed query on the prod and tested it.

          narendra.kumar Narendra Kumar made changes -
          Time Spent 0.5h [ 1800 ] 1.5h [ 5400 ]
          Worklog Id 253876 [ 253876 ]
          narendra.kumar Narendra Kumar made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          Transition Time In Source Status Execution Times
          Narendra Kumar made transition -
          To Do In Progress
          		21h 52m 1
          Narendra Kumar made transition -
          In Progress In QA Testing
          		1d 4h 57m 1
          Narendra Kumar made transition -
          In QA Testing Done
          		20d 20h 57m 1

            People

            Assignee:
            narendra.kumar Narendra Kumar
            Reporter:
            narendra.kumar Narendra Kumar
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 1.5h
                1.5h