Assume that I have customer_code in the
sales_order_detail table. and I have created a view that store this column with increment_id.
How can I query that column into an email template by using increment_id?
I have called
"var order.increment_id |raw":"Order Id" into template. but I don't know how to query the data in the template file.