Question

How to bind data if you want to delete some existing records

Hi All,

We are using the data binding tool of marketplace. For example, I have created a lookup column and add some records in it and bound data and sent, Team has installed the data in their environment. 

Now, I have deleted some records and add a few, and bind data again. In this case a data element is being created for only few newly created records. I am unable to bind that these records need to be deleted. I have tried 'update existing' installation type as well, It is not working.  

We are facing an issue from long time. It has become a mess when we deployed in test. Please provide a solution for this issue and which method we have to follow usually in these scenarios

Like 0

Like

3 comments

You can create SQL script in the package and delete data with this script.



Another way is to use records deactivation in Lookup object. And bind column 'Inactive'

Vladimir Sokolov,

 

Thank you for the reply.

 

What can I do for already deleted records in the lookup objects that has been deployed to Test.

 

Is there a way to generate delete scripts

Hi Nagaraju,

 

The add-on provides a simple way to bind data using the out-of-the-box binding functionality. My guess is that deleted records are not bound in a way similar to new and modified records because of possible issues with backward compatibility and data integrity.

 

I recommend a more detailed check-up on how the deleted records are used. Then delete them on the test site manually making sure that the related records are deleted as well. 

Show all comments