There is a field column in the js_res_record table that seems to hold all the field data for a record in json format. There is also a js_res_record_values table that holds the values of fields along with more information that what is in the json data.
I have a situation where I need to change the value of one specific field of a certain record via a script. Do I need to update that value in both the json data as well as in the record values table? What is the purpose of these two places for the same information?
Question
Announcement
Conversation
Idea
Praise
Problem
Reviewed
Open
There is a field column in the js_res_record table that seems to hold all the field data for a record in json format. There is also a js_res_record_values table that holds the values of fields along with more information that what is in the json data.
I have a situation where I need to change the value of one specific field of a certain record via a script. Do I need to update that value in both the json data as well as in the record values table? What is the purpose of these two places for the same information?