Expand my Community achievements bar.

SOLVED

In a workflow - Incremental query activity - @eventDate how can i set to blank after every run towords the end of the workflow ?

Avatar

Level 2

In a workflow - I have Incremental query activity based on- @eventDate in processed data tab. Now for temporary reason , I need full extract. I think manually if i make last execution date of the incrementle query activity to blank then it will automatically will run the full extract. As my rest of the processes are set, I do not want to touch entire workflow but i was thinking at the end of the workflow, i can add update database field and make this "last execution date of the incremental query" to null / blank. ?

 

how do i do it , not sure which dimention i will have to select , also in field to update, what fields i need to update so that "last execution date of the incremental query" will be blank or null. 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

This value is stored as an option in the system:

lastExec_WorkflowInternalName_ActivityName

To reset, you can use Update Data activity to adjust / remove the option value

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

This value is stored as an option in the system:

lastExec_WorkflowInternalName_ActivityName

To reset, you can use Update Data activity to adjust / remove the option value