/// <summary>
/// Filter by static field for NULL or NOT NULL
/// </summary>
/// <param name="staticFieldProperty">Static field name</param>
/// <param name="fieldFilter">Filter type</param>
public void AddStaticFieldFilter(string staticFieldProperty, ParaEnums.FieldValueFilter fieldFilter)
{
string filterValue = "";
switch (fieldFilter)
{
case ParaEnums.FieldValueFilter.IsNotNull:
filterValue = "_IS_NOT_NULL_";
break;
case ParaEnums.FieldValueFilter.IsNull:
filterValue = "_IS_NULL_";
break;
}
QueryFilterAdd(staticFieldProperty, ParaEnums.QueryCriteria.Equal, filterValue);
}
/// <summary>
/// Add a custom field filter for NULL or NOT NULL. Use with any custom fields
/// </summary>
/// <param name="customFieldId">
/// The id of the multi value custom field you would like to filter your query on.
/// </param>
/// <param name="fieldFilter">Null or Not Null filter</param>
public void AddCustomFieldFilter(Int64 customFieldId, ParaEnums.FieldValueFilter fieldFilter)
{
string filterValue = "";
switch (fieldFilter)
{
case ParaEnums.FieldValueFilter.IsNotNull:
filterValue = "_IS_NOT_NULL_";
break;
case ParaEnums.FieldValueFilter.IsNull:
filterValue = "_IS_NULL_";
break;
}
QueryFilterAdd("FID" + customFieldId, ParaEnums.QueryCriteria.Equal, filterValue);
}
