Hi Community.
I have this piece of code:
segmentationBatch is List
but postgres throws an error that it can't compare uuid with uuid[] - which is understandable, but how do I pass a list of Id's into the update?
Has anyone came accross this issue?
P.S. I need it that way because it's a batch of records that I need to update and I need to keep those Id's for the following logic so I cannot rebuild the filtering criteria here.
var update = new Update(UserConnection, EntitySchemaName) .Set("UsrProfitCenter", Column.Parameter(segmentation.ProfitCenter)) .Where("Id").In(Column.Parameter(segmentationBatch)) as Update; return update.Execute();
Like
1 comments
02:32 Jul 27, 2024
Upd:
Figured it out myself
.Where("Id").In(Column.Parameters(segmentationBatch))
Show all comments