Gergő Tisza has uploaded a new change for review.
https://gerrit.wikimedia.org/r/146158
Change subject: Fix action logging SQL query
......................................................................
Fix action logging SQL query
Follow-up for Ia68a0ec5df629b8d4d8221a87bca5a777463d6f5
Change-Id: I2506e0c0cee695fdd8ea05a36b7ac40121ab1c94
---
M actions/template.sql
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia
refs/changes/58/146158/1
diff --git a/actions/template.sql b/actions/template.sql
index 8ef6bc7..e040ac6 100644
--- a/actions/template.sql
+++ b/actions/template.sql
@@ -41,7 +41,7 @@
SELECT timestamp, event_action, event_samplingFactor FROM
MediaViewer_8935662
WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND
timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY))
UNION ALL
- SELECT timestamp, (CASE WHEN event_value = 0 THEN
'pref-optout-loggedin' else 'pref-optin-loggedin') as event_action, 1 as
event_samplingFactor FROM PrefUpdate_5563398 WHERE event_property =
'multimediaviewer-enable'
+ SELECT timestamp, (CASE WHEN event_value = 0 THEN
'pref-optout-loggedin' ELSE 'pref-optin-loggedin' END) AS event_action, 1 AS
event_samplingFactor FROM PrefUpdate_5563398 WHERE event_property =
'multimediaviewer-enable'
) AS MediaViewerUnioned
GROUP BY datestring
--
To view, visit https://gerrit.wikimedia.org/r/146158
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I2506e0c0cee695fdd8ea05a36b7ac40121ab1c94
Gerrit-PatchSet: 1
Gerrit-Project: analytics/multimedia
Gerrit-Branch: master
Gerrit-Owner: Gergő Tisza <gti...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
