Aklapper has uploaded a new change for review. https://gerrit.wikimedia.org/r/292149
Change subject: Adjust "monthly Phab community metrics" SQL query to upstream changes ...................................................................... Adjust "monthly Phab community metrics" SQL query to upstream changes "Projects which had at least one task moved from one column to another on their workboard" was incorrectly 0 in https://lists.wikimedia.org/pipermail/wikitech-l/2016-June/085810.html as the transactionType string value was changed in https://secure.phabricator.com/D15637 Bug: T136667 Change-Id: I5418479c05a3a2b27ae54b5e04c60d956162e70c --- M modules/phabricator/templates/community_metrics.sh.erb 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/49/292149/1 diff --git a/modules/phabricator/templates/community_metrics.sh.erb b/modules/phabricator/templates/community_metrics.sh.erb index 35c2b53..b84c833 100644 --- a/modules/phabricator/templates/community_metrics.sh.erb +++ b/modules/phabricator/templates/community_metrics.sh.erb @@ -46,7 +46,7 @@ #echo "result_projectsboardmove" result_projectsboardmove=$(MYSQL_PWD=${sql_pass} /usr/bin/mysql -h $sql_host -u$sql_user $sql_name << END -SELECT COUNT(DISTINCT (edge.dst)) FROM phabricator_maniphest.edge INNER JOIN phabricator_maniphest.maniphest_transaction WHERE FROM_UNIXTIME(maniphest_transaction.dateModified,'%Y%m')=date_format(NOW() - INTERVAL 1 MONTH,'%Y%m') AND maniphest_transaction.transactionType = "projectcolumn" AND edge.type = 41 AND edge.src = maniphest_transaction.objectPHID AND edge.dst = SUBSTR(maniphest_transaction.newValue, INSTR(maniphest_transaction.newValue, 'projectPHID')+14, 30); +SELECT COUNT(DISTINCT (edge.dst)) FROM phabricator_maniphest.edge INNER JOIN phabricator_maniphest.maniphest_transaction WHERE FROM_UNIXTIME(maniphest_transaction.dateModified,'%Y%m')=date_format(NOW() - INTERVAL 1 MNOTH,'%Y%m') AND maniphest_transaction.transactionType = "core:columns" AND edge.type = 41 AND edge.src = maniphest_transaction.objectPHID AND edge.dst = SUBSTR(maniphest_transaction.newValue, INSTR(maniphest_transaction.newValue, 'PHID-PROJ-'), 30); END ) -- To view, visit https://gerrit.wikimedia.org/r/292149 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I5418479c05a3a2b27ae54b5e04c60d956162e70c Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Aklapper <aklap...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits