How to get column name of changed cell


i need help to get the name of column, which i am manipulating. is it possible to get it?
you can see related area in the pic.

i need that key, not value.

Can you use the lodash keys method?


that does not work.

i can get it but staticly like


i am trying to catch the changes and push it into my audit table. like

INSERT INTO mr_audit_log_retool (entity_id, table_name, field_name, previous_value, new_value)
  ('{{table1.changesetArray[0].buchungId}}', '{{}}', '{{table1.selectedCell.columnId}}'
, '{{table1.selectedCell.value}}', '{{table1.changesetObject[1].buchungEnde}}');

but there are some handicaps. that does not have a dynamic structure

  1. there is no loop to get all changes from changesetArray
  2. column name (field_name), previous value and new value are catched staticly.

That isn't how to use the lodash function though:

I think when you get the right column name out of the changesetArray with


you'll get more traction with the SQL statement.
(eta: fixed the missing [0] in the changesetArray)


I also wanted to add an example of the loop you can use for the changesetArray:

This way you can make sure to grab all the changes from any column that require further processing

many thanks @pyrrho

@pyrrho i meant, i need to loop sql query

for example i have table1, it has 3 columns. if user changes every cell under that columns, changesetObject can catch them, and if i loop that object for everychanges and integrate it with my sql query, then i can insert everychanges into my another table. i mean i want to run mysql query based on the size of changesetObject and for each loop i want to inject next value of changesetOject. here is MySqlQuery.

INSERT INTO mr_audit_log_retool (entity_id, 
  x=>x.buchungId === table1.changesetArray[0].buchungId)[Object.keys(table1.changesetObject[1])[0]]}}', 

but does not return anything.
and here is MyJavaScriptQuery

let obj= table1.changesetObject[1];

const orgs = await new Promise((resolve) => {
    additionalScope: {
      field_name: Object.keys(table1.changesetObject[1])[0]
    onSuccess: (data) => {

return orgs;

but does not return anything