Betreff: Block sending 2 emails with the same subject

[Wiznamo]

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

[Tobias_Lohmann]

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

[Wiznamo]

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

[Tobias_Lohmann]

Good morning,

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

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

Best regards, Tobias

[Wiznamo]

Good Morning,

Unfortunately it didnt work I got the same error  

Here is the Expression I've tried

Best Regards

[Wiznamo · Accepted solution]

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].