vvshulga opened a new pull request, #8147: URL: https://github.com/apache/incubator-devlake/pull/8147
### Summary On some Grafana dashboards we are using 2 date conditions: 1) $__timeFilter(pr.created_date) AND 2) created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH) second function return incorrect dates or dates in the future (especially for short interval <= 7 days). $__timeFilter(date) filters correctly depends on selected date time range. We have to remove this extra condition. ### Does this close any open issues? Closes #8144 ### Other Information Several plugins: AzureDevops, Bamboo, BitBucket, GitHub, Gitlab, Jenkins use the same function DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH) and there is comment [the following condition to remove the month with incomplete data](https://github.com/apache/incubator-devlake/blob/e856b603ef96b62a23c9834dc5ff4b7901115e3b/grafana/dashboards/Bamboo.json#L123), however, it's unclear how it works. This PR does not touch plugins file, it should be clarified further. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
