forked from looker/block-jira-new
-
Notifications
You must be signed in to change notification settings - Fork 0
/
epic_core.explore.lkml
59 lines (59 loc) · 1.41 KB
/
epic_core.explore.lkml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
explore: epic_core {
extension: required
join: issue {
type: left_outer
sql_on: ${epic.id} = ${issue.epic_link} ;;
relationship: one_to_many
}
join: issue_type {
type: left_outer
sql_on: ${issue.id} = ${issue_type.id} ;;
relationship: many_to_one
}
join: priority {
type: left_outer
sql_on: ${issue.priority} = ${priority.id} ;;
relationship: many_to_one
}
join: issue_board {
fields: []
type: left_outer
sql_on: ${issue_board.issue_id} = ${issue.id} ;;
relationship: one_to_many
}
join: board {
type: left_outer
sql_on: ${issue_board.board_id} = ${board.id} ;;
relationship: one_to_many
}
join: sprint {
type: left_outer
sql_on: ${board.id} = ${sprint.board_id} ;;
relationship: many_to_one
}
join: sla {
type: left_outer
sql_on: ${issue.id} = ${sla.issue_id} ;;
relationship: many_to_one
}
join: status {
type: left_outer
sql_on: ${issue.status} = ${status.id} ;;
relationship: many_to_one
}
join: resolution {
type: left_outer
sql_on: ${issue.resolution} = ${resolution.id} ;;
relationship: many_to_one
}
join: status_category {
type: left_outer
sql_on: ${status.status_category_id} = ${status_category.id} ;;
relationship: many_to_one
}
join: worklog {
type: left_outer
sql_on: ${issue.id} = ${worklog.issue_id} ;;
relationship: one_to_many
}
}