Mercurial > hg > soundsoftware-site
annotate test/fixtures/queries.yml @ 1519:afce8026aaeb redmine-2.4-integration
Merge from branch "live"
| author | Chris Cannam |
|---|---|
| date | Tue, 09 Sep 2014 09:34:53 +0100 |
| parents | 261b3d9a4903 |
| children |
| rev | line source |
|---|---|
| Chris@0 | 1 --- |
| Chris@0 | 2 queries_001: |
| Chris@0 | 3 id: 1 |
| Chris@1464 | 4 type: IssueQuery |
| Chris@0 | 5 project_id: 1 |
| Chris@1464 | 6 visibility: 2 |
| Chris@0 | 7 name: Multiple custom fields query |
| Chris@0 | 8 filters: | |
| Chris@0 | 9 --- |
| Chris@0 | 10 cf_1: |
| Chris@0 | 11 :values: |
| Chris@0 | 12 - MySQL |
| Chris@0 | 13 :operator: "=" |
| Chris@0 | 14 status_id: |
| Chris@0 | 15 :values: |
| Chris@0 | 16 - "1" |
| Chris@0 | 17 :operator: o |
| Chris@0 | 18 cf_2: |
| Chris@0 | 19 :values: |
| Chris@0 | 20 - "125" |
| Chris@0 | 21 :operator: "=" |
| Chris@0 | 22 |
| Chris@0 | 23 user_id: 1 |
| Chris@0 | 24 column_names: |
| Chris@0 | 25 queries_002: |
| Chris@0 | 26 id: 2 |
| Chris@1464 | 27 type: IssueQuery |
| Chris@0 | 28 project_id: 1 |
| Chris@1464 | 29 visibility: 0 |
| Chris@0 | 30 name: Private query for cookbook |
| Chris@0 | 31 filters: | |
| Chris@0 | 32 --- |
| Chris@0 | 33 tracker_id: |
| Chris@0 | 34 :values: |
| Chris@0 | 35 - "3" |
| Chris@0 | 36 :operator: "=" |
| Chris@0 | 37 status_id: |
| Chris@0 | 38 :values: |
| Chris@0 | 39 - "1" |
| Chris@0 | 40 :operator: o |
| Chris@0 | 41 |
| Chris@0 | 42 user_id: 3 |
| Chris@0 | 43 column_names: |
| Chris@0 | 44 queries_003: |
| Chris@0 | 45 id: 3 |
| Chris@1464 | 46 type: IssueQuery |
| Chris@0 | 47 project_id: |
| Chris@1464 | 48 visibility: 0 |
| Chris@0 | 49 name: Private query for all projects |
| Chris@0 | 50 filters: | |
| Chris@0 | 51 --- |
| Chris@0 | 52 tracker_id: |
| Chris@0 | 53 :values: |
| Chris@0 | 54 - "3" |
| Chris@0 | 55 :operator: "=" |
| Chris@0 | 56 |
| Chris@0 | 57 user_id: 3 |
| Chris@0 | 58 column_names: |
| Chris@0 | 59 queries_004: |
| Chris@0 | 60 id: 4 |
| Chris@1464 | 61 type: IssueQuery |
| Chris@0 | 62 project_id: |
| Chris@1464 | 63 visibility: 2 |
| Chris@0 | 64 name: Public query for all projects |
| Chris@0 | 65 filters: | |
| Chris@0 | 66 --- |
| Chris@0 | 67 tracker_id: |
| Chris@0 | 68 :values: |
| Chris@0 | 69 - "3" |
| Chris@0 | 70 :operator: "=" |
| Chris@0 | 71 |
| Chris@0 | 72 user_id: 2 |
| Chris@0 | 73 column_names: |
| Chris@0 | 74 queries_005: |
| Chris@0 | 75 id: 5 |
| Chris@1464 | 76 type: IssueQuery |
| Chris@0 | 77 project_id: |
| Chris@1464 | 78 visibility: 2 |
| Chris@0 | 79 name: Open issues by priority and tracker |
| Chris@0 | 80 filters: | |
| Chris@0 | 81 --- |
| Chris@0 | 82 status_id: |
| Chris@0 | 83 :values: |
| Chris@0 | 84 - "1" |
| Chris@0 | 85 :operator: o |
| Chris@0 | 86 |
| Chris@0 | 87 user_id: 1 |
| Chris@0 | 88 column_names: |
| Chris@0 | 89 sort_criteria: | |
| Chris@0 | 90 --- |
| Chris@0 | 91 - - priority |
| Chris@0 | 92 - desc |
| Chris@0 | 93 - - tracker |
| Chris@0 | 94 - asc |
| Chris@0 | 95 queries_006: |
| Chris@0 | 96 id: 6 |
| Chris@1464 | 97 type: IssueQuery |
| Chris@0 | 98 project_id: |
| Chris@1464 | 99 visibility: 2 |
| Chris@0 | 100 name: Open issues grouped by tracker |
| Chris@0 | 101 filters: | |
| Chris@0 | 102 --- |
| Chris@0 | 103 status_id: |
| Chris@0 | 104 :values: |
| Chris@0 | 105 - "1" |
| Chris@0 | 106 :operator: o |
| Chris@0 | 107 |
| Chris@0 | 108 user_id: 1 |
| Chris@0 | 109 column_names: |
| Chris@0 | 110 group_by: tracker |
| Chris@0 | 111 sort_criteria: | |
| Chris@0 | 112 --- |
| Chris@0 | 113 - - priority |
| Chris@0 | 114 - desc |
| Chris@0 | 115 queries_007: |
| Chris@0 | 116 id: 7 |
| Chris@1464 | 117 type: IssueQuery |
| Chris@0 | 118 project_id: 2 |
| Chris@1464 | 119 visibility: 2 |
| Chris@0 | 120 name: Public query for project 2 |
| Chris@0 | 121 filters: | |
| Chris@0 | 122 --- |
| Chris@0 | 123 tracker_id: |
| Chris@0 | 124 :values: |
| Chris@0 | 125 - "3" |
| Chris@0 | 126 :operator: "=" |
| Chris@0 | 127 |
| Chris@0 | 128 user_id: 2 |
| Chris@0 | 129 column_names: |
| Chris@0 | 130 queries_008: |
| Chris@0 | 131 id: 8 |
| Chris@1464 | 132 type: IssueQuery |
| Chris@0 | 133 project_id: 2 |
| Chris@1464 | 134 visibility: 0 |
| Chris@0 | 135 name: Private query for project 2 |
| Chris@0 | 136 filters: | |
| Chris@0 | 137 --- |
| Chris@0 | 138 tracker_id: |
| Chris@0 | 139 :values: |
| Chris@0 | 140 - "3" |
| Chris@0 | 141 :operator: "=" |
| Chris@0 | 142 |
| Chris@0 | 143 user_id: 2 |
| Chris@0 | 144 column_names: |
| Chris@0 | 145 queries_009: |
| Chris@0 | 146 id: 9 |
| Chris@1464 | 147 type: IssueQuery |
| Chris@0 | 148 project_id: |
| Chris@1464 | 149 visibility: 2 |
| Chris@0 | 150 name: Open issues grouped by list custom field |
| Chris@0 | 151 filters: | |
| Chris@0 | 152 --- |
| Chris@0 | 153 status_id: |
| Chris@0 | 154 :values: |
| Chris@0 | 155 - "1" |
| Chris@0 | 156 :operator: o |
| Chris@0 | 157 |
| Chris@0 | 158 user_id: 1 |
| Chris@0 | 159 column_names: |
| Chris@0 | 160 group_by: cf_1 |
| Chris@0 | 161 sort_criteria: | |
| Chris@0 | 162 --- |
| Chris@0 | 163 - - priority |
| Chris@0 | 164 - desc |
| Chris@0 | 165 |