Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Sheetal11
Level 2
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
ramon_bisswanger
Correct answer by
Employee
Employee

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
ramon_bisswanger
Correct answer by
Employee
Employee

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