Hi,
I have created Workflow comments report but I only want when user run he/she should be able to see the results of only those workflows he is a participant of.
Thanks in advance.
regards,
Baber.
I think you will need to include a check of the user against SUBWORKTASK_PERFORMERID from the WSubWorkTask table in your query to restrict the results as desired.
- Bhupinder
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Monday, June 18, 2012 2:39 AMTo: eLink RecipientSubject: Workflow comments report
Workflow comments report
Posted bybaber.amin@dolphinenergy.com (Amin, Baber) On 06-18-2012 02:32
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
in standard livereport "Workflow Comments by user" I have replaced line
ww.work_ownerid=%4
with
(%4 in (select distinct SUBWORKTASK_PERFORMERID from wsubworktask where SUBWORKTASK_WORKID =wst.SUBWORKTASK_WORKID and SUBWORKTASK_SUBWORKID= wst.SUBWORKTASK_SUBWORKID))
and looks like its working as per my requirement. Please correct me if I did anything wrong.
regards, Baber.
sorry that was not a standard report anyhow I am pasting my report
select WF_WORKFLOWID "WorkflowID", wst.subworktask_title "Task Title",wsbw.subwork_title "Workflow Title", WF_VALUE "Comments", WF_DATESAVED "Comments Saved", (select FirstName|| ' ' || LastName || '('|| name||')' from kuaf where id=WF_PERFORMERID) "Performer" from wfcomments wfc, wsubwork wsbw, wsubworktask wst, wwork ww where wfc.wf_taskid=wst.subworktask_taskid and wfc.wf_workflowid=wsbw.subwork_subworkid and wst.subworktask_subworkid=wsbw.subwork_subworkid and ww.work_workid=wsbw.subwork_workid and WF_PERFORMERID=%1 and WF_DATESAVED between %2 and %3 and(%4 in (select distinct SUBWORKTASK_PERFORMERID from wsubworktask where SUBWORKTASK_WORKID =wst.SUBWORKTASK_WORKID and SUBWORKTASK_SUBWORKID= wst.SUBWORKTASK_SUBWORKID)) order by wfc.WF_DATESAVED
