<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
span.l1s331
{font-family:"Courier New";
color:#4DA619;
background:white;}
span.l1s521
{font-family:"Courier New";
color:blue;
background:white;}
@page Section1
{size:8.5in 11.0in;
margin:.5in .5in .5in .5in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mike,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Some functions you might want to use if you don’t find
an existing report are<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";background:white'>RH_MULTIPLE_OBJ_WI_SELECT<span
class=l1s331><font color=black face="Courier New"><span style='color:windowtext'><o:p></o:p></span></font></span></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";background:white'>SAP_WAPI_WORKITEMS_BY_TASK</span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";background:white'>SAP_WAPI_GET_WI_AGENTS<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";background:white'>SAP_WAPI_READ_CONTAINER<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>SWI_DURATION_DETERMINE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";background:white'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;background:white'>I had to also account for when the user
forwarded the task to someone else by reading the table swwloghist looking for
method SWW_WI_FORWARD and using that as the starting time for computing how
long it took the user to execute. (Yes I know we shouldn’t read the
tables directly but sometimes it’s faster then searching for a function).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;background:white'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;background:white'>If you have time zone issues I suggest
using <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span></font><span
class=l1s521><font size=2 color=blue face="Courier New"><span style='font-size:
10.0pt'>CONVERT</span></font></span><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span></font><span
class=l1s521><font size=2 color=blue face="Courier New"><span style='font-size:
10.0pt'>TIME</span></font></span><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span></font><span
class=l1s521><font size=2 color=blue face="Courier New"><span style='font-size:
10.0pt'>STAMP</span></font></span><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> swwloghist-timestamp<br>
</span></font><span class=l1s521><font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt'>TIME</span></font></span><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black;background:white'> </span></font><span
class=l1s521><font size=2 color=blue face="Courier New"><span style='font-size:
10.0pt'>ZONE</span></font></span><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sy-zonlo<br>
</span></font><span class=l1s521><font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt'>INTO</span></font></span><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black;background:white'> </span></font><span
class=l1s521><font size=2 color=blue face="Courier New"><span style='font-size:
10.0pt'>DATE</span></font></span><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> p_rec-wi_cd<br>
</span></font><span
class=l1s521><font size=2 color=blue face="Courier New"><span style='font-size:
10.0pt'>TIME</span></font></span><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> p_rec-wi_ct.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black;background:white'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Regards</span></font><font color=navy><span
style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Margaret Schumacher</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:blue'>SAP Technical Team </span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:blue'>Application Solutions & Delivery</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:blue'>Teleflex Medical</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=1
color=blue face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:blue'>2917 Weck Drive</span></font></st1:address></st1:Street><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=1
color=blue face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:blue'>RTP</span></font></st1:City><font size=1 color=blue face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:blue'>, <st1:State w:st="on">NC</st1:State>
<st1:PostalCode w:st="on">27709</st1:PostalCode></span></font></st1:place><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=blue face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:blue'>Phone: 919 361-3945</span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Michael
McInerney [mailto:michaelm@duke.edu] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, July 10, 2009 3:57
PM<br>
<b><span style='font-weight:bold'>To:</span></b> sap-wug@mit.edu<br>
<b><span style='font-weight:bold'>Subject:</span></b> Reporting on Who Tasks
Were Routed To and Who Reserved Them </span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>We have a need to do some reporting on workflows in a
manner which I would think would be a somewhat universal requirement.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Custom Workflow X has a number of steps, including dialog
steps which are routed to agents for action.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The dialog steps gets assigned to a group of typically 2 or
3 agents for resolution.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>One of the agents will (eventually) reserve and complete the
step. The process continues…<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Is there a canned report that might, show me all instances
of Workflow X that are STARTED and have the following info available in
its layout<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Workflow ID<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Date Started <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Elapsed (ie Today – Sate Started)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Task ID<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Date Started<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Elasped <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>List of Agents<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Reserving Agent (if reserved)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Date Reserved<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Elapsed<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks… …Mike <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr>
<td width=132 valign=top style='width:99.0pt;padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><img width=154 height=128 id="_x0000_i1025"
src="cid:image001.jpg@01CA0399.9AA56290"><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Arial Unicode MS"><span
style='font-size:10.0pt;font-family:"Arial Unicode MS"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Arial Unicode MS"><span
style='font-size:12.0pt;font-family:"Arial Unicode MS"'><o:p> </o:p></span></font></p>
</td>
<td width=468 valign=top style='width:351.0pt;padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal align=center style='text-align:center'><font size=4
color="#333399" face="Arial Unicode MS"><span style='font-size:14.0pt;
font-family:"Arial Unicode MS";color:#333399'>Michael K. <st1:PlaceName
w:st="on">McInerney</st1:PlaceName><br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Duke</st1:PlaceName> <st1:PlaceType
w:st="on">University</st1:PlaceType></st1:place>
Office of Information Technology<br>
<st1:address tabIndex="0"
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
w:st="on"><st1:Street w:st="on">334 Blackwell Street, Suite 1103</st1:Street>,
<st1:City w:st="on">Durham</st1:City>, <st1:State w:st="on">NC</st1:State> <st1:PostalCode
w:st="on">27701</st1:PostalCode></st1:address><br>
(919)684-5371
<a href="mailto:michaelm@duke.edu"><font color="#333399"><span
style='color:#333399'>michaelm@duke.edu</span></font></a></span></font><font
size=4 face="Arial Unicode MS"><span style='font-size:14.0pt;font-family:
"Arial Unicode MS"'><o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Arial Unicode MS"><span style='font-size:
12.0pt;font-family:"Arial Unicode MS"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>