Difference Between A Query And Incremental Query | Community
Skip to main content
S
stephens6273755
Level 3
May 18, 2017
Solved

Difference Between A Query And Incremental Query

  • May 18, 2017
  • 2 replies
  • 3196 views

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

    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 vraghav

    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

    2 replies

    vraghav
    Adobe Employee
    vraghavAdobe EmployeeAccepted solution
    Adobe Employee
    May 19, 2017

    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

      S
      stephens6273755Author
      Level 3
      May 19, 2017

      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

      Terms & ConditionsAccessibility statement

      Loading footer...