Table of Contents | ||||
---|---|---|---|---|
|
...
Data Source type | Table |
---|---|
Task Tracking System | Ticket |
TicketHistory | |
Worklog | |
Sprints | |
Releases | |
Version Control | Branch |
Commit | |
PullRequest | |
Tag |
...
Code Block |
---|
select * from ticket_snapshots(
ARRAY['EPMTEST-0001', 'EPMTEST-0003'],
'month'
) |
Mapping Azure DevOps Board with Ticket table
...
Table | Condition |
---|---|
Ticket JOIN with | |
TicketHistory | Ticket.id=TicketHistory.workitem_id |
Worklog | Ticket.id=Worklog.workitem_id |
Sprint | Sprint.id=any(Ticket.sprints) |
Release | Release.id=any(Ticket.fix_releases) |
TicketHistory JOIN with | |
Ticket | TicketHistory.workitem_id=Ticket.id |
Worklog | TicketHistory.workitem_id=Worklog.workitem_id |
Sprint | Based on situation |
Release | Based on situation |
Worklog JOIN with | |
Ticket | Worklog.workitem_id=Ticket.id |
TicketHistory | Worklog.workitem_id=TicketHistory.workitem_id |
Sprint | Based on situation |
Release | Based on situation |
Sprint JOIN with | |
Ticket | Sprint.id=any(Ticket.sprints) |
TicketHistory | Based on situation |
Worklog | Based on situation |
...