Invalid Mapping sessions
Displays sessions that are created for invalid mappings by repository and folder.
Click on the text to copy the query report to your clipboard.
select case when ("REUSABLEFLAG" = 1) then ('Yes') else ('No') end as "Calc_ReusableFlag",
"SESSION_NAME",
"REPOSITORY_NAME",
case when ("VALIDFLAG" = 1) then ('Yes') else ('No') end as "Calc_ValidFlag",
"COMMENTS",
"MAPPING_NAME",
"SUBJECT_AREA",
"LAST_SAVED",
"MAPPING_VERSION_NUMBER",
"SESSION_VERSION_NUMBER"
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME AS REPOSITORY_NAME, ALL_SESSIONS.SUBJECT_AREA AS SUBJECT_AREA, ALL_SESSIONS.SESSION_NAME AS SESSION_NAME, ALL_SESSIONS.MAPPING_NAME, (COUNT(DISTINCT( SESSION_TASK_INST.WORKFLOW_ID))) AS WORKFLOWID, ALL_SESSIONS.COMMENTS AS COMMENTS, ALL_SESSIONS.SESSION_VERSION_NUMBER AS SESSION_VERSION_NUMBER, ALL_SESSIONS.MAPPING_VERSION_NUMBER AS MAPPING_VERSION_NUMBER, ALL_SESSIONS.IS_VALID AS VALIDFLAG, ALL_SESSIONS.IS_REUSABLE AS REUSABLEFLAG, ALL_SESSIONS.LAST_SAVED AS LAST_SAVED FROM REP_REPOSIT_INFO SESSION_REPOSIT_INFO, REP_LOAD_SESSIONS ALL_SESSIONS LEFT OUTER JOIN REP_TASK_INST SESSION_TASK_INST ON ALL_SESSIONS.SESSION_ID = SESSION_TASK_INST.TASK_ID AND SESSION_TASK_INST.TASK_TYPE = 68 WHERE (ALL_SESSIONS.SESSION_ID <> SESSION_REPOSIT_INFO.REPOSITORY_ID) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, ALL_SESSIONS.SUBJECT_AREA, ALL_SESSIONS.SESSION_NAME, ALL_SESSIONS.MAPPING_NAME , ALL_SESSIONS.COMMENTS, ALL_SESSIONS.SESSION_VERSION_NUMBER , ALL_SESSIONS.MAPPING_VERSION_NUMBER , ALL_SESSIONS.IS_VALID , ALL_SESSIONS.IS_REUSABLE , ALL_SESSIONS.LAST_SAVED) "query"
where "SUBJECT_AREA" in ('
order by "REPOSITORY_NAME", "SUBJECT_AREA"