konck2 opened a new issue, #8241: URL: https://github.com/apache/incubator-devlake/issues/8241
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened Syncing data in Devlake doesn't update `merged_date` and `closed_date` from `pull_requests` table when pull request has been closed -> reopened -> merged. ### What do you expect to happen `merged_date` and `closed_date` to be updated when Devlake sync job runs. ### How to reproduce 1. Create PR within GitHub 2. Close it without merging 3. Run Devlake sync job 4. Reopen PR 5. Merge it 6. Run Devlake sync job ### Anything else `pull_request` table entry within `lake` database (MySQL): | updated_at | created_date | merged_date | closed_date | | -------- | ------- | ------- | ------- | 2024-12-16 00:20:36.776 | 2024-11-26 13:32:32.000 | NULL | 2024-11-27 08:04:46.000 GitHub API entry: "created_at": "2024-11-26T13:32:32Z", "updated_at": "2024-12-03T08:50:29Z", "closed_at": "2024-12-03T08:50:27Z", "merged_at": "2024-12-03T08:50:27Z", ### Version 1.0.2-beta4 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: dev-unsubscr...@devlake.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org