SQL (OnPrem) - Refresh Data Bug

[Delid4ve]

Something not quite right with data gateway service.

Load SQL data into a collection

change data in collection

patch data back to sql and clear collection

refresh datasource

load data into collection again

the changes are not populated even though they have been patched and the data source refreshed.

In order to load the changes i am having to do

refresh datasource

collect

clear collection

refresh

collect

there is definitely a bug here can somebody please advise. its not right that the datasource is not refreshing until the 2nd collect. and ive tried multiple refreshes and it makes no difference

[goobernoodles]

That did the trick for me as well.  I guess I should probably read the details a little further next time.  Here's a before and after screen capture:

https://www.youtube.com/watch?v=VMP5-Nl0r7w

[Delid4ve]

I think maybe we need a link next to each experimental/preview feature that takes us to known issues and bugs for each one, this can be updated when things are fixed / reported. Think that’s about the third time one of them has broken something without me realising.

[Delid4ve]

Has this been added as a default now?

I seem to be back to this situation, however the option is no longer there...