Hi, How are venues to ignore selected? If it's a small number of specified venues, use a predefined filter with a not in() condition to filter them from the query. If it's a large dynamic list, use an exclusion activity to subtract it from the set of venues prior to joining to the recipients. Thanks...
Hi, Are you using ToString() inside the Substring, and offset counting from 1?Substring(ToString(@short), 1, 1) works fine in postgres, translates to Substr(text(X0.iShort), 1, 1) Thanks,-Jon
Hi, I'm not sure what that setting does, probably something with budgeting and/or MRM.To concatenate files from deliveries, use a post-processing workflow on the routing account or service provider: Check if current delivery is last delivery in the group (e.g. 5 files exist, 5 expected), and if so u...
Mirror pages and email archiving are email features. For SMS you'd have to materialize the template against data stashed to broadlog or what's currently in the tables (if use case allows).
Hi, Assuming 'nothing else' refers to user-defined schemas, add sysFilters per this guide:https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/editing-schemas/filtering-schemas.htmlNB all users of Campaign share the same underlying db user, so this is mostly cos...
Hi, Change the operators' security zone to align to their IP ranges.This can be accomplished by altering the zone in instance conf or altering the operators to use a more permissive zone. Ideally there is a LAN zone with their IP ranges, and with all operators set to use it. Thanks,-Jon
Hi, I did this for a large charity organization once, using mirror page links in flat files.PDF's you can generate with a post-processing workflow rendering mirror pages with headless chrome.Another approach could be Email Archiving (BCC) to a third-party system to handle. Thanks,-Jon