Revision 48139
Added by Alessia Bardi almost 7 years ago
| queryProjectContactperson.sql | ||
|---|---|---|
| 1 |
SELECT distinct
|
|
| 2 |
po.project,
|
|
| 3 |
po.contactperson,
|
|
| 4 |
po.startdate,
|
|
| 5 |
po.enddate,
|
|
| 6 |
po.inferred,
|
|
| 7 |
po.deletedbyinference,
|
|
| 8 |
po.trust,
|
|
| 9 |
po.inferenceprovenance,
|
|
| 10 |
'contactperson@@@contactperson@@@dnet:project_organization_relations@@@dnet:project_organization_relations' as semantics
|
|
| 11 |
|
|
| 1 |
SELECT DISTINCT
|
|
| 2 |
po.project,
|
|
| 3 |
po.contactperson, |
|
| 4 |
po.startdate, |
|
| 5 |
po.enddate, |
|
| 6 |
po.inferred, |
|
| 7 |
po.deletedbyinference, |
|
| 8 |
po.trust, |
|
| 9 |
po.inferenceprovenance, |
|
| 10 |
'contactperson@@@contactperson@@@dnet:project_organization_relations@@@dnet:project_organization_relations' AS semantics
|
|
| 11 |
|
|
| 12 | 12 |
FROM project_organization po |
| 13 |
LEFT OUTER JOIN persons p on (p.id = po.contactperson)
|
|
| 13 |
LEFT OUTER JOIN persons p ON (p.id = po.contactperson)
|
|
| 14 | 14 |
|
| 15 |
WHERE po.contactperson is not null AND (p.firstname is not null OR p.secondnames is not null) |
|
| 15 |
WHERE po.contactperson IS NOT NULL AND (p.firstname IS NOT NULL OR p.secondnames IS NOT NULL) |
|
Also available in: Unified diff
integrated (hopefully) all required changes from dnet40