Angular Entity Filters - conditions

Ben 16 hours ago

Is it possible to do and/or conditions with filters?

For example, the old Portal SQL had this clause:

IdentityType = 'Primary' AND IsInactive =0 AND UID_Person <> '{0}' AND (UID_PersonHead = (SELECT UID_PersonHead FROM Person WHERE UID_Person = '{0}') OR UID_PersonHead = '{0}')

So far, I've got some of it, but I need to AND => OR

public buildFilterForSubstitutees(): FilterData[] {
const filter = [];

// AND conditions

     filter.push({ColumnName: 'IdentityType', CompareOp: CompareOperator.Equal, Type: FilterType.Compare, Value1: 'Primary'});

filter.push({ColumnName: 'IsInactive', CompareOp: CompareOperator.Equal, Type: FilterType.Compare, Value1: 0});

     filter.push({ColumnName: 'UID_Person', CompareOp: CompareOperator.NotEqual, Type: FilterType.Compare, Value1: this.uidPerson});

// Group for OR conditons

         filter.push({ColumnName: 'UID_PersonHead', CompareOp: CompareOperator.Equal, Type: FilterType.Compare, Value1: this.personData.Entities[0]?.Columns?.UID_PersonHead?.Value });

        filter.push({ColumnName: 'UID_PersonHead', CompareOp: CompareOperator.Equal, Type: FilterType.Compare, Value1: this.uidPerson });

// End OR and AND
return filter;
}

btw, the Forum's Insert->Code wouldn't do anything on OK for the function - something was killing it.