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