Clarification on a!writeToDataStoreEntity

I created another CDT as e.g. MY_ENTITY_DATA_MINIMAL with only the fields i need to update + the primary key. It works

Hello Nihar,

I don't see any use of crating the new CDT, you are saying that your table has 5 columns so your CDT will also have 5 fields, even though you don't want to display the other 3 column data, will be fine, however you make query call for all set of data and edit only those you are require to edit, say, your CDT has data as (1, Apple, Mango, Orange, Banana), you just edit Apple and Mango and let the other values to be present in other column. Once you update the value as {Cricket, Hockey} your CDT will be as (1, Cricket, Hockey, Orange, Banana). So when you will write to DB, it will not nullify the data.

Regards,
Ravi

Hello Nihar,

I don't see any use of crating the new CDT, you are saying that your table has 5 columns so your CDT will also have 5 fields, even though you don't want to display the other 3 column data, will be fine, however you make query call for all set of data and edit only those you are require to edit, say, your CDT has data as (1, Apple, Mango, Orange, Banana), you just edit Apple and Mango and let the other values to be present in other column. Once you update the value as {Cricket, Hockey} your CDT will be as (1, Cricket, Hockey, Orange, Banana). So when you will write to DB, it will not nullify the data.

Regards,
Ravi

Yes Ravi. This is also an alternative. I just intended not to query the other columns which the user will not be updating.
Regards
Nihar