Company: Link Technologies
Case No: L12156. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on 05 Feb 2021 05:15PM
Priority: High
Product: Framework
Group: Software Defect
Time Taken: 19.00 (Weight: 19.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay
Resolve By: Friday, 05 February 2021 11:59 PM [1176 days since logged date]
Status: Closed
Subject: Emails should not be sent to users that are "NOT APPROVED", or users that are in the "Email Exclusion list"
Summary:    

Emails in LinkSOFT should not be sent to users that are "Not Approved" or in the "Email Subscription Exclusion" list.

Design:

  1. Add a category in Menu "Company Administration ~> Email Subscription"  form called "All Emails"
  2. Create a function that determines if an email address is "Ok to send emails to". this can be determined by:
    1. Email in "Email Exclusion List" under Type: "All Emails"
    2. Email in "Email Exclusion List" under Type of Email (We can extend this to all alerts at a later stage)
    3. Email belongs to a user that is not approved
  3. When emails are collected for processing, we check if the email address can be used. If the address cannot be used, we should:
    1. Do not send this email
    2. Mark the Email as "Closed" with a note saying "Email is in the Exclusion List. Review menu: "Company Administration ~> Email Subscription". Emails are not sent to users that are "Not Approved"
Audit Notes:Edited by sanjay on 25/02/21 08:43. Edited by sanjay on 05/02/21 17:15. Edited by sanjay on 05/02/21 15:15. Edited by sanjay on 05/02/21 15:14. Edited by sanjay on 05/02/21 11:11. Edited by sanjay on 05/02/21 11:11. 
05 Feb 202111:11AM Comment 1 by Sanjay (Link Technologies) ETC was changed from 05/02/2021 to 05/02/2021
05 Feb 202102:47PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 05-02-2021 06:34 PM Time Taken: 16.00

PART A - Development work for this case has been completed.

1. The change will be available in version: 12.30.0205

2. The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Added a new Email Type called "All Emails"
  2. Added code to Email Notifications to prevent emails being sent to emails in the "Email Exclusion List"
  3. Added code to Email Reports to prevent emails being sent to emails in the "Email Exclusion List"
  4. Email Exclusion List is made up of:
    1. Email address is attached to a user that is NOT APPROVED
    2. Email Address is in the "Company Administration ~> Email Subscription"
  5. Exclusion list may cause the "To Email Address" to become Blank. Emails to BLANK "To Addresses" will not be sent

3. Affected Areas:

  1. All Email Notifications
  2. All Report Email Log

4. The issue was caused by:

  1. Security Issue - Users receiving emails even if they un-subscribe or have been made inactive

5. Notes: We will need to change the source alerts to prevent the insert into the Notifications table and the insert into the Report Email Schedules.
6. Next Step
: UAT then Copy case and assign to 12.4

----------------------

PART B - Development Reference:

1. Changes implemented was according to the approved design (Y/N):

2. Variations to the approved design:


10 Feb 202102:11PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 10-02-2021 05:23 PM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Enable the helpdesk alert "HEL002"

The email should be sent to users E013 and E029 as they have actioned cases.

Pass
2

Mark the user E029 as unapproved. Re-run the process for the helpdesk alert "HEL002".

The email should be only sent to user E013 

Pass
3

UnSubscribe from the alert in 2 above for user E013.

Re-run the process for the helpdesk alert "HEL002". The email should not be sent to user E013

Retest in the build as users were unable to unsubscribe.
4

Schedule the "Asset Listing" report and enter the email address for user E013 in the "To Address".

A user account is not approved for E013, the email should not be sent

The email log details status is updated to "Close", but the header still reads "Ready to Send". Can we update the status on the header as well?


5

Exclusion list may cause the "To Email Address" to become Blank. Emails to BLANK "To Addresses" will not be sent

Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.30.0209BETA
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-123

Next Step

  1. For Review

    12 Feb 202101:25PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-02-2021 05:24 PM
    Hi Rashna, can you test this in the current GA build? thx

    12 Feb 202103:42PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-02-2021 07:11 PM Time Taken: 1.00
    QA Results
    Tests carried out according to requirements specified on the case header

    Test Results Summary

    Table 1 - Summarised list of issues
    NoTest DescriptionPass/Fail
    1UnSubscribe user E013 from the alert in HEL002. This should update the "Email Subscription"
    Pass
    2

    Schedule the "Asset Listing" report and enter the email address for user E013 in the "To Address".User account is not approved for E013, the email should not be sent

    Pass, 

    Unapproved users do not appear in the user list to schedule the report.

    Email is not sent to unapproved users.


    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 12.30.0211GA
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-123

    Next Step

    1. For Closure

      12 Feb 202104:22PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-02-2021 08:22 PM Time Taken: 1.00 Notes: Created from the WEB using email sent to: sanjay@linktechnologies.com.au
      Thanks Rashna

      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12156 in the subject line of all emails regarding this issue.

      Document size: 79.8 KB
      For call complaints, please contact the Managing Director of the company using this form