Page Comparison

SELECT DISTINCT
pi."name",
/*
Selecting the indexvariables from 1 to 10, if desired:
*/
CASE WHEN pi.value1 IS NOT NULL THEN pi.value1 ELSE '-' END AS "Index 1",
CASE WHEN pi.value2 IS NOT NULL THEN pi.value2 ELSE '-' END AS "Index 2",
CASE WHEN pi.value3 IS NOT NULL THEN pi.value3 ELSE '-' END AS "Index 3",
/*
Selecting the required processvariables:
- A processVariables.- Line has to be added for every variable
*/
processVariables.VARIABLE_1_WITHOUT_SPACE AS "Header Variable 1",
processVariables.VARIABLE_2_WITHOUT_SPACE AS "Header Variable 2",
processVariables.VARIABLE_3_WITHOUT_SPACE AS "Header Variable 3",
identP.name AS "StarterID",
pi.definitionName AS "Processdefinition",
pi.id AS "ProcessID"
FROM view_instance pi
LEFT JOIN view_identity identP ON pi.creationUserId = identP.id
LEFT JOIN (
SELECT piInner.id,
/*
Creating a MAX(...) line for every desired variable
*/
MAX( CASE WHEN var.name = 'PROCESSVARIABLE 1' THEN var.stringvalue ELSE '-' END ) AS VARIABLE_1_WITHOUT_SPACE,
MAX( CASE WHEN var.name = 'PROCESSVARIABLE 2' THEN var.stringvalue ELSE '-' END ) AS VARIABLE_2_WITHOUT_SPACE,
MAX( CASE WHEN var.name = 'PROCESSVARIABLE 3' THEN var.stringvalue ELSE '-' END ) AS VARIABLE_3_WITHOUT_SPACE
FROM view_instance piInner
/*
In the following IN(...) statement all variablenames have to be listed, that are to be selected:
*/
LEFT JOIN view_variable var ON var.instanceId = piInner.id AND var.name IN ('PROCESSVARIABLE 1', 'PROCESSVARIABLE 2', 'PROCESSVARIABLE 3')
GROUP BY piInner.id
) processVariables ON pi.id = processVariables.id;