Hi,You can do it in schema, please check in schema, it should be configured like below<element autopk="true" name="<yourUniqueFieldName>"pkSequence="<yourSequenceName>" > In javascript, you need to define it like belowvar temp="INSERT INTO gowSampleDB(sSTG_ID,sATTRB_CD,sATTRB_VAL) VALUES ( yourSeque...

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(<queryDef schema={vars.targetSchema} operation="select"><select><node expr="@std_id"/><node expr="@name"/></select><where><condition expr={...

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 tagetD...

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...