Hi Community,
Any example how to do server side esq to delete records with multiple filter condition?
Thanks
Like
1 comments
12:39 Mar 07, 2022
Hello Fulgen,
You can find many examples by searching terrasoft source code files if You have local instance of Creatio.
One of example with multiple filters is from UpdateTargetAudienceProcessHelper.MarketingCommon.cs
public virtual void ClearCurrentTargets() { new Delete(UserConnection) .From(TargetSchemaName) .Where("IsFromGroup").IsEqual(Column.Parameter(true)) .And(TargetSchemaBindingColumnValueName).IsEqual(Column.Parameter(RootSchemaRecordId)) .And(ResponseColumnName).IsEqual(Column.Parameter(DefResponseId)) .Execute(); }
Best regards,
Marcin
Show all comments