Can any one provide some information on how to create a live report to show all the documents attached to a workflow?
Do you want specific WFs or all in a list broken down by WF?
Colin J. Schmidt
Knowledgelink Support
CapitalOne | Collaboration Technology
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, July 28, 2016 4:32 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Workflow Live Report Query
Workflow Live Report Query
Posted by Lipnicky, Pat On 07/28/2016 04:28 PM
[To post a comment, use the normal reply function]
Topic:
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.
I need both. I need it broken down by one workflow. I want to be able to enter the workflow ID, and then for that Id I want to return the lists of attached workflow documents.
Then I also need to be able to query by a time frame for a list of all workflows with the attached documents.
I haven’t quite gone into the deep end of this:
To go from a WF to its attachments, you have this path (unless someone has more straight one):
Starting with WSUBWORK because it has within it, the MAPID, so it goes like this:
WSUBWORK.subwork_mapid = WMAP.map_mapid
From the WMAP, you get to the DTREECORE by: WMAP.map_mapobjid = DTREECORE.dataid
From the DTREECORE, you get to the WF Attachment Folder of the WF(subtype = 154 and childcount > 0) and then the Attachments, if any. I haven’t had enough time to get from there to the Attachment folder, but that’s the path.
eLink : RE Workflow Live Report Query 2RE Workflow Live Report Query 2 Posted bySchmidt, ColinOn 07/31/2016 09:40 PM I haven’t quite gone into the deep end of this:To go from a WF to its attachments, you have this path (unless someone has more straight one): Starting with WSUBWORK because it has within it, the MAPID, so it goes like this: WSUBWORK.subwork_mapid = WMAP.map_mapid From the WMAP, you get to the DTREECORE by: WMAP.map_mapobjid = DTREECORE.dataid From the DTREECORE, you get to the WF Attachment Folder of the WF(subtype = 154 and childcount > 0) and then the Attachments, if any. I haven’t had enough time to get from there to the Attachment folder, but that’s the path. Colin J. SchmidtKnowledgelink SupportCapitalOne | Collaboration Technology From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, July 28, 2016 4:32 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Workflow Live Report Query Workflow Live Report Query Posted by Lipnicky, Pat On 07/28/2016 04:28 PM Can any one provide some information on how to create a live report to show all the documents attached to a workflow?[To post a comment, use the normal reply function]Topic: Workflow Live Report QueryForum: Content Server LiveReports ForumContent Server: Knowledge Center The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.[To post a comment, use the normal reply function]Topic:Workflow Live Report QueryForum:Content Server LiveReports ForumContent Server:Knowledge Center
As was previously and correctly stated: WDATA.
WDATA gives the WF Attachment Folder (Subtype =154). Using that as “DTREECORE.ParentID”, you can get the Attachments. Though there are some WFs that won’t have attachments. Check out the data in WDATA.DATA_USERDATA. There’re “Type” and “SubType” to check. In ours, there’s 1 Type and 4 Subtypes. I’ve not tried to figure out which determines what.
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Sunday, July 31, 2016 9:41 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: RE Workflow Live Report Query 2
RE Workflow Live Report Query 2
Posted by Schmidt, Colin On 07/31/2016 09:40 PM
From TODO2 or some other table or View, you can go to WDATA to DTREECORE
TODO2.work_workid = WDATA.data_workid and TODO2.subwork_subworkid = WDATA.data_subworkid and WDATA.data_subtype = 1 ß-points to WF Attachment, skip other Subtypes
To_number(trim(WDATA.data_userdata)) = DTREECORE.dataid gets the WF Attachment folder and name. Link it to another join to DTREECORE, as below to get….
DTREECORE.dataid = DTREECORE.parentid to get all the Documents and any additional Folders in the WF Attachment folder.
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Sunday, July 31, 2016 10:15 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Re RE Workflow Live Report Query 2
Re RE Workflow Live Report Query 2
Posted by eLink On 07/31/2016 10:14 PM
The easiest relation if you know the workid/subworkid is to look at the wdata table
WDATA has a primarykey of workid position 1 forget the column name but it may be type or subtype, is the attachments volume.If you have a workid/subworkid can you see if you can match up the
attachments volume'not the attachment document itself to that.Once you obtain the attachment volume id you can find your attachments.
Similarly the other positions are for its other packages like comments,wf attributes ,forms etc
The attachments can then be used in the parentid of your query
The view webactivework is a treasure trove of information.
That view has a convenient column from which you can know all workflows that people generated off a single dataid.
The schema companion from OT has lots of queries you can re purpose
Ciao, Appu
On Jul 31, 2016, at 8:41 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:
RE Workflow Live Report Query 2 Posted by Schmidt, Colin On 07/31/2016 09:40 PM I haven’t quite gone into the deep end of this:To go from a WF to its attachments, you have this path (unless someone has more straight one): Starting with WSUBWORK because it has within it, the MAPID, so it goes like this: WSUBWORK.subwork_mapid = WMAP.map_mapid From the WMAP, you get to the DTREECORE by: WMAP.map_mapobjid = DTREECORE.dataid From the DTREECORE, you get to the WF Attachment Folder of the WF(subtype = 154 and childcount > 0) and then the Attachments, if any. I haven’t had enough time to get from there to the Attachment folder, but that’s the path. Colin J. SchmidtKnowledgelink SupportCapitalOne | Collaboration Technology From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, July 28, 2016 4:32 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Workflow Live Report Query Workflow Live Report Query Posted by Lipnicky, Pat On 07/28/2016 04:28 PM Can any one provide some information on how to create a live report to show all the documents attached to a workflow?[To post a comment, use the normal reply function]Topic:Workflow Live Report QueryForum:Content Server LiveReports ForumContent Server:Knowledge Center The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.[To post a comment, use the normal reply function]Topic: Workflow Live Report QueryForum: Content Server LiveReports ForumContent Server: Knowledge Center
