This topic is locked

Audit table Truncates Old and New data values

5/2/2018 4:24:26 PM
ASPRunner.NET General questions
N
nfgcgrb author

Is there a way to prevent the Audit feature from truncating old and new data when tracking field modifications?

I'm sending to a table, the description field size doesn't appear to be the issue, it seems to truncate field by field being updated.
It seems to truncate @ around 300-350 characters, I'd like to capture the complete data set, does anyone know where this is controlled and how to increase it?

admin 5/4/2018

Need more info on this? What makes you think it is truncated? Can we see this on Demo Account?

N
nfgcgrb author 5/8/2018



Need more info on this? What makes you think it is truncated? Can we see this on Demo Account?


Original Data value:

Candidates for this position must meet requirements specified in ANSI/ANS Standards and Regulatory Guidelines. In addition site Technical Specifications, FSAR, or procedures may contain additional requirements. Hiring Managers are required to submit attachment 9.1 from EN-HR-137 for any candidate selected for this job. Candidates must meet or exceed ANSI/ANS 3.1-1978. ANSI Section 4.5.2- Technicians: The standard specifies this as Journeymen Level Personnel. Minimum of 3 years of working experience in their specialty. Minimum of 1 year of the experience should be related technical training. High degree of manual dexterity. Individuals in training or apprentice positions are not considered technicians or maintenance personnel for purposes of defining qualifications in ANSI/ANS 3.1 section 4 'Qualification,' but are permitted to perform work for which qualification has been demonstrated.
Value in the Description Data in the Audit table: Database datatype = Text cuts off the old at 301 char

---Keys

DataKey : 1749

---Fields

ANSI_Description [old]:

Candidates for this position must meet requirements specified in ANSI/ANS Standards and Regulatory Guidelines. In addition site Technical Specifications, FSAR, or procedures may contain additional requirements. Hiring Managers are required to submit attachment 9.1 from EN-HR-137 for any candidate se

ANSI_Description [new]:

ANSI/ANS-3. 1-1978 - 4.5.2 - Technicians. Technicians shall have 3 years of working experience in their specialty of which 1 year should be related technical training. They should possess a high degree of manual dexterity and ability and should be capable of learning and applying basic skills.