I would like to view my merged pull request history in Bitbucket.
How do I query Bitbucket to show me only those merged pull requests where I am the author?
In the user interface, for each repository, you can check the pull requests for that repository and filter by author and status.
If you are looking for pull requests across multiple repositories, you can try the All Pull Requests add on. However, this add on does not allow to filter by user and will display the pull requests for every author.
The /rest/api/1.0/dashboard/pull-requests REST API allows more sophisticated filtering. From the endpoint documentation:
Retrieve a page of pull requests where the current authenticated user is involved as either a reviewer, author or a participant. The request may be filtered by pull request state, role or participant status.
Caterina - Atlassian
I also would like to see the history of all PRs over the multiples repos under a project.
A couple of use cases:
#1 Not rarely a new feature of a system has commits, hence PRs, in different repos. For example, the front-end and one or more micro-services in the back-end. Being able to see PRs from multiple repos, possibly filtering by some attribute such as words in the PR's title and description, can help track what was approved/merged and when.
#2 Derived from #1, if we need to track a bug introduced by a given merge in a repo, I'd like to find the related PRs merged on other repos
#3 Find all PRs a given team member (possibly myself) has been assigned, approved, rejected, etc... over multiple repos.
You can check out this blog post https://stiltsoft.com/blog/2020/11/how-to-export-commit-and-pull-request-data-from-bitbucket-to-csv/
It describes different ways of exporting engineering data to CSV for further processing and organization.
You can also check out Awesome Graphs for Bitbucket if you need to retrieve and export commit and pull request data to CSV on global, project, repository, and user levels, using the dedicated resources.