topic Re: WF-BATCH Query in Application Development and Automation Discussions

WF-BATCH Query

Former Member — Mon, 03 Sep 2007 15:33:13 GMT

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

Re: WF-BATCH Query

former_member194669 — Mon, 03 Sep 2007 15:58:08 GMT

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®

Re: WF-BATCH Query

Former Member — Mon, 03 Sep 2007 21:04:45 GMT

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.