Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Difference Between A Query And Incremental Query

Avatar

Level 2

I am new to Adobe and trying to understand all the functionality.


Can someone please explain the difference between a Query and Incremental Query, and a potential example use case?

As far as I can tell, the incremental query can be used to ensure that someone only enters a workflow if they haven't already entered it before. But it seems like you can control that in the Scheduler, so I am just trying to make sure I understand the differences and use cases.

Thanks so much for any insights!!


Steve

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi Steve,

Both the activities are used to query database based on a filtering criterion and feed the output to the rest of workflow.

Query activity will simply pass on the entire output but Incremental activity will match the query data against the data it has sent out in past and only the new ones are allowed to move forward.

Incremental query comes handy when you have to send out a welcome email to all new joiners. You can simply put the filtering criteria to say recipient created on or after 18th May 2017 and then schedule it to run every day.

On 20th, it will fetch records created since 18th May but then compare it against the output created on 19th May and pass only the ones that have not been contacted till now.

Regards,

Vipul

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

Hi Steve,

Both the activities are used to query database based on a filtering criterion and feed the output to the rest of workflow.

Query activity will simply pass on the entire output but Incremental activity will match the query data against the data it has sent out in past and only the new ones are allowed to move forward.

Incremental query comes handy when you have to send out a welcome email to all new joiners. You can simply put the filtering criteria to say recipient created on or after 18th May 2017 and then schedule it to run every day.

On 20th, it will fetch records created since 18th May but then compare it against the output created on 19th May and pass only the ones that have not been contacted till now.

Regards,

Vipul

Avatar

Level 2

Thanks Vipul! That makes sense and is helpful.

Just so I can understand, can this type of filter also be set up in the program scheduler by setting the "Maximum Number Of Iterations" as 1. Or is "Maximum Number Of Iterations" used to control something else?

Thanks!


Steve