javaScript code activity in Adobe Campaign

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Amitdeol

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.

AmitdeolAccepted solution

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.

Sign up