... and try
SELECT @SELECT:DIM:USER_DEF:IMPLIED:PROCESSES:P.Run_id:Run_ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.process_code:process_code@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.status_code:status_code@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Sorting:Sorting@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.PCNT_COMP:PCNT_COMP@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Initiator:Initiator@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Initiated_code:Initiated_code@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Sdate:Sdate@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Edate:Edate@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Result:Result@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Endcode:End_code@
From
(select
bpm_run_processes.id Run_id,
-- bpm_run_processes.process_version_id P_ver_id,
-- bpm_def_process_versions.id V_id,
-- bpm_def_process_versions.process_id,
-- bpm_def_processes.id,
bpm_def_processes.process_code,
bpm_run_processes.status_code,
CASE
WHEN Status_code ='BPM_PIS_RUNNING'
THEN '1'
WHEN Status_code ='BPM_PIS_ERROR'
THEN '2'
ELSE '3'
END
Sorting,
bpm_run_processes.percent_complete*100 PCNT_COMP,
--bpm_run_processes.initiated_by I_by,
(Initiators.last_name+', '+Initiators.first_name) Initiator,
bpm_run_processes.initiated_type_code Initiated_code,
bpm_run_processes.start_date Sdate,
bpm_run_processes.end_date Edate,
bpm_run_processes.src_step_action_result_id Result,
bpm_run_processes.ended_type_code Endcode
from
bpm_run_processes,
bpm_def_process_versions,
bpm_def_processes,
cmn_sec_users Initiators
Where
bpm_def_process_versions.id = bpm_run_processes.process_version_id
and bpm_def_processes.id = bpm_def_process_versions.process_id
and bpm_run_processes.initiated_by = Initiators.id
) p
WHERE @FILTER@
Martti K.