dosubot[bot] commented on issue #8365: URL: https://github.com/apache/incubator-devlake/issues/8365#issuecomment-2757569771
<!-- Greeting --> Hey @gsaivenkateshzs! I'm here to help you with any bugs, questions, or contributions. Let's work together to solve this! <!-- Answer --> To retrieve all commits associated with a specific branch from the DevLake database, you can use the following SQL query: ```sql SELECT c.sha, c.message, c.author_name, c.author_email, c.authored_date FROM ref_commits rc JOIN commits c ON rc.new_commit_sha = c.sha WHERE rc.new_ref_id = 'your_branch_name'; ``` Replace `'your_branch_name'` with the specific branch name you are interested in. This query joins the `ref_commits` and `commits` tables to get all commits associated with the specified branch <sup>[[1]](https://github.com/apache/incubator-devlake-website/blob/main/docs/DataModels/DevLakeDomainLayerSchema.md)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/df1e0644-fafb-486c-8921-68a4eeedd42c?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/df1e0644-fafb-486c-8921-68a4eeedd42c?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/df1e0644-fafb-486c-8921-68a4eeedd42c?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/df1e0644-fafb-486c-8921-68a4eeedd42c?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/df1e0644-fafb-486c-8921-68a4eeedd42c?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/df1e0644-fafb-486c-8921-68a4eeedd42c?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/df1e0644-fafb-486c-8921-68a4eeedd42c?feedback_type=other)</sup> -- 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
