Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Restrict data deletion in update Data activity

Avatar

Avatar
Validate 1
Level 1
vkt1989
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
vkt1989
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
vkt1989
Level 1

17-08-2020

We have a requirement where users should not be allowed to delete any data from the schema. We have restricted the users with 'Delete data' option in folder properties. But users are still able to delete using query & update data activity in the workflow.

 

Is there any way to restrict deletion?

 

 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

154 likes

Total Posts

910 posts

Correct Reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

154 likes

Total Posts

910 posts

Correct Reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

31-08-2020

Hi @vkt1989 ,

 

Were you able to resolve this with the help that you got? Please let us know.

 

Thanks!

Avatar

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

17-08-2020

Hello @vkt1989 

Its not a bug its a feature. We have the same setup while on workflow i can remove the entire instance if i please.. but in the explorer i cannot remove a single thing.. maybe its a product related and not the setup itself.

 

But additional to folder restrictions you might set up the sysfilters on schemas maybe that way the update activity will throw an error
https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/editing-s...


Also you can add another enumeration which is used in update data where you will not add delete.

the used enumeration is in nms:workflow ---> operation type

 

<enumeration basetype="string" default="insertOrUpdate" name="operationType">
    <value label="Insert or update" name="insertOrUpdate"/>
    <value label="Insert" name="insert"/>
    <value label="Update" name="update"/>
    <value label="Update and merge collections" name="merge"/>
    <value label="Delete" name="delete"/>
  </enumeration>

 


Then  in the FORMS you will just feed different enumeration based on rights?

 

 <input xpath="@operationType"/>
<container type="visibleGroup" visibleIf="GetLinkCardinality([../@schema], @dstExpr)==0 OR @dstExpr=''">
                    <input enum="xtk:workflow:mergeType" label="Merge type" type="sysenum"
                           xpath="@operationType"/>
                  </container>

 

 

Using enableIf

https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/input-for...
Marcel