I'm trying to create filter that works on two columns. The first column "IsActive" = true works properly.
I need to have a second filter on a column that filters for all "ParticipantId" that is a nullable integer type
thatis either null or empty.
Logical this would be an And
Currently this is what I have but it does not work. How would I includea filter for a null integer column using AND logic?
var filterDescriptors = new List<IFilterDescriptor>
{
new CompositeFilterDescriptor{
FilterDescriptors =
[
new FilterDescriptor{
Member = "IsActive",
Operator = FilterOperator.IsEqualTo,
Value = true,
MemberType = typeof(bool)
},
new FilterDescriptor{
Member = "ParticipantId",
Operator = FilterOperator.IsNullOrEmpty,
Value = null,
MemberType = typeof(int)
}
]
}
};