Company: Link Technologies
Case No: L12835. Project: 14.50: LinkSOFT Version 14.50 - March 2023
Logged By: Sanjay (Link Technologies) on 02 Feb 2023 04:12PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 51.00 (Weight: 20.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Friday, 10 February 2023 09:06 AM [453 days since logged date]
Status: Closed
Subject: Email validation for LinkSOFT to be Configurable
Summary:    

The standard Email validation requires the last group to contain between 2 and 4 characters. One of our clients has an email to 5 characters in the last group of the email. E.g. TEST@abc.group

To allow for this, we will add a configurable REGEX for Emails.

The following areas are affected:

  1. Create User
  2. ESS Customer Maintenance
  3. Employee Maintenance
  4. Employee Profile
  5. Training and Development - Instructor Maintenance
  6. User Maintenance
  7. Email Log
  8. Email BI Reports
  9. Email Subscriptions
  10. Maintain Company
  11. Maintain Organisations
  12. Schedule Reports
  13. Contact Us
Audit Notes:Edited by sanjay on 03/02/23 15:02. Edited by sanjay on 02/02/23 16:12. 
02 Feb 202301:59PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-02-2023 10:55 AM Time Taken: 22.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.50

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

  1. Added configuration for "EmailValidationRegex" Default Value: ^([\w+-.%]+@[\w-.]+\.[A-Za-z]{2,10};?)+$
  2. The following areas are affected:
    1. Create New User
    2. ESS Customer Maintenance (Time Management ~> Time Setup)
    3. Employee Maintenance
    4. Contact Us Email
    5. Survey
    6. Applicant Profile
    7. Vacancy Application
    8. User Maintenance
    9. Email Log
    10. Report Email Log
    11. Email Subscription
    12. Maintain Company
    13. Maintain Organisation
    14. Report Schedule
    15. Public - Contact Us

3. Affected Areas:

  1. See 2. above

4. The issue was caused by:

  1. Centralised Email validation and made it configurable

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


PART B -
Development Reference (Place descriptor for objects changed)
:

  1. Added a Configuration for Username validation
  2. Cleaned up Password Regex Validation and Message

03 Feb 202303:02PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-02-2023 09:06 AM Time Taken: 29.00 Notes: ETC extended from: 01/04/2023 to 10/02/2023
The following tests were performed:

Test Setup Instructions:
  1. Create Edit all forms with a Valid Email Address
  2. Remove Validation and Repeat 1 above
Table 1 - Test Results

PART A - Use the standard REGEX and ensure INVALID Emails cannot be added or EDITED

  1. Create New User - Pass
  2. ESS Customer Maintenance (Time Management ~> Time Setup) - Pass
  3. Employee Maintenance - Pass
  4. Contact Us Email - Pass
  5. Survey - Pass 
  6. Applicant Profile - Pass 
  7. Vacancy Application - Pass 
  8. User Maintenance - Pass 
  9. Email Log - Pass  
  10. Report Email Log - Pass   
  11. Email Subscription - Pass   
  12. Maintain Company - Pass   
  13. Maintain Organisation - Pass   
  14. Report Schedule - Pass   
  15. Public - Contact Us - Pass   

PART A - REMOVE the standard REGEX and ensure INVALID Emails CAN be added or EDITED

  1. Create New User - Pass
  2. ESS Customer Maintenance (Time Management ~> Time Setup) - Pass
  3. Employee Maintenance - Pass
  4. Contact Us Email - Pass
  5. Survey - Pass 
  6. Applicant Profile - Pass 
  7. Vacancy Application - Pass 
  8. User Maintenance - Pass with a known issue. User Maintenance does a NOT NET EMail Validation on top of the REGEX validation.
  9. Email Log - Pass  
  10. Report Email Log - Pass   
  11. Email Subscription - Pass   
  12. Maintain Company - Pass   
  13. Maintain Organisation - Pass   
  14. Report Schedule - Pass   
  15. Public - Contact Us - Pass   

Environment Details

  1. OS version: Win11
  2. Application version: 14.
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


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

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