Hi Team,
We currently have the below report which is working.
select
k.Name as "Performer ID",
K.FirstName||' '||K.LastName "Name",
w.SubWorkTask_Title as "Title",
NVL(TO_CHAR(w.SubWorkTask_DateReady, 'MM/DD/YYYY HH:MM PM'), ' ') as "Step Ready",
NVL(TO_CHAR(w.SubWorkTask_DateDone, 'MM/DD/YYYY HH:MM PM'), ' ') as "Step Done",
NVL(TO_CHAR(w.SubWorkTask_DateDue_Max, 'MM/DD/YYYY HH:MM PM'), ' ') "Step Due"
from
WSubWorkTask w, KUAF k
where
w.SubWorkTask_SubWorkID = %1
and k.ID=w.SubWorkTask_PerformerID
and w.SubWorkTask_Title not in ('map_attributes', 'move shortcut URL to folder')
order by w.SubWorkTask_DateDue_Max
Now for the PerformerID we need to display the user icon (16user.gif) or group icon (16group.gif) which are located at <OpenText Root Folder>\support\webwork on the CS. Similarly there are other GIF file which are located at this location and we need to display in the report. I remember someone mentioning in one of the OpenText session that this can be achieved but not sure how this can be. If anyone has any idea please share the details either for the LR or WR.
Thanks,
Nikhil Sanghvi