You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by "abeizn (via GitHub)" <gi...@apache.org> on 2023/03/02 11:07:00 UTC
[GitHub] [incubator-devlake] abeizn opened a new issue, #4574: [Bug][webhook] webhook board id can not match project_mapping row_id
abeizn opened a new issue, #4574:
URL: https://github.com/apache/incubator-devlake/issues/4574
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.
### What happened
POST to register an incident, the board id is: webhook:connectionID:boardKey
![image](https://user-images.githubusercontent.com/101256042/222410730-9e19465f-bac8-49d7-a376-edd8c2c5765d.png)
but the project mapping row id is: webhook:connectionID
![image](https://user-images.githubusercontent.com/101256042/222410936-2a3e8ca4-1568-475c-8be2-61da91d1ac37.png)
so, When the project and board are associated, there will be a mismatch.
```
select
*
from issues i
join board_issues bi on i.id = bi.issue_id
join boards b on bi.board_id = b.id
join project_mapping pm on **b.id = pm.row_id**
where
pm.project_name in ('sonarqube')
```
### What do you expect to happen
so, When the project and board are associated correctly.
### How to reproduce
post a issue by webhook
### Anything else
_No response_
### Version
main
### Are you willing to submit PR?
- [X] 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: commits-unsubscribe@devlake.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-devlake] likyh closed issue #4574: [Bug][webhook] webhook board id can not match project_mapping row_id
Posted by "likyh (via GitHub)" <gi...@apache.org>.
likyh closed issue #4574: [Bug][webhook] webhook board id can not match project_mapping row_id
URL: https://github.com/apache/incubator-devlake/issues/4574
--
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