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

Avatar

Avatar

Sheetal11

Avatar

Sheetal11

Sheetal11

13-10-2020

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. 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

ramon_bisswange

Employee

Avatar

ramon_bisswange

Employee

ramon_bisswange
Employee

14-10-2020

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

Answers (0)