|
1
|
SELECT dor.datasource as datasource,
|
|
2
|
dor.organization as organization,
|
|
3
|
dor.startdate as startdate,
|
|
4
|
dor.enddate as enddate,
|
|
5
|
dor.inferred as inferred,
|
|
6
|
dor.deletedbyinference as deletedbyinference,
|
|
7
|
dor.trust as trust,
|
|
8
|
dor.inferenceprovenance as inferenceprovenance,
|
|
9
|
|
|
10
|
doc.code || '@@@' || doc.name || '@@@' || dos.code || '@@@' || dos.name as semantics,
|
|
11
|
pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name as provenanceaction
|
|
12
|
|
|
13
|
FROM datasource_organization dor
|
|
14
|
|
|
15
|
left outer join datasources d on (dor.datasource = d.id)
|
|
16
|
|
|
17
|
left outer join class pac on (pac.code = d.provenanceactionclass)
|
|
18
|
left outer join scheme pas on (pas.code = d.provenanceactionscheme)
|
|
19
|
|
|
20
|
left outer join class doc on (doc.code = dor.semanticclass)
|
|
21
|
left outer join scheme dos on (dos.code = dor.semanticscheme)
|
|
22
|
|
|
23
|
-- These clauses have been commented to allow the import of all the datasource on the index
|
|
24
|
-- WHERE d.datasourceclass != 'entityregistry'
|
|
25
|
-- AND d.openairecompatibilityclass IS NOT null
|
|
26
|
-- AND d.openairecompatibilityclass != 'UNKNOWN'
|
|
27
|
-- AND d.openairecompatibilityclass != 'notCompatible'
|