Hi,You can do it in schema, please check in schema, it should be configured like below In javascript, you need to define it like belowvar temp="INSERT INTO gowSampleDB(sSTG_ID,sATTRB_CD,sATTRB_VAL) VALUES ( yourSequenceName.NEXTVAL,'GOWTHAMANTEST','GOWTHAMTEST1')";logInfo("My query :"+temp);var strS...

Hi,You can define your variables in two(or more) separate variables in javscript activity and then in query activity use two(or more) different conditions with OR operator(separate condition for every variable with same column of table). I think this should work if i understood it correctly. Regards

Hi,you can use queryDef to fetch the data from targetSchema as shown below var conditionVar="@age > 25";// example conditionvar recordSet = xtk.queryDef.create();var allRecords = recordSet.ExecuteQuery();for each (var rec in allRecords){var var1=rec.std_id;var var2=rec.name;//your INSERT statement;}...

Hi,Can you please share what error you received on browser? In delivery, you need to pass targetData from your Campaign's workflow, if looks like either the target data is not defined correctly or the null value is getting passed as the target data. You can also debug your code, try to print tagetDa...

Hi,Temp tables will not automatically cleaned when you unchecked the interim run results option after workflow finished, as the temp tables are already created so un-checking will not effect anything. You need to ask end users to follow best practices.You can create a utility workflow to list all wo...