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

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

Avatar

Avatar
Level 1
Sheetal11
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Sheetal11
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile
Sheetal11
Level 1

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
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
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)