Skip to main content
Feb 19, 2016 2:40 PM UTC
Solved

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.
AmitdeolAccepted solution
Level 2
Jun 10, 2016 8:00 AM UTC

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.

1 reply

AmitdeolAccepted solution
Level 2
Jun 10, 2016 8:00 AM UTC

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.

Translate