/// <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); }