In my nms:Recipients, the Adobe Campaign Out Of the Box table,  we have a field called:  manager, that we want to use as BCC. So everytime a client recieves an email, their manager also recieves it.How to do this?  In delivery template I see "Email BCC" , in the delivery tab, but where do I configur...

I tried deleting 5M records where TIPVENTA column is equal to 23, but got this error:  24/09/2023 17:53:46 WDB-200001 SQL statement 'UPDATE BcpLEAD SET FROM wkf58347283_273_1 OutTbl WHERE BcpLEAD.iLEADId=OutTbl.iPKey_1 AND OutTbl.iRecProcState>:#(1)# AND OutTbl.iRecProcState<=:#(2)# AND OutTbl.iPKey...

How to remove whitespaces, tabs, and other elements that are not part of the content of the field?I've a column MES of the format: 202309 (for september of 2023) on format string in the schema and string in the configuration of the import activity.I want to remove whitespaces (tabs, etc) , in order ...

So this is a manual Campaign, it was a Start activity, not a Scheduler activity. So the idea is that user should be able to start the Campaign at anytime, run the queries and so on, but the delivery should arrive to user only between 8 am and 8 pm.So instead of: Iif( Hour(GetDate())<=8 , AddHours(To...

Hi ParthaSarathy, To get all records from LEAD schema, you just select the Targeting dimension and Filtering Dimension as LEAD, and click finish (without putting anything in Filtering conditions, right? 

We have this formula, it tries to contact Recipients between 8 am and 8 pm,  in this case it is set to 9 am.I'd like to make it directly, like: send this delivery the next day at 9 am. Or even better that the user the possibility to insert directly the date: 28/09/23 at 9 am. Iif( Hour(GetDate())<=8...

Actually, according to documentation TRUNCATE is better to delete all rows from a table. See: The  TRUNCATE TABLE statement deletes all data from a table without scanning it. This is the reason why it is faster than the DELETE statement.In addition, the TRUNCATE TABLE statement reclaims the storage ...

I have a table called: LEAD, with namespace: abc. I'm using V7 Classic.I've to remove all rows, since data is flawed and load new data. 1.- Create workflow that: Loads Table Lead:  with no filtering condition since I want to remove all rows from all columns, right? 2.- In a SQL Activity just use:  o...

I don't have a column Year on my data, but I think it is taken the year from my column: "date_creation". How can I remove the miliseconds from my column "date_creation" to avoid this warnings? Or Should I fix this in the source of the data? I get a csv file to upload to campaign. 

When Keep the reject is activated, the workflow gives error: