javaScript code activity in Adobe Campaign

Avatar

Avatar
Level 1
peglye66583962
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
peglye66583962
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
peglye66583962
Level 1

19-02-2016

How can i retrieve more than 10000 rows in a queryDef using a javaScript code activity  (I am using SQL Server as Database engine)

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
Amitdeol
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
Applaud 25
View profile

Avatar
Validate 1
Level 2
Amitdeol
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
Applaud 25
View profile
Amitdeol
Level 2

10-06-2016

queryDef is configured to return maximum 10000.

you have two options:

1. Break your query in multiple parts by providing some range or filters

2. write one custom sql script for your query and execute that from your js activity.

Answers (0)