@wadih opened this Issue on January 2nd 2022


Running report from 2021-12-01 to 2021-12-31 returns no data.

However running report from 2021-12-01 to 2021-12-30 returns full data set.

Looks like a bigger or equal conditional logic at play somewhere.


@bx80 commented on January 4th 2022 Contributor

Hi @wadih, thanks for reporting this issue.

When running the report for 2021-12-01 to 2021-12-30 report data is calculated on-demand and then cached since this is a custom date range. But when running the report for 2021-12-01 to 2021-12-31 this date range maps to entire month and so the pre-generated monthly data for December will be used.

As you are not seeing any data for the December month then it seems likely that this monthly data has not been generated for some reason.

You could try invalidating the cached data for December 2021 with

./console core:invalidate-report-data --dates=2021-12-01,2021-12-31 --periods=month --site=[your site id]

and regenerating it with:

./console core:archive

@wadih commented on January 4th 2022

Hi @bx80,

You are right, after running those two commands, it now works.

I had to make console executable first, and it didn't recognize --site, so I ran:

./console core:invalidate-report-data --dates=2021-12-01,2021-12-31 --periods=month
./console core:archive

Thank you so much. I will go ahead and close the ticket.

This Issue was closed on January 4th 2022
Powered by GitHub Issue Mirror