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

SOLVED

Use current campaign name in typology rule

AC_Bella
Level 2
Level 2

Hello everyone,

currently I am trying to create a typology rule which makes sure that a recipient does not get the same Email-campaign twice.

It seems that I have to use JavaScript to retrieve the campaign name from where the delivery is startet.

I thought maybe something like this could work:

// Define campaign name of current workflow where delivery is located.

function currentCampaignName(){

// Get primary key from workflow.

  var workflowID = instance.id;

  var tmpCon = application.getConnection();

  var internalName = tmpCon.query("SELECT O1.sInternalName FROM XtkWorkflow W0 JOIN NmsOperation O1 ON (O1.iOperationId = W0.iOperationId) WHERE W0.iWorkflowId = $(l)",workflowID);

  for each(var row in internalName)

    var campaignName = row[0];

  return campaignName;

}

// Exclude recipients which got the defined campaign within last 60 days.

function excludeRecipients (){

  var tmpCon = application.getConnection();

  var campaignName_compare = currentCampaignName();

  // Select all delivery logs of recipient from current campaign.

  var broadLog_array = tmpCon.query("SELECT COUNT(B0.iBroadLogId) FROM NmsBroadLogRcp B0 JOIN NmsDelivery D1 ON (D1.iDeliveryId = B0.iDeliveryId) JOIN NmsOperation O2 ON (O2.iOperationId = D1.iOperationId) WHERE O2.sInternalName = $(sz)", campaignName_compare);

for each(var row in broadLog_array)

     var countBroadLog = row[0];

     if(countBroadLog > 0) {

       return false;

     } else {

       return true;

     }

}

return excludeRecipients();






It works if I put it within a JavaScript component of a workflow but within a typologie rule I get the following error:

1857911_pastedImage_5.png

Since "instance" is apparently not available within a delivery what should I use instead to get the campaign name?

Or do you have a better solution at hand?

Best,

Bella

1 Accepted Solution
Jyoti_Y
Correct answer by
Community Advisor
Community Advisor

Hi,

You can write query condition in typology rule to get campaign name:

var query= xtk.queryDef.create(

                 <queryDef schema="nms:delivery" operation="get">

                   <select >

                  <node expr="[operation/@internalName]" alias="@campaignName" />

                  </select>

                 <where>

                  <condition expr={"@id=" + delivery.id}/>

                 </where>

                 </queryDef> )

var campaignName= query.ExecuteQuery().@campaignName.toString();

Thanks.

View solution in original post

4 Replies
Manoj_Kumar_
Community Advisor
Community Advisor

You can just add a split activity that will look at delivery logs for the specific delivery code. if the delivery code exists then exclude the audience else you can send them the communication.

Thanks,

Manoj

Jyoti_Y
Correct answer by
Community Advisor
Community Advisor

Hi,

You can write query condition in typology rule to get campaign name:

var query= xtk.queryDef.create(

                 <queryDef schema="nms:delivery" operation="get">

                   <select >

                  <node expr="[operation/@internalName]" alias="@campaignName" />

                  </select>

                 <where>

                  <condition expr={"@id=" + delivery.id}/>

                 </where>

                 </queryDef> )

var campaignName= query.ExecuteQuery().@campaignName.toString();

Thanks.

View solution in original post

AC_Bella
Level 2
Level 2

Hi Manoj,

I would definitely use that if it would be only me but I need something simple for our campaign managers - something which happens in the background and they don't have to think about.

I'll try the JavaScript code next.

Thanks for your help!

kaushal13
Level 2
Level 2

Hi ,

Looking for similar solution where one delivery is used a campaign should be excluded for rest of day. 

Any help appreciated as able example looks similar is tried in typology rule . Did you got how to call the js in typology and which type ex - filter or control method is used. 

 

thanks,

Kaushal