Page MenuHomePhabricator

D18860.diff
No OneTemporary

D18860.diff

diff --git a/src/applications/maniphest/controller/ManiphestReportController.php b/src/applications/maniphest/controller/ManiphestReportController.php
--- a/src/applications/maniphest/controller/ManiphestReportController.php
+++ b/src/applications/maniphest/controller/ManiphestReportController.php
@@ -75,6 +75,7 @@
$conn = $table->establishConnection('r');
$joins = '';
+ $create_joins = '';
if ($project_phid) {
$joins = qsprintf(
$conn,
@@ -84,6 +85,12 @@
PhabricatorEdgeConfig::TABLE_NAME_EDGE,
PhabricatorProjectObjectHasProjectEdgeType::EDGECONST,
$project_phid);
+ $create_joins = qsprintf(
+ $conn,
+ 'JOIN %T p ON p.src = t.phid AND p.type = %d AND p.dst = %s',
+ PhabricatorEdgeConfig::TABLE_NAME_EDGE,
+ PhabricatorProjectObjectHasProjectEdgeType::EDGECONST,
+ $project_phid);
}
$data = queryfx_all(
@@ -113,8 +120,9 @@
// default value.
$create_rows = queryfx_all(
$conn,
- 'SELECT dateCreated FROM %T',
- id(new ManiphestTask())->getTableName());
+ 'SELECT t.dateCreated FROM %T t %Q',
+ id(new ManiphestTask())->getTableName(),
+ $create_joins);
foreach ($create_rows as $key => $create_row) {
$create_rows[$key] = array(
'transactionType' => 'status',

File Metadata

Mime Type
text/plain
Expires
Mon, Nov 11, 3:02 AM (1 d, 22 h ago)
Storage Engine
blob
Storage Format
Encrypted (AES-256-CBC)
Storage Handle
6735195
Default Alt Text
D18860.diff (1 KB)

Event Timeline