How to get a field's old data back when max length is increased of that field

Amol Pawar
Tera Guru

Hi Experts,

 

I need urgent help here!

I have a field with a max length of 255. The record producer mapped it to this field. Once the user submitted a request, that field was mapped.

After that, I opened that field dictionary and changed the max length to 500. But that field's data (value) is now truncated (reduced). I want that old value of that field back. 

How do you think I could do this?

 

Thanks in advance,

Amol

1 ACCEPTED SOLUTION

@Amol Pawar 

You can try finding your record producer variable value in question_answer table.

If you still have the truncated data there then there is no possibility of getting it.

 

Regards,

Sumanth

View solution in original post

6 REPLIES 6

Hello @Amol Pawar,

 

Can't you update the field value directly now and see if it is getting updated to the expected value.?

 

Kind Regards,

Ravi Chandra 

@Ravi Chandra_K 

His query is what is the expected value.

Before submitting the record:

Record producer variable length 500

Mapped field in table length 255

Value entered by user in variable more than 255

 

Now when he opened the field in table he can see only 255 chars and remaining got truncated.

Then he changed the field in table max length to 500 and he want the lost text