Startrekzky opened a new issue, #4769: URL: https://github.com/apache/incubator-devlake/issues/4769
### 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 As an engineer, I want to query incident metrics from DevLake faster. ### Description Currently, incidents are stored in table.issues with type = "INCIDENT", which is not that intuitive. This proposal is to store Jira/PagerDuty/ServiceNow incidents in a new table called "incidents" or "ims_incidents" (ims stands for incident management system). If you’re using issue tracking tools like Jira to manage incidents, those incidents will also be stored in table issues with type = "INCIDENT". This means that - [ ] any operations to incidents will directly touch table.ims_incidents - [ ] update the queries to get incidents in the DORA dashboard - [ ] update the "refdiff" plugin about incident-deployment mapping logic - [ ] historical "incidents" from v0.16 or prior versions should be MOVED from "issues" to "ims_incidents" - [ ] update related docs ### 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]
