Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Date range filter #73

Open
antoniosemeraroF opened this issue Mar 11, 2017 · 1 comment
Open

Date range filter #73

antoniosemeraroF opened this issue Mar 11, 2017 · 1 comment

Comments

@antoniosemeraroF
Copy link

antoniosemeraroF commented Mar 11, 2017

Is it possible to set a specific date range filter?
For example, the SQL query is:
`select
count(mg_sales_flat_shipment.order_id) as 'NumeroOrdiniSpediti',
sum(mg_sales_flat_order.base_grand_total) as 'TotaleSpedito',
concat(DAY(mg_sales_flat_shipment.created_at), '-',MONTH(mg_sales_flat_shipment.created_at)) as 'Data'

FROM mg_sales_flat_shipment
left join mg_sales_flat_order on mg_sales_flat_order.entity_id = mg_sales_flat_shipment.order_id

group by day(mg_sales_flat_shipment.created_at)`

I want filter the result in a date range.
In the grid configuration, i put this:
{
"filterable": {"Data": "adminhtml/widget_grid_column_filter_date"}
}
But the filter doesn't work.

Thanks

@dtamajon
Copy link

widget_grid_column_filter_date does not "understand" dates in format d-m. In that case, you should write your own grid column filter.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants