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

[Anushka_RK]

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

[ParthaSarathy]

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.

[Anushka_RK]

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 · Accepted solution]

@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).