| Subject: | Primary key serialisation issue in New Devexpress Framework - Primary keys need to be a non serialised value for security reasons |
| Summary: | For security reasons, all grids in the LinkSOFT system needs to have primary keys that are non serialised. Therefore, allowed primary keys are:- Int
- GUID
- String
- and other known data types
Unknown data types are not allowed. Therefore, all Primary key values must have a NON Nullable value. If a null is sent, it needs to have a data type specified. |
| Audit Notes: | Edited by sanjay on 11/02/21 14:04. Edited by sanjay on 11/02/21 14:04. |
| 15 Jan 2021 | 04:43PM Comment 1 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 15-01-2021 08:41 PM Time Taken: 2.00 |
| Correction made to function LT_HEL_CallNumberLookup_fx. The ID field cannot contain a NULL value. By cc: to Alvis. review all Lookups and select statements and ensure a NULL is not returned. Use EMPTY STRING instead. |
|
| 18 Jan 2021 | 04:15PM Comment 2 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-01-2021 07:48 PM Time Taken: 1.00 |
| I have checked all lookups and statements. A NULL value is not used. |
|
| 18 Jan 2021 | 04:44PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-01-2021 08:42 PM Time Taken: 1.00 |
| Thanks Alvis. We will do an end to end system test before final release. |
|