Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

InderM
InderM
Offline
  • 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...

    Type

    Questions

    Views

    2.9K

    Likes

    2

    Replies

    1
  • 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

    Type

    Questions

    Views

    3.3K

    Likes

    0

    Replies

    0
  • 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={...

    Type

    Questions

    Views

    2.0K

    Like

    1

    Replies

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

    Type

    Questions

    Views

    2.1K

    Likes

    0

    Replies

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

    Type

    Questions

    Views

    4.0K

    Likes

    0

    Replies

    1
Top badges earned by InderM
Customize the badges you want to showcase on your profile