Fix usages of postgreSQL UNIX timestamp convertion for opigno_statistics

Created on 22 July 2022, over 2 years ago
Updated 16 October 2023, about 1 year ago

Problem/Motivation

Fix UNIX_TIMESTAMP() and WEEK() functions for pgsql

πŸ› Bug report
Status

Needs review

Version

3.0

Component

Code

Created by

πŸ‡ΊπŸ‡¦Ukraine niko-

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡²πŸ‡½Mexico luisnicg

    I applied the patch and after a few days of testing the team found that the charts don't reflect the current trainings, I found that the patch considered the "completed" day although this is field calculated based on the "status" parameter.

    Not sure if the patch was created properly but at least I hope this helps to someone else with similar issues.

    BTW thanks so much for the patch, it literally saved my day.

Production build 0.71.5 2024