oguzgu opened a new issue, #8660:
URL: https://github.com/apache/incubator-devlake/issues/8660

   ### Search before asking
   
   - [x] I had searched in the 
[issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and 
found no similar feature requirement.
   
   
   ### Use case
   
   _No response_
   
   ### Description
   
   Currently, the Bitbucket Cloud plugin collects Pull Request metadata (title, 
author, merge status), but it does not collect the reviewer status (e.g., 
APPROVED, CHANGES_REQUESTED / NEEDS_WORK).
   
   I am trying to calculate metrics like "Review Quality" or "Change Request 
Rate" (percentage of PRs that required changes before merging). However, 
checking the database reveals that this data is missing in both raw and tool 
layers.
   
   The Problem
   I checked the _tool_bitbucket_pull_requests table, and there is no column 
for reviewer status.
   
   I checked the _raw_bitbucket_api_pull_requests table to see the raw JSON 
response. The data column contains author, closed_by, and comment_count, but it 
does NOT contain the reviewers or participants list with their statuses.
   
   ```
   {
     "type": "pullrequest",
     "id": 2441,
     "state": "MERGED",
     "author": { ... },
     "closed_by": { ... },
     "comment_count": 11
     // "reviewers" or "participants" array is missing here
   }
   ```
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to