Hello,You can create a SQL activity and add:   BEGIN FOR c IN ( select table_name from all_tables inner join bradapps.nmsgroup tmp on instr(table_name,to_char(tmp.igroupid)) > 0 where table_name like 'GRP%' and trunc(sysdate) - trunc(tmp.tscreated) > 31 and trunc(sysdate) - trunc(tmp.tslastmodified)...

Is there a way to put a default value if the column does not exists? or Do I need to create it like:IsEmptyString(NoNull([targetData/@test]),'',[targetData/@test] ) ?Thanks

Is there a way to put a default value if the column does not exists? or Do I need to create it like: IsEmptyString([targetData/@test],'' ,[targetData/@test] ) ?

Is there a way to put a default value if the column does not exists?

Hello.I am facing a problem when creating a direct delivery template.I want to add some columns to the extraction file and collect this values from the targetData.Here is a part of the extraction file:Output columns: (notice they have alias assigned:targetData: What I want to accomplish is that the ...

Hello!If you want to send multiple variables, the only way It worked for me was like this:vars.firstName = 'Manuel';varLastName = 'Cantillo';xtk.workflow.PostEvent("myWorkFlow", "mySignal", "",<variables varFirstName={vars.firstName} varLastName={vars.lastName} />,false); On the "myWorkFlow" after t...

Hello!I want to see if it is possible to have a log for the alerts emails sent in a technical workflow?Thanks