[GitHub] [incubator-devlake] Startrekzky commented on issue #4524: [Bug][GitHub dashboard] Outdated SQL queries due to PR status changes

["Startrekzky (via GitHub)" <gi...@apache.org>]

Startrekzky commented on issue #4524:
URL: https://github.com/apache/incubator-devlake/issues/4524#issuecomment-1449742096

   This bug happened because we changed GitHub collection method from GitHub REST APIs to GraphQL APIs in v0.15. The PR statuses changed.
   
   Each data source has its own PR statuses：
   - GitHub PR (from REST APIs): open, closed；
   - GitHub PR (from GraphQL APIs): OPEN, CLOSED, MERGED
   - GitLab MR: opened, closed, merged;
   - BitBucket PR: declined ( state=DECLINED ), open ( state=OPEN ) or merged ( state=MERGED )
   - Azure PR: succeeded, failed, pending, notSet, notApplicable, or error
   
   Since DevLake v0.16 hasn't standardized the PR statuses from different data sources. The solution to this issue is to modify the SQLs in Grafana so they can identify all `closed` or `merged` PRs from the above data sources. cc. @abeizn 


-- 
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: commits-unsubscribe@devlake.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org