Hello everyone ,
I need to create a custom event that triggers when the status of the customer order is closed .
My problem is that I can’t find state column ( sql column for status ) in the list of column available in customer_order_tab .
PS : I can find it in the view but not in the table
Does anyone have an idea how to get it ?
Thank you in advance.
Hanane
The view’s “state” column is coming from the “rowstate” column in the Customer_Order_Tab table.
Hi
You could also use Application defined event ORDER_STATUS_CHANGE without creating a new custom event ;)
Thank you both for the replies .
I used rowstate but I get this error , do you have an idea how to resolve it .
Thank you
Hi
For me your code looks ok :|
Do you have any custom attributes in the event which points to customer_order?
Otherwise, my suggestion is to use the ORDER_STATUS_CHANGE event. It’s not based on a trigger and you should be able to get the work done.
Hope it helps!
Damith
hi Damith ,
Thank you , I removed the custom attribute and it worked for me !
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.