Back to Devexpress

OptionsColumnFilter.ShowBlanksFilterItems Property

windowsforms-devexpress-dot-xtragrid-dot-columns-dot-optionscolumnfilter-c9090af5.md

latest3.8 KB
Original Source

OptionsColumnFilter.ShowBlanksFilterItems Property

Gets or sets whether the column’s Filter Dropdown (when presented as a Regular List or Checked List) displays the “(Blanks)” and “(Non Blanks)” filter items.

Namespace : DevExpress.XtraGrid.Columns

Assembly : DevExpress.XtraGrid.v25.2.dll

NuGet Packages : DevExpress.Win.Grid, DevExpress.Win.Navigation

Declaration

csharp
[DefaultValue(DefaultBoolean.Default)]
[XtraSerializableProperty]
public virtual DefaultBoolean ShowBlanksFilterItems { get; set; }
vb
<DefaultValue(DefaultBoolean.Default)>
<XtraSerializableProperty>
Public Overridable Property ShowBlanksFilterItems As DefaultBoolean

Property Value

TypeDefaultDescription
DefaultBooleanDefault

A DefaultBoolean value that specifies whether the column’s Filter Dropdown displays the “(Blanks)” and “(Non Blanks)” filter items.

|

Available values:

NameDescriptionReturn Value
True

The value is true.

|

0

| | False |

The value is false.

|

1

| | Default |

The value is specified by a global option or a higher-level object.

|

2

|

Property Paths

You can access this nested property as listed below:

Object TypePath to ShowBlanksFilterItems
GridColumn

.OptionsFilter .ShowBlanksFilterItems

|

Remarks

The paint style of a column’s Filter Dropdown is specified by the OptionsColumnFilter.FilterPopupMode property. When the Filter Dropdown is painted as a Regular List or Checked List, it may contain the “(Blanks)” and “(Non Blanks)” items used to filter records that contain Null (DBNull) values and empty strings.

If the ShowBlanksFilterItems property is set to Default , the “(Blanks)” and “(Non Blanks)” items are present in the Filter Dropdown if the View’s data source contains records with Null or DBNull in the current column. If the ShowBlanksFilterItems property is set to True , the “(Blanks)” and “(Non Blanks)” filter items are always available in the Filter Dropdown. Set the ShowBlanksFilterItems property to False to forcibly hide the “(Blanks)” and “(Non Blanks)” filter items.

Note

For the Filter Dropdown painted as a Checked List, the “(Non Blanks)” item is not supported. The Checked Filter Dropdown supports only the “(Blanks)” item.

See Also

Filter and Search

FilterPopupMode

ShowEmptyDateFilter

OptionsColumnFilter Class

OptionsColumnFilter Members

DevExpress.XtraGrid.Columns Namespace