Company: Link Technologies
Case No: L12142. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on 15 Jan 2021 04:41PM
Priority: High
Product: Framework
Group: Software Defect
Time Taken: 4.00 (Weight: 6.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Sanjay
Resolve By: Monday, 18 January 2021 12:00 AM [1189 days since logged date]
Status: Closed
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:
  1. Int
  2. GUID
  3. String
  4. 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 202104: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 202104: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 202104: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.

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

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