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

Badges

Badges
6

Accepted Solutions

Accepted Solutions
1

Likes Received

Likes Received
3

Posts

Posts
5

Discussions

Discussions
0

Questions

Questions
5

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by InderM
Customize the badges you want to showcase on your profile
Re: How do i get auto incremental key from my sequence? - Adobe Campaign 12-02-2020
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 strSql = sqlExec(temp); Let me know if it works. Regards,

Views

2.7K

Likes

2

Replies

1
Re: How do we pass more than one value(array) of values f... - Adobe Campaign 08-02-2020
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

Views

3.0K

Likes

0

Replies

0
Re: How to add insert data which is populated from enrinc... - Adobe Campaign 08-02-2020
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;} hope this helps.

Views

1.9K

Like

1

Replies

1
Re: How to build a dynamic URL in a delivery - Adobe Campaign 06-02-2020
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 tagetDate variable both in workflow and delivery and see what result you re getting. Hope this helps Regards

Views

1.9K

Likes

0

Replies

0
Re: Identifying & dropping orphan temp tables - Adobe Campaign 06-02-2020
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 workflows where this option is checked and send an email to admins/operators who can see this list in their inbox and take action, or inform end users to take action. This is not direct solution, but at...

Views

3.6K

Likes

0

Replies

1