Update CDS with Collection?

[maxandriola]

Hi all,

I have a current situation where I am creating entries in a cds table using a collection.

The collection is tied to a gallery, and then the save button saves it to the entity.

But my issue is that I need to be able to remove items in the gallery and have it update in the cds as well.

I am able to update the collection, but when I save it, it just adds more records on top of the ones that I wanted to delete.

Is there a way to do this effectively? I would need to update not all the records, just ones with a specific lookup id that is associated with a larger entity. 

Thanks!

[maxandriola · Accepted solution]

I found a solution. I just added a RemoveIf function before the Patch. Not sure why I didnt think of this before posting.

[Gelos]

Bro tell me how did you do that.. how to update cds table from collection