dosubot[bot] commented on issue #7851: URL: https://github.com/apache/incubator-devlake/issues/7851#issuecomment-2271361543
<!-- Greeting --> Hello, @caioq! I'm here to help you with any bugs, questions, or contributions you might have. Let's work together to solve any issues you're facing. <!-- Answer --> The issue you're experiencing with pull requests not being updated correctly, specifically with `merged_date` and `closed_date` fields remaining empty and the status still showing as OPEN, can be due to several factors: 1. **Null Fields for Unmerged/Unclosed PRs**: The `merged_date` and `closed_date` fields are null when the PR is not recognized as merged or closed in the datasource. This can happen if the data transformation or mapping process does not correctly update these fields <sup>[[1]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.16/DataModels/DevLakeDomainLayerSchema.md)</sup>. 2. **GraphQL Query Fields**: Ensure that the GraphQL queries used to fetch pull request data include the necessary fields (`merged_date` and `closed_date`). The `convertGithubPullRequest` function in the code confirms that these fields are included <sup>[[2]](https://github.com/apache/incubator-devlake/blob/main/backend/plugins/github_graphql/tasks/pr_extractor.go)</sup>. 3. **Configuration Settings**: Verify that your blueprint configurations are correct. Specific settings, such as the use of GraphQL APIs, personal access token permissions, and scope configurations, can affect data collection and extraction <sup>[[3]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.19/Configuration/GitHub.md)</sup>. 4. **Logs and Error Messages**: Check for any logs or error messages that might indicate issues with the data transformation or mapping process. Errors during regular expression compilation, JSON unmarshalling, or pull request conversion can lead to incomplete data updates <sup>[[2]](https://github.com/apache/incubator-devlake/blob/main/backend/plugins/github_graphql/tasks/pr_extractor.go)</sup>. Review these aspects to ensure that the pull request data is being correctly collected and updated. If the issue persists, further investigation into the specific configurations and logs may be necessary. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- 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 For queries about this service, please contact Infrastructure at: us...@infra.apache.org