Hi All,
We are facing an issue where when we re-xog a dynamic lookup with changed sql the dynamic lookup is getting corrupted i.e. Internal Name and hidden key of the lookup is getting blank though xog result is showing success
After that even if i use the original lookup to xog or use the original query back it is not getting restored though here too xog result is showing success
Is there a way to restore this anyhow without obviously using the old backup / cloning entire DB from working environment
Also please confirm if if the issue is happening because the first field of the sql is getting changed in the changed sql than the original one