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

SOLVED

javaScript code activity in Adobe Campaign

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

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.