javaScript code activity in Adobe Campaign

Avatar

Avatar

peglye66583962

Avatar

peglye66583962

peglye66583962

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)

View Entire Topic

Avatar

Avatar

Amitdeol

Avatar

Amitdeol

Amitdeol

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.