SQL:
SELECT coupon_rule_name as "Gutscheinname", coupon_code as "Code", concat_ws(' ', customer_firstname, customer_lastname) as "Name", customer_email as "E-Mail", DATE_FORMAT(created_at, '%d.%m.%Y') as "Datum" FROM sales_flat_order WHERE coupon_code IS NOT NULL ORDER BY created_at DESC
Magento: 1.9.2.4 Custom Reports: 0.1.11
SQL:
SELECT coupon_rule_name as "Gutscheinname", coupon_code as "Code", concat_ws(' ', customer_firstname, customer_lastname) as "Name", customer_email as "E-Mail", DATE_FORMAT(created_at, '%d.%m.%Y') as "Datum" FROM sales_flat_order WHERE coupon_code IS NOT NULL ORDER BY created_at DESC
Grid Configuration:
{"filterable":{"Gutscheinname": "adminhtml/widget_grid_column_filter_text","Datum": "adminhtml/widget_grid_column_filter_date"}}
Filter does not working - also not in the sample reports.