Use current campaign name in typology rule | Community
Skip to main content
AC_Bella
Level 2
November 25, 2019
Solved

Use current campaign name in typology rule

  • November 25, 2019
  • 4 replies
  • 5650 views

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:

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

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 Jyoti_Yadav

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.

4 replies

Manoj_Kumar
Community Advisor
Community Advisor
November 26, 2019

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

Manoj     Find me on LinkedIn
Jyoti_Yadav
Jyoti_YadavAccepted solution
Level 8
November 27, 2019

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.

AC_Bella
AC_BellaAuthor
Level 2
December 4, 2019

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!

Level 2
April 27, 2021

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