GJ: Mass update individual parameters in params field groups.

Hi,

I use in GJ Groups different custom params in the following three ways:

1. <input type="text" name="params[gj_custom]" class="form-control" />
2. $myCustomValue = $row->params()->get( 'gj_custom' );
3. Substitutions against these variables [var1_params_gj_custom]
   

Now I want to do mass updates on these kinds of custom GJ params. Is there a way to add or (in case gj_curstom already exist for a group) update the values of such a custumo GJ params with a SQL-query?

With kind regards, Noa

 

They're stored in the params column. There isn't a way to easily mass update them without parsing the JSON, setting the value, then formatting back to JSON. This can be simplified in SQL using JSON_SET if your MySQL version supports it though (minimum MySQL 5.7). See the below documentation regarding JSON_SET.

dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html#function_json-set