You can leave existing cols in place and just set the sqlNames for the two. Or use sql rename commands. Should be its own sequence, no reason to use up broadlogrcp's.

-

Hi, If it's client-side js can just get it from (window.location + '').replace(/.*\//, '').Server-side doesn't have any info about the webapp afaik. Thanks,-Jon

Hi, The nms:broadLogEventHisto/@id col is populated by mcSynch_local workflow, which sets it to:$int64(vars/@CELL_OFFSET)*$long(vars/@cellId) + @IDvars/@CELL_OFFSET = '72057594037927936' (string since js doesn't go up that high, 2**52)vars/@cellId = xtk:option NmsExecutionInstanceId@ID= nms:broadLog...

There's xtk.workflow.get(instance.id), which also returns wppObject. Would have to use queryDef or sqlGetString for the data clob (or specifically [activities/query] for queryDef) and run it through new XML(). Cheaper to iterate over the wppObject in hand.

Nah it's not going to work, instance is 'wppObject' not XML. Have to do it the hard way: function getPriorActivityByType(activityType) { for each (var priorActivity in instance.activities[activityType]) { for each (var transition in priorActivity.transitions) { if (transition.target === ...

Hi, Adobe Campaign Classic doesn't ship with a REST API or an xtk:workflow#ProcessCommand action.Maybe custom development? GET method that returns trigger URL? Thanks,-Jon

Hi, Everything you have there is correct (though it can be reduced to <%= formatDate(new Date(), "%Y") %> ;).You can preview 'without' sending by sending the delivery with confirmation/approvals enabled.Once sent, the executed delivery can be opened and previewed against target population/vars befor...

Hi, It's missing in my postgres db; funcList.xml only shows a definition for SQL Server, which you have.Check db if it's available?sql server - Query to list all stored procedures - Stack Overflow Thanks,-Jon

Hi, Looks like Campaign's db functions got lost somehow.Easy way to reinstall them is to add your db as an external account and use the FDA conf to deploy (snapshot db before doing this):https://experienceleague.adobe.com/docs/campaign-classic/using/installing-campaign-classic/accessing-external-dat...