Posts

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...
Post a Comment
Read more

Parse the JSON in IBM BPM

var restResponse = "{"list":[{"firstName":"Pankaj","lastName":"Lilhare"},{"firstName":"Neelesh","lastName":"Thakur"},{"firstName":"Sharad","lastName":"Gupta"}]}"; var jsonObj = Packages.com.ibm.json.java.JSONObject.parse(restResponse); log.info("jsonObj: "+ jsonObj); var jsonArray = Packages.com.ibm.json.java.JSONArray.parse(jsonObj.get("list")); log.info("arrJsonss: "+ jsonArray); log.info("arrJson len: "+ jsonArray.size()); for(var i = 0; i
Post a Comment
Read more

Find instance creation date in ibm bpm

tw.system.findProcessInstanceByID(12345).tasks[0].processInstance.startDate tw.system.findTaskByID(12345).processInstance.startDate
Post a Comment
Read more

Read excel file and convert it to XML format in Java

//ReadExcelFile.java package com.excel; import java.io.File; import java.io.FileInputStream; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import javax.xml.bind.JAXBContext; import javax.xml.bind.JAXBException; import javax.xml.bind.Marshaller; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.parsers.ParserConfigurationException; import javax.xml.transform.Transformer; import javax.xml.transform.TransformerException; import javax.xml.transform.TransformerFactory; import javax.xml.transform.dom.DOMSource; import javax.xml.transform.stream.StreamResult; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.w3c.dom.Document; class Read...
Post a Comment
Read more

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-...
7 comments
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> ...
Post a Comment
Read more

Type conversion in IBM BPM

Convert Any() type to XmlElementType in IBM BPM : Here tw.local.results variable is ANY Type and tw.local.xmlElementResult is XMLElement Type var x = tw.system.serializer.toXml(tw.local.results); tw.local.xmlElementResult = tw.system.serializer.fromXml(x); Convert String type to Integer in IBM BPM : Here tw.local.results variable is StringType and tw.local.age is IntegerType tw.local.age = Number(tw.local.results);
Post a Comment
Read more