Find business data value in ibm bpm product database
SELECT DISTINCT(bpdIns.BPD_REF) AS BPD_ID, VAR.ALIAS AS SEARCH_ALIAS, VAR.VARIABLE_NAME AS VARIABLE_PATH, BP.NAME AS BPD_NAME, bpdIns.BPD_INSTANCE_ID, VAR.STRING_VALUE FROM DBWS.LSW_BPD_INSTANCE_VARIABLES VAR LEFT JOIN DBWS.LSW_BPD_INSTANCE bpdIns ON VAR.BPD_INSTANCE_ID = bpdIns.BPD_INSTANCE_ID LEFT JOIN DBWS.LSW_SNAPSHOT SNAP ON SNAP.SNAPSHOT_ID = bpdIns.SNAPSHOT_ID LEFT JOIN DBWS.LSW_PROJECT PROJ ON SNAP.PROJECT_ID = PROJ.PROJECT_ID LEFT JOIN DBWS.LSW_BPD BP ON bpdIns.CACHED_BPD_VERSION_ID = BP.VERSION_ID WHERE PROJ.SHORT_NAME= '<ACRONYM NAME>' AND VAR.STRING_VALUE LIKE '%TEST%' ORDER BY BP.NAME; Note: DBWS is schema name --> To find the activity count in Product database: SELECT * FROM (SELECT COUNT(TSK.TASK_ID) AS COUNTS, TSK.BPD_INSTANCE_ID FROM DBWS.LSW_TASK TSK INNER JOIN DBWS.LSW_BPD_INSTANCE BPD ON BPD.BPD_INSTANCE_ID = TSK.BPD_INSTANCE_ID WHERE BPD.EXECUTION_STATUS =1 AND TSK.ACTIVITY_NAME=' ' AND TO_TIMESTAMP(TO_CHAR(TSK.RCVD_D...