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