Block sending 2 emails with the same subject | Community
Skip to main content
Level 2
January 27, 2022
Solved

Block sending 2 emails with the same subject

  • January 27, 2022
  • 2 replies
  • 1581 views

Hello Community
I am looking to create a typology rule to block sending 2 emails with the same subject sent to the same recipient within 24 hours.
I have tried using pressure rules but this one blocks all deliveries to be sent to recipients. (we want to block the specified delivery).
Any help for the query we want to use?
Thanks in advance

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 Wiznamo

I found the correct answer 
To solve this issue, we used a typology rule that checks the delivery label with the current delivery label.
The expression :
[delivery/@label] equals [currentDelivery/@label].

2 replies

Tobias_Lohmann
Adobe Employee
Adobe Employee
January 28, 2022

Hi,

this should be possible using a "Filtering" type typology rule. The filter needs to look into the broadlog and compare possibly existing deliveries. Something like this:

 You can use the currentDelivery object (it is not selectable in the UI, you have to enter it manually in the advanced screen) to access the delivery that is about to being sent. You should also try to filter most of the audience upfront during targeting and use this rule only as a safety measure. 

And lastly you need to test this; the subject attribute is also a hidden field, and I am not sure if it can be used in queries like this for comparison. 

Good luck and best regards, Tobias

WiznamoAuthor
Level 2
January 31, 2022

Hi Tobias ,

Thank you so much for your reply 
I tried to use the query you gived me but I get this error 

QUE-370015 The '/mailParameters/subject' element is not stored as an independent SQL field (document type 'Diffusions (nms:delivery)'). Impossible to use it as a filter criterion in a query.

 

 

Best regards

WiznamoAuthor
Level 2
January 31, 2022

Good morning,

you could try to compare the subject by using the NodeValue function:

NodeValue('delivery/mailParameters/subject', data)

Best regards, Tobias


Good Morning,

Unfortunately it didnt work I got the same error 😞 

Here is the Expression I've tried

Best Regards

WiznamoAuthorAccepted solution
Level 2
February 1, 2022

I found the correct answer 
To solve this issue, we used a typology rule that checks the delivery label with the current delivery label.
The expression :
[delivery/@label] equals [currentDelivery/@label].