Hi all,

We have a use case where we want to filter DOM Instance fetching. We have two field descriptors for the filter. We want to exclude a DOM instance if it satisfies both conditions. The excluded items are lists (not single ones).

Let’s say we have field descriptors 1 and 2.  I want to exclude DOM Instances that have fieldDescriptor1 value A and fieldDescriptor2 value B, fieldDescriptor1 value C and fieldDescriptor2 value D, …The excluded items are (A, B), (C, D), (E, F), …

I tried the following:

var filter1 = excludedItems.Select(e => DomInstanceExposers.FieldValues.DomInstanceField(fieldDescpitorId1).NotEqual(e.Item1));

var filter2 = excludedItems.Select(e => DomInstanceExposers.FieldValues.DomInstanceField(fieldDescpitorId2).NotEqual(e.Item2));

var filters1 = new ANDFilterElement<DomInstance>(filter1.ToArray());

var filters2 = new ANDFilterElement<DomInstance>(filter2.ToArray());

var filters = new ANDFilterElement<DomInstance>(filters1, filters2);

When using the above filtering, the query discards all items that have fieldDescriptor1 value A (whatever the value of fieldDescriptor2 is) and vice versa. So, I want a filter that combines the two filters, meaning discard an instance if fieldDescriptor1 has value A and fieldDescriptor2 has value B.