madiha
January 29, 2016, 3:48am
1
in v5 is it possible to pass parameter for time (from and to) inorder to retrieve report for hourly bases.
Meaning my client want item sale report from a specific time like item sale during peak period or happy hour or hourly basis.
can this be done in v5 ?
thanks
There isnt a Order time expression in the report tag in detail topic but thats getting old now so not sure if its been added since then.
Order table has a date column so should be fairly easily doable with sql.
Jesse
January 29, 2016, 3:15pm
3
Yes its possible and it could be done with input using Report Widget, Editor Widget and a custom Entity Screen.
Jesse
January 29, 2016, 3:21pm
4
This is a starting place.
For next version I’ve added Format Time (FT) function support to V5 reports so you can create something like that.
[ORDERS:1, 1, 1,1]
>Time|Order Count|Total|Percent
{REPORT ORDER DETAILS:FT([O.Time],'hh'),O.Id.Count,O.Total.Sum,O.Total.Percent}
[image]
1 Like