diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-23 21:07:03 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-23 21:07:03 +0200 |
| commit | 3f09fc30e8fe32f25f3efa4ac4e0b8d5ca10ba06 (patch) | |
| tree | 559fb9a13ad0bbda0e293371369a91920d0a9ae1 | |
| parent | 7f6bae2af6042cb71124acb40e97c6a0b7fde8dc (diff) | |
| download | cruncher-3f09fc30e8fe32f25f3efa4ac4e0b8d5ca10ba06.tar.gz cruncher-3f09fc30e8fe32f25f3efa4ac4e0b8d5ca10ba06.zip | |
add dimension_on=global to builds
| -rw-r--r-- | crunch_global.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/crunch_global.sql b/crunch_global.sql index 4c2f00c..d7123b9 100644 --- a/crunch_global.sql +++ b/crunch_global.sql @@ -63,7 +63,8 @@ JOIN `build` ON `build`.`name` = 'all' OR ( `build`.`item_3` IS NOT NULL OR `participant_stats`.`item_grants` RLIKE CONCAT(:build_regex_start, `build`.`item_3`, ';', `build`.`item_3_count`, :build_regex_end) AND `build`.`item_4` IS NOT NULL OR `participant_stats`.`item_grants` RLIKE CONCAT(:build_regex_start, `build`.`item_4`, ';', `build`.`item_4_count`, :build_regex_end) AND `build`.`item_5` IS NOT NULL OR `participant_stats`.`item_grants` RLIKE CONCAT(:build_regex_start, `build`.`item_5`, ';', `build`.`item_5_count`, :build_regex_end) AND - `build`.`item_6` IS NOT NULL OR `participant_stats`.`item_grants` RLIKE CONCAT(:build_regex_start, `build`.`item_6`, ';', `build`.`item_6_count`, :build_regex_end) + `build`.`item_6` IS NOT NULL OR `participant_stats`.`item_grants` RLIKE CONCAT(:build_regex_start, `build`.`item_6`, ';', `build`.`item_6_count`, :build_regex_end) AND + `build`.`dimension_on` = 'global' ) -- counters |