Typology rule | Community
Skip to main content
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 CampaignerForLife

Hi @alnavarg, I had the same Doubt, @parthasarathy gave me a good answer to it, I Copy it:

Create a Typology rule under /Administration/Campaign Management/Typology management/Typology rules/

And select the type as 'Control' and configure as below

 

In code tab, add the below script:

var internalName = delivery.internalName;
var query = xtk.queryDef.create(<queryDef operation="select" schema="nms:delivery">
                                          <select>
                                              <node expr="@internalName"/>
                                              <node expr="@id"/>
                                              <node expr="@created"/>
                                              <node expr="[operation/@id]"/>
                                              <node expr="[operation/@end]"/>
                                           </select>
                                          <where>
                                            <condition expr={"@internalName = '"+internalName+"'"}/>
                                          </where>
                                        </queryDef>);
var record = query.ExecuteQuery();

for each (var variable in record) {
var campaignEndDate = variable.operation.@end;
var deliveryCreationDate = formatDate(variable.@created, "%4Y-%2M-%2D");
if( deliveryCreationDate > campaignEndDate)
{
logWarning("Delivery Creation Date crossed campaign End Date");
return false; 
}
else{
return true;
}
}

And create a new 'Typology' and add the above created typology rule in it.

 

When creating a campaign delivery, use this typology in delivery property.

Now if the Delivery creation date is greater than campaign end date, then the delivery gets failed with the Audit log as 'Delivery Creation Date crossed campaign End Date'

 

 

Credits to @parthasarathy 

2 replies

AkshayAnand
Community Advisor
Community Advisor
July 26, 2023

Hi @alnavarg 

 

You can create a filter type typology with targeting dimension as nms:Campaign and filtering conditions as below 

Regards

A

CampaignerForLife
CampaignerForLifeAccepted solution
Level 5
July 26, 2023

Hi @alnavarg, I had the same Doubt, @parthasarathy gave me a good answer to it, I Copy it:

Create a Typology rule under /Administration/Campaign Management/Typology management/Typology rules/

And select the type as 'Control' and configure as below

 

In code tab, add the below script:

var internalName = delivery.internalName;
var query = xtk.queryDef.create(<queryDef operation="select" schema="nms:delivery">
                                          <select>
                                              <node expr="@internalName"/>
                                              <node expr="@id"/>
                                              <node expr="@created"/>
                                              <node expr="[operation/@id]"/>
                                              <node expr="[operation/@end]"/>
                                           </select>
                                          <where>
                                            <condition expr={"@internalName = '"+internalName+"'"}/>
                                          </where>
                                        </queryDef>);
var record = query.ExecuteQuery();

for each (var variable in record) {
var campaignEndDate = variable.operation.@end;
var deliveryCreationDate = formatDate(variable.@created, "%4Y-%2M-%2D");
if( deliveryCreationDate > campaignEndDate)
{
logWarning("Delivery Creation Date crossed campaign End Date");
return false; 
}
else{
return true;
}
}

And create a new 'Typology' and add the above created typology rule in it.

 

When creating a campaign delivery, use this typology in delivery property.

Now if the Delivery creation date is greater than campaign end date, then the delivery gets failed with the Audit log as 'Delivery Creation Date crossed campaign End Date'

 

 

Credits to @parthasarathy