I want to run a mysql query as a mass action, the trigger is after order update. I tried to use the fields of the current order but no success.
For example this is an SQL:
insert into amim_test (test_text) values(order_id)
or
insert into amim_test (test_text) values(product_id)
result is and error: Unknown column 'order_id' in 'field list'.
How can I use the values from the result of the trigger?
I want to save some data from the order into a table. The examples are test SQLs only.
I need at least the userid of the customer, but prefer to learn how to use all available fields.