Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

WF-BATCH Query

Former Member

‎2007 Sep 03 4:33 PM

0 Likes
402

Hi,

Im producing a report that require the name of the person who posted a document in the header of the report. This gives the user ID for most document, but since there is also workflow connect to this document(to post), some of them will have WF-BATCH on the report instead of the user ID.

Is there any way i can could the user ID of the person who posted in through workflow?

Thanks,

Colm

2 REPLIES 2
Read only

former_member194669
Active Contributor

‎2007 Sep 03 4:58 PM

0 Likes
339

Hi,

Please check view V_OP. It contains all background jobs (JOBNAME) with its User name (SDLUNAME) who has scheduled the job..

May this one hlep you out.

a®

Read only

Former Member

‎2007 Sep 03 10:04 PM

0 Likes
339

I had to something like this a couple of years back in a 4.0 system - the approach we took was to go to SWW_CONTOB to get the work items linked to the documents, and use that list of IDs to go back to SWW_CONTOB + SWWWIHEAD (join) to look for the "approver" there, eliminating WF-BATCH and WFBATCH. We'd tried using change history, but it recorded WF-BATCH not the real user. The batch jobs data was culled regularly, so that wasn't a good option for us.