Update
Change-Id: I0148e6e2f30b2306c5386669334d201b85d4ab76
Signed-off-by: Wayne Beaton <wayne.beaton@eclipse-foundation.org>
diff --git a/export/committers.json.php b/export/committers.json.php
index 37665f3..ca3049d 100644
--- a/export/committers.json.php
+++ b/export/committers.json.php
@@ -63,7 +63,7 @@
org.active as OrgActiveDate,
org.inactive as OrgInactiveDate
from People as p
- join PeopleProjects as pp on p.PersonId = pp.PersonId and pp.Relation='CM'
+ left join PeopleProjects as pp on p.PersonId = pp.PersonId and pp.Relation='CM'
left join
(select
pa.PersonId,
@@ -92,7 +92,8 @@
left join OrganizationMemberships as om on o.OrganizationId=om.OrganizationId
) as orgs
group by id
- ) as org on oc.OrganizationId=org.id";
+ ) as org on oc.OrganizationId=org.id
+ where OrganizationId is not null or ProjectId is not null";
$result = $App->foundation_sql($sql);
function addEmail(&$committer, $email) {