How we store the Record Producer Fields details in table contain field as json/script.

Kumari Divya
Giga Guru

Hi @LL

 I created 1 Record Producer on Test Case table in PDI

KumariDivya_0-1708103100080.png

Now i want to stored the Record Producer Field details-Test Case Number in table-Test Case in Field Test Result which is script type or Json when user Submitted the Record on Form.

 

KumariDivya_1-1708103423591.png

Please suggest on this  how we stored the Fields details in json format in Table.

 

Thanks in advance

Divya Kumari

8 REPLIES 8

What's output of the above code and what is expected output in JSON format.

replace the line position of "var testResult1= {};" on top.

 

 

 

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

Anand Kumar P
Giga Patron
Giga Patron

Hi @Kumari Divya ,

In Record producer script add below script

var testCaseNumber = producer.test_case_number;

var jsonDetails = {
"testCaseNumber": testCaseNumber;
};

current.test_fieldset= JSON.stringify(jsonDetails);

 

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

Hi @Anand Kumar P 

Thanks for the script but its now working.

 

Thanks 

Divya

Hi @Kumari Divya ,
Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand