機械翻訳について

PATCH_ARTIFACT_CHG_STATUS

詳細

• スキーマ: FUSION

• オブジェクト・タイプ: VIEW

列

名前
APP_ID TYPE CHANGE_TYPE TOTAL_COUNT

問合せ

SQL_Statement

SELECT APP_ID, TYPE, CHANGE_TYPE, COUNT(1) TOTAL_COUNT FROM ( SELECT APP_ID, TYPE, 'CONFLICTS' CHANGE_TYPE FROM PATCH_ARTIFACT WHERE CHG_TYPE IN ('MODIFICATIONS_CONFLICTS_2WAY', 'ADDITIONS_CONFLICTS_MODIFIED', 'MODIFICATIONS_CONFLICTS_3WAY', 'DELETIONS_CONFLICTS_MOD') UNION ALL SELECT APP_ID, TYPE, 'CHANGES' CHANGE_TYPE FROM PATCH_ARTIFACT WHERE CHG_TYPE IN ('ADDITIONS_SAFE', 'MODIFICATIONS_SAFE', 'DELETIONS_SAFE') ) GROUP BY APP_ID, TYPE, CHANGE_TYPE