Discussions
-
filed value appears with random characterless
Hi All, I have a column that has random correctors and I want to exclude it with BIRT function, value appears like "<~cb==bt=columnxc> London,Paris,Berlin<~ccl> I want to only show London, Paris, London and preferably like below format in one cell London Paris Berlin could you please advice me what function to use and the…
-
Date(Yesterday) function
Hello All, My current query is select count(*) from dm_user where r_creation_date > DATE('09/01/2019 21:00:00','mm/dd/yyyy HH:MM:SS') BUT, instead of explicitly specifying the date I want to use date (yesterday) in the above query without changing anything else. This is the requirement. Eg: select count(*) from dm_user…
-
display data in BIRT
Dear Open text community, I am new to birt and sql, kindly be with me if its a very basic question for u. I have two tables in DB 1.COMPANY- companyid, name, phone, address, and other info 2.COMPANY_OWNER- company id, ownername , percentage share my requirement is as below display a simple table report ,one row per company…
-
Change State Task Failed in D2 Lifecycle
Hi, I have automated my business process using workflows and lifecycle combination in D2-Config. In workflow design, the automated activity represents the lifecycle's state. When the automated activity (ie lifecycle state change) is executed post first manual approver, I see change task state failed message with below JMS…
