From the Audit Actions tab, we want to pull the Created Date of the logged-in user’s workgroup’s work task records. Since we do not have a specific BO for Audit Actions, we have written a static SQL (i.e., a Select query with joins) in a new data set in BIRT to display the Audit Actions > Created Date. We have hard-coded SPEC_ID values of a user which will pull the records of only that user for any login. But we need to pull it dynamically for any logged-in user.
Can we pull the TRIRIGA logged-in user’s workgroup’s work task records by using a static hard-coded SQL in BIRT Designer 4.3.1? Can you please suggest how to achieve this?
[Admin: This post is related to the 07.16.14 post about using hard-coded SQL statements in BIRT report parameters.]