TcxCustomGridTableDateTimeHandling.IgnoreTimeForFiltering Property
Specifies if time is ignored as a filter criterion when filtering data by date/time values.
Declaration
property IgnoreTimeForFiltering: Boolean read; write; default False;
Property Value
Type | Default | Description |
---|---|---|
Boolean | False |
|
Remarks
The TcxGrid control interprets date/time (TDateTime) values with different time parts as different values. You can set the IgnoreTimeForFiltering
property to True
to ignore the time part of date/time values for data filter operations at the grid View level.
Data Item Level Settings
To override the IgnoreTimeForFiltering
property for an individual data item, set the Options.IgnoreTimeForFiltering property to True
(default) or False
for the data item.
Limitations and Considerations
IgnoreTimeForFiltering
(at the grid View level) and Options.IgnoreTimeForFiltering (for individual data items) properties have no effect if the grid View generates SQL queries to apply filter criteria. SQL query generation at the grid View level always takes both date and time into account.
The grid View generates SQL queries to apply filter criteria to the underlying database if one of the following conditions is met:
- The grid View is data-aware and the GridView.DataController.Filter.AutoDataSetFilter property is set to
True
. - The grid View is designed for Server Mode (TcxGridServerModeTableView or TcxGridServerModeBandedTableView).
Default Value
The IgnoreTimeForFiltering
property’s default value is False
.