summaryrefslogtreecommitdiffstats
path: root/test/fixtures/queries.yml
blob: a49f82fbbc91331574f12f27e85ea00e9a1e7012 (plain)
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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
--- 
queries_001: 
  id: 1
  project_id: 1
  is_public: true
  name: Multiple custom fields query
  filters: |
    --- 
    cf_1: 
      :values: 
      - MySQL
      :operator: "="
    status_id: 
      :values: 
      - "1"
      :operator: o
    cf_2: 
      :values: 
      - "125"
      :operator: "="

  user_id: 1
  column_names: 
queries_002: 
  id: 2
  project_id: 1
  is_public: false
  name: Private query for cookbook
  filters: |
    --- 
    tracker_id: 
      :values: 
      - "3"
      :operator: "="
    status_id: 
      :values: 
      - "1"
      :operator: o

  user_id: 3
  column_names: 
queries_003: 
  id: 3
  project_id: 
  is_public: false
  name: Private query for all projects
  filters: |
    --- 
    tracker_id: 
      :values: 
      - "3"
      :operator: "="

  user_id: 3
  column_names: 
queries_004: 
  id: 4
  project_id: 
  is_public: true
  name: Public query for all projects
  filters: |
    --- 
    tracker_id: 
      :values: 
      - "3"
      :operator: "="

  user_id: 2
  column_names: 
queries_005: 
  id: 5
  project_id: 
  is_public: true
  name: Open issues by priority and tracker
  filters: |
    --- 
    status_id: 
      :values: 
      - "1"
      :operator: o

  user_id: 1
  column_names: 
  sort_criteria: |
    --- 
    - - priority
      - desc
    - - tracker
      - asc
queries_006: 
  id: 6
  project_id: 
  is_public: true
  name: Open issues grouped by tracker
  filters: |
    --- 
    status_id: 
      :values: 
      - "1"
      :operator: o

  user_id: 1
  column_names: 
  group_by: tracker
  sort_criteria: |
    --- 
    - - priority
      - desc
queries_007: 
  id: 7
  project_id: 2
  is_public: true
  name: Public query for project 2
  filters: |
    --- 
    tracker_id: 
      :values: 
      - "3"
      :operator: "="

  user_id: 2
  column_names: 
queries_008: 
  id: 8
  project_id: 2
  is_public: false
  name: Private query for project 2
  filters: |
    --- 
    tracker_id: 
      :values: 
      - "3"
      :operator: "="

  user_id: 2
  column_names: 
queries_009: 
  id: 9
  project_id: 
  is_public: true
  name: Open issues grouped by list custom field
  filters: |
    --- 
    status_id: 
      :values: 
      - "1"
      :operator: o

  user_id: 1
  column_names: 
  group_by: cf_1
  sort_criteria: |
    --- 
    - - priority
      - desc