I've a tablet with data from 2 years ago, up to today. I've been tasked to remove all records, except for the last 7 days.So my approache is: 1.- Create table (toy table to store last 7 days records).2.- Query the original table, lets call it "A", to filter all records based on the created column th...

I got a solution, parsing the Delivery's HTML content: function validateUrlsInHtml(htmlSource) { logInfo("### Starting URL Valdation process."); var urlRegex = /href="(http[s]?:\/\/[^"]*)"/gi; var match; var foundUrls = []; var isValid = true; //Extracting URLs using the regex log...

how to query the nms:trackingLogRcp to filter out Recipients that have not opened an email/sms/push in the last 6 months?I tried using a Filtering typology, but trackingLogRcp doesn't have a column to filter out Recipients who have not opened an email in X time. 

@_Manoj_Kumar_  I get: No URLs in Delivery.  Even when there is a url link there, May you tell me how to fix it?  

Hi @_Manoj_Kumar_   , ty. What about SMS and Push?Because I see that the code looks in the html content: delivery.content.html.urlConfig.urlBut this approach wouldn't apply to SMS or Push, right?Aslo, I'd appreciate any doc on the properties of the objects, to understand for example the property: "c...

We need to send only deliveries that contain urls with a specific domain: www.mydomain.com or www.telecredit.com . If the delivery contains any urls with any other domain, the delivery MUST NOT be sent.We need to avoid phising practices that could affect our clients. Is this possible with typologies...

Hi @_Manoj_Kumar_ But this only works if both tables, in your example Recipients and Delivery Logs are liked by a key right?If there is no link, you cannot use a table as filtering dimension?Other related question: when to use activity "Change dimension"?

I have these cases from the preparation test and I need your help understanding "Change dimension activity".1.- The business practicioner wants to obtain the total travel miles per recipient. Two different sets of data neeed to be combined in order to target/analyze that:A) The first set of data con...

How to tell Campaign that if a record is deleted in table A, the same record, based on a field that would act as a Foreign Key, should also be deleted?Is there any configuration I can do in the schema, so I get the on_delete=models.CASCADE other DB have?

@ParthaSarathy will this work with deliveries with "waves" activated?Also, how would this handle retries?