Where is the "Do not enable" status for an activity stored in the ACC database? | Community
Skip to main content
Level 2
November 16, 2023
Solved

Where is the "Do not enable" status for an activity stored in the ACC database?

  • November 16, 2023
  • 1 reply
  • 734 views

Hi Team,

 

I am trying to filter out the list of activities in a workflow that are set as "Do not enable". Can someone please help me understand which table and column holds this value for an activity in Adobe Campaign Classic?

Thank you in advance.

 

Kind Regards,

Anushka

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

@anushka_rk , in xtk:workflow schema, XML memo (data) field stores the entire XML source of the workflow (as shown in above comment's screenshot). In that, that is the only place where it holds all activities details of a workflow along with mask detail.

You can try utilising it, create a workflow and add a JavaScript activity in it and script in a way that utilising XML memo (data) field and can print the activities which has value mask=1 (do not enable).

1 reply

ParthaSarathy
Community Advisor
Community Advisor
November 17, 2023

Hi @anushka_rk ,

In xtk:workflow schema, under 'Activities', you can able to see all the activity list. In each activity, you can able to see an attribute @mask (Execution). This holds the value of whether it is Normal or Do not enable or Enable but do not execute.

Normal: @mask = 0

Do not enable: @mask = 1

Enable but do not execute: @mask = 2

 

Create a workflow 'View' folder > Filter > Advanced filter > give below condition

data contains mask="1", which result out all the workflows which have 'Do not enabled' activities.

Open any of that workflow, Right click somewhere inside your workflow > Edit XML source... > you can search mask="1" in it to see all the activities in Do not enabled mode. 

You can use this as base concept, and try to create a JS activity to fetch and display the activity list which are do not enabled.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
Level 2
November 17, 2023

Hi @parthasarathy ,

 

Thank you for your response.

 

The @mask (Execution) attribute in the xtk:workflow schema does provide the status of the activity but does not solve my query completely.

In my case, I have 3 deliveries in a workflow with 'Normal', 'Enable but do not execute' and 'Do not enable' statuses. In this case, all the deliveries are tagged as 'Do not execute' in the xtk:workflow schema (Which is incorrect).

 

Kind Regards,

Anushka

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
November 17, 2023

@anushka_rk , in xtk:workflow schema, XML memo (data) field stores the entire XML source of the workflow (as shown in above comment's screenshot). In that, that is the only place where it holds all activities details of a workflow along with mask detail.

You can try utilising it, create a workflow and add a JavaScript activity in it and script in a way that utilising XML memo (data) field and can print the activities which has value mask=1 (do not enable).

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups