CS10 Live Report to remove a specific group in workflow attachments after workflow has been initated

Hello Team,

I am trying to create a Report that will remove a designated group WF Attachments permissions after a workflow is initiated.

I am using WR's and Trigger as well and I beleive they are correct.

Here is my LR code and it is not working:

SELECT b.dataid "WF Attachment"

FROM wdata a, dtree b

WHERE a.data_subworkid=%1
AND a.data_subtype=1
AND a.data_userdata=b.parentid
AND b.subtype=2

Thank you, Dennis Anich

Find more posts tagged with

Comments

Greg Griffiths

Denis,

have you tried the LR and WR in isolation with hardcoded parameters to ensure that it functions as you expect ?

Colin_Schmidt

You aren’t going to get anything related to a “Group” by that. At least this will display the Groups/Users

SELECT b.dataid "WF Attachment", dta.rightid, k.name

FROM wdata a

join dtree b on a.data_userdata = b.parentid AND b.subtype = 2 /* A Generation */

join dtreeacl dta on b.dataid = dta.dataid

join kuaf k on dta.rightid = k.id

WHERE a.data_subworkid = %1 AND a.data_subtype = 1 /* An Alias */

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Saturday, February 11, 2017 11:30 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: CS10 Live Report to remove a specific group in workflow attachments after workflow has been initated

CS10 Live Report to remove a specific group in workflow attachments after workflow has been initated

Posted by Anich, Dennis On 02/11/2017 11:24 AM

Here is my code and it is not working:

SELECT b.dataid "WF Attachment"

FROM wdata a, dtree b

WHERE a.data_subworkid=%1
AND a.data_subtype=1
AND a.data_userdata=b.parentid
AND b.subtype=2

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

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.