| Subject: | Database utility - Improve Validations when creating databases |
| Summary: | Database utility - create a new database. Prevent users from entering a "." dot in the database name. Dots in the DB name causes errors in generating crystal reports. |
| Audit Notes: | Edited by sanjay on 25/02/21 08:52. Edited by alvis on 07/12/20 13:25. |
| 07 Dec 2020 | 08:31AM Comment 1 by Sanjay (Link Technologies) Case L12082 added to project 12.3 |
| 07 Dec 2020 | 01:25PM Comment 2 by Alvis (Link Technologies) ETC was changed from 14/11/2020 to 14/11/2020 |
| 09 Dec 2020 | 02:11PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 09-12-2020 05:04 PM Time Taken: 4.00 |
| Development work for this case has been completed. The change will be available in version:12.30.1209 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - Added the following REGEX for DATABASE name validation: ^[\p{L}_][\p{L}\p{N}@$#_]{0,127}$
- Max Length is 127 characters
- Only some special characters are allowed based on MS docs reference
2. Affected Areas: - Build a new database
3. The issue was caused by: - Added validations
4. Notes:
5. Next Step: UAT ---------------------- Development Reference: |
|
| 23 Dec 2020 | 04:16PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-12-2020 08:13 PM Time Taken: 1.00 |
| System test completed |
|
| 29 Dec 2020 | 01:39PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 29-12-2020 05:17 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 | No | Test Description | Pass/Fail | | 1 | Create a "New" and "Demo" database with the name as "LinkSOFT.2021". This should not be created | Pass | | 2 | Create a "New" and "Demo" database with the name as "LinkSOFT_2021". This should be created
| Pass | | 3 | Create a "New" and "Demo" database with the name as "LinkSOFT&2021". This should be created
| Pass | | 4 | Create a database with the name having 125 characters. This should be created | Pass | | 5 | Create a database with the name having 128 characters. This should not be created
| Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 12.30.1224BETA
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-123
Next Step: - For Documentation
|
|
| 29 Dec 2020 | 04:00PM Comment 6 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-12-2020 07:59 PM |
| Documentation is not required. |
|
| 04 Jan 2021 | 03:24PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 04-01-2021 07:24 PM |
| Thanks Rashna |
|