Find instance creation date in ibm bpm

tw.system.findProcessInstanceByID(12345).tasks[0].processInstance.startDate




tw.system.findTaskByID(12345).processInstance.startDate

Comments

Post a Comment

Popular posts from this blog

IBM BPM Interview Questions

IBM BPM Interview Questions: 1. What is difference between Coach and Coach Views? 2. What is difference between EPV and Environment variable? Which is good performance wise? 3. What is shared object? 4. How many types of gateways? Explain them? 5. How many services available? (Integration service/ General service) 6. In production one instance has been failed due to some business object has bad data or null values, How will you inject data on runtime in production? Ans: IBPM provide some rest api which operation name is setData through that we can inject values. 7. How will you handle exception in BPM? 8. What is durable and consume in UCA? 9. What is synchronus and unsynchronus? 10.Difference between Sub Process and Linked Process? 11. I have one screen which has 3 radio button and based on click button, I want to display different different pallet/widget or coachview. how will you do that? 12. I have one BPD, which has multiple tasks. How will you identify user in run-...
Read more

XML Parsing in IBM BPM

Suppose I have following XML and I want to parse this xml and store these variable to in list: <record> <column name="ID">1</column> <column name="MANIFACTURERNAME">Dell</column> <column name="MODELNAME">Latitute</column> <column name="RAMSIZE">8 GB</column> <column name="HDDSIZE">1 TB</column> <column name="SCREENSIZE">15 Inch</column> <column name="PROCESSORNAME">Intel i7</column> <column name="PRICE">850</column> </record> <record> <column name="ID">3</column> <column name="MANIFACTURERNAME">Latitude</column> <column name="MODELNAME">ideaBook</column> <column name="RAMSIZE">8 GB</column> <column name="HDDSIZE">300 GB</column> ...
Read more

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...
Read more